代码如下 public class DataFacade { /// <summary> /// 数据库名称 /// </summary> private const string dbName = "TestDb"; private static DbProviderFactory factory; /// <summary> /// 连接字符串 /// </summary> private static string connectionString; /// <summary> /// /// </summary> static DataFacade() { ConnectionStringSettings settings = ConfigurationManager.ConnectionStrings[dbName]; factory = DbProviderFactories.GetFactory(settings.ProviderName); connectionString = settings.ConnectionString; } /// <summary> /// 创建连接 /// </summary> /// <returns></returns> private static DbConnection CreateConnection() { DbConnection connection = factory.CreateConnection(); connection.ConnectionString = DataFacade.connectionString; return connection; } /// <summary> /// 调用示例 /// </summary> /// <param name="sql"></param> /// <returns></returns> public DataSet ExecuteQuery(string sql) { if (string.IsNullOrEmpty(sql)) { throw new ArgumentNullException("sql"); } using (DbConnection connection = CreateConnection()) { DbCommand command = connection.CreateCommand(); command.CommandText = sql; command.CommandType = CommandType.Text; DbDataAdapter adapter = factory.CreateDataAdapter(); adapter.SelectCommand = command; DataSet result = new DataSet(); adapter.Fill(result); return result; } } } 这是一个与驱动无关的方式实现数据库访问,可以是SqlServe 也可以是其它数据库