原文:http://www.cnblogs.com/wangzhq/archive/2006/09/14/504309.html#1744469
using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.Common; using System.Configuration; using System.Collections; namespace Ths { /**//// <summary> ======================================================== /// /// wangzhq.cnblogs.com /// 数据工厂类,实现了跨数据库的操作. /// ======================================================== /// </summary> public class DataAccess:PageBase { /**//// <summary> /// Webconfig配置连接字符串 /// </summary> private string _confirString = "ConnectionString"; /**//// <summary> /// 数据工厂类 /// </summary> public DataAccess() { } /**//// <summary> /// 数据工厂类 /// </summary> /// <param name="configString">web.config 关键字</param> public DataAccess(string configString) { ConfigString = configString; } /**//// <summary> /// 属性,设置数据库连接字符串 /// </summary> public string ConfigString { get { return _confirString; } set { _confirString = value; } } //==============================================GetProviderName============================== 获得数据库的类型 public string GetProviderName(string ConfigString)#region 获得数据库的类型 public string GetProviderName(string ConfigString) /**//// <summary> /// 返回数据提供者 /// </summary> /// <returns>返回数据提供者</returns> public string GetProviderName(string ConfigString) { ConnectionStringSettingsCollection ConfigStringCollention = ConfigurationManager.ConnectionStrings; if (ConfigStringCollention == null || ConfigStringCollention.Count <= 0) { throw new Exception("web.config 中无连接字符串!"); } ConnectionStringSettings StringSettings = null; if (ConfigString == string.Empty) { StringSettings = ConfigurationManager.ConnectionStrings["ConnectionString"]; } else { StringSettings = ConfigurationManager.ConnectionStrings[ConfigString]; } return StringSettings.ProviderName; } /**//// <summary> /// 返回数据提供者 /// </summary> /// <returns></returns> public string GetProviderName() { return GetProviderName(ConfigString); } #endregion //=====================================================获得连接字符串==================================== /**//// <summary> /// 获得连接字符串 /// </summary> /// <returns></returns> public string GetConnectionString(string ConfigString) { ConnectionStringSettingsCollection ConfigStringCollention = ConfigurationManager.ConnectionStrings; if (ConfigStringCollention == null || ConfigStringCollention.Count <= 0) { throw new Exception("web.config 中无连接字符串!"); } ConnectionStringSettings StringSettings = null; if (ConfigString == string.Empty) { StringSettings = ConfigurationManager.ConnectionStrings["ConnectionString"]; } else { StringSettings = ConfigurationManager.ConnectionStrings[ConfigString]; } return StringSettings.ConnectionString; } public string GetConnectionString() { return GetConnectionString(ConfigString); } //==============================================GetDbproviderFactory========================= 返回数据工厂 public DbProviderFactory GetDbProviderFactory()#region 返回数据工厂 public DbProviderFactory GetDbProviderFactory() /**//// <summary> /// 返回数据工厂 /// </summary> /// <returns></returns> public DbProviderFactory GetDbProviderFactory() { DbProviderFactory f = null; string ProviderName = GetProviderName(); switch (ProviderName) { case "System.Data.SqlClient": f = GetDbProviderFactory("System.Data.SqlClient"); break; case "System.Data.OracleClient": f = GetDbProviderFactory("System.Data.OracleClient"); break; case "System.Data.OleDb": f = GetDbProviderFactory("System.Data.OleDb"); break; default: f = GetDbProviderFactory("System.Data.SqlClient"); break; } return f; } /**//// <summary> /// 返回数据工厂 /// </summary> /// <param name="providername"></param> /// <returns></returns> public DbProviderFactory GetDbProviderFactory(string providername) { return DbProviderFactories.GetFactory(providername); } #endregion //==============================================CreateConnection============================= 创建数据库连接 public DbConnection CreateConnection()#region 创建数据库连接 public DbConnection CreateConnection() /**//// <summary> /// 创建数据库连接 /// </summary> /// <returns></returns> public DbConnection CreateConnection() { DbConnection con = GetDbProviderFactory().CreateConnection(); con.ConnectionString = GetConnectionString(); return con; } /**//// <summary> /// 创建数据库连接 /// </summary> /// <param name="provdername"></param> /// <returns></returns> public DbConnection CreateConnection(string provdername) { DbConnection con = GetDbProviderFactory(provdername).CreateConnection(); con.ConnectionString = GetConnectionString(); return con; } #endregion //==============================================CreateCommand================================ 创建执行命令对象 public override DbCommand CreateCommand(string sql, CommandType cmdType, DbParameter[] parameters)#region 创建执行命令对象 public override DbCommand CreateCommand(string sql, CommandType cmdType, DbParameter[] parameters) /**//// <summary> /// 创建执行命令对象 /// </summary> /// <param name="sql"></param> /// <param name="cmdType"></param> /// <param name="parameters"></param> /// <returns></returns> public DbCommand CreateCommand(string sql, CommandType cmdType, DbParameter[] parameters) { DbCommand _command = GetDbProviderFactory().CreateCommand(); _command.Connection = CreateConnection(); _command.CommandText = sql; _command.CommandType = cmdType; if (parameters != null && parameters.Length > 0) { foreach (DbParameter param in parameters) { _command.Parameters.Add(param); } } return _command; } /**//// <summary> /// 创建执行命令对象 /// </summary> /// <param name="sql">SQL语句</param> /// <returns>执行命令对象实例</returns> public DbCommand CreateCommand(string sql) { DbParameter[] parameters = new DbParameter[0]; return CreateCommand(sql, CommandType.Text, parameters); } /**//// <summary> /// 创建执行命令对象 /// </summary> /// <param name="sql">SQL语句</param> /// <returns>执行命令对象实例</returns> public DbCommand CreateCommand(string sql, CommandType cmdtype) { DbParameter[] parameters = new DbParameter[0]; return CreateCommand(sql, cmdtype, parameters); } /**//// <summary> /// 创建执行命令对象 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="parameters">参数</param> /// <returns>执行命令对象实例</returns> public DbCommand CreateCommand(string sql, DbParameter[] parameters) { return CreateCommand(sql, CommandType.Text, parameters); } #endregion //=========================================CreateAdapter()============================================== 创建数据适配器 CreateAdapter(string sql)#region 创建数据适配器 CreateAdapter(string sql) /**//// <summary> /// 创建数据适配器 /// </summary> /// <param name="sql">SQL,语句</param> /// <returns>数据适配器实例</returns> public DbDataAdapter CreateAdapter(string sql) { DbParameter[] parameters = new DbParameter[0]; return CreateAdapter(sql, CommandType.Text, parameters); } /**//// <summary> /// 创建数据适配器 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <returns>数据适配器实例</returns> public DbDataAdapter CreateAdapter(string sql, CommandType cmdtype) { DbParameter[] parameters = new DbParameter[0]; return CreateAdapter(sql, cmdtype, parameters); } /**//// <summary> /// 创建数据适配器 /// </summary> /// <param name="connectionString">数据库连接字符串</param> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>数据适配器实例</returns> public DbDataAdapter CreateAdapter(string sql, CommandType cmdtype, DbParameter[] parameters) { DbConnection _connection = CreateConnection(); DbCommand _command = GetDbProviderFactory().CreateCommand(); _command.Connection = _connection; _command.CommandText = sql; _command.CommandType = cmdtype; if (parameters != null && parameters.Length > 0) { foreach (DbParameter _param in parameters) { _command.Parameters.Add(_param); } } DbDataAdapter da = GetDbProviderFactory().CreateDataAdapter(); da.SelectCommand = _command; return da; } #endregion //=========================================CreateParameter=================================== 生成参数 public override SqlParameter CreateParameter(string field, string dbtype, string value)#region 生成参数 public override SqlParameter CreateParameter(string field, string dbtype, string value) /**//// <summary> /// 创建参数 /// </summary> /// <param name="field">参数字段</param> /// <param name="dbtype">参数类型</param> /// <param name="value">参数值</param> /// <returns></returns> public DbParameter CreateParameter(string field, string dbtype, string value) { DbParameter p = GetDbProviderFactory().CreateParameter(); p.ParameterName = field; p.Value = value; return p; } #endregion //======================================================ExecuteCommand()============================================ 执行非查询语句,并返回受影响的记录行数 ExecuteCommand(string sql)#region 执行非查询语句,并返回受影响的记录行数 ExecuteCommand(string sql) /**//// <summary> /// 执行非查询语句,并返回受影响的记录行数 /// </summary> /// <param name="sql">SQL语句</param> /// <returns>受影响记录行数</returns> public int ExecuteCommand(string sql) { DbParameter[] parameters = new DbParameter[0]; return ExecuteCommand(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行非查询语句,并返回受影响的记录行数 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <returns>受影响记录行数</returns> public int ExecuteCommand(string sql, CommandType cmdtype) { DbParameter[] parameters = new DbParameter[0]; return ExecuteCommand(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行非查询语句,并返回受影响的记录行数 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="parameters">参数</param> /// <returns>受影响记录行数</returns> public int ExecuteCommand(string sql, DbParameter[] parameters) { return ExecuteCommand(sql, CommandType.Text, parameters); } /**//// <summary> ///批量执行SQL语句 /// </summary> /// <param name="SqlList">SQL列表</param> /// <returns></returns> public bool ExecuteCommand(ArrayList SqlList) { DbConnection con = CreateConnection(); con.Open(); bool iserror = false; string strerror = ""; DbTransaction SqlTran =con.BeginTransaction(); try { for (int i = 0; i < SqlList.Count; i++) { DbCommand _command = GetDbProviderFactory().CreateCommand(); _command.Connection = con; _command.CommandText = SqlList[i].ToString(); _command.Transaction = SqlTran; _command.ExecuteNonQuery(); } } catch (Exception ex) { iserror = true; strerror = ex.Message; } finally { if (iserror) { SqlTran.Rollback(); throw new Exception(strerror); } else { SqlTran.Commit(); } con.Close(); } if (iserror) { return false; } else { return true; } } /**//// <summary> /// 执行非查询语句,并返回受影响的记录行数 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>受影响记录行数</returns> public int ExecuteCommand(string sql, CommandType cmdtype, DbParameter[] parameters) { int _result = 0; DbCommand _command = CreateCommand(sql, cmdtype, parameters); try { _command.Connection.Open(); _result = _command.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception(ex.Message); } finally { _command.Connection.Close(); } return _result; } #endregion //=====================================================ExecuteScalar()============================================= 执行非查询语句,并返回首行首列的值 ExecuteScalar(string sql)#region 执行非查询语句,并返回首行首列的值 ExecuteScalar(string sql) /**//// <summary> /// 执行非查询语句,并返回首行首列的值 /// </summary> /// <param name="sql">SQL语句</param> /// <returns>Object</returns> public object ExecuteScalar(string sql) { DbParameter[] parameters = new DbParameter[0]; return ExecuteScalar(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行非查询语句,并返回首行首列的值 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <returns>Object</returns> public object ExecuteScalar(string sql, CommandType cmdtype) { DbParameter[] parameters = new DbParameter[0]; return ExecuteScalar(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行非查询语句,并返回首行首列的值 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="parameters">参数</param> /// <returns>Object</returns> public object ExecuteScalar(string sql, DbParameter[] parameters) { return ExecuteScalar(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行非查询语句,并返回首行首列的值 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>Object</returns> public object ExecuteScalar(string sql, CommandType cmdtype, DbParameter[] parameters) { object _result=null; DbCommand _command = CreateCommand(sql, cmdtype, parameters); try { _command.Connection.Open(); _result = _command.ExecuteScalar(); } catch { throw; } finally { _command.Connection.Close(); } return _result; } #endregion //=====================================================ExecuteReader()============================================= 执行查询,并以DataReader返回结果集 ExecuteReader(string sql)#region 执行查询,并以DataReader返回结果集 ExecuteReader(string sql) /**//// <summary> /// 执行查询,并以DataReader返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <returns>IDataReader</returns> public DbDataReader ExecuteReader(string sql) { DbParameter[] parameters = new DbParameter[0]; return ExecuteReader(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行查询,并以DataReader返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <returns>IDataReader</returns> public DbDataReader ExecuteReader(string sql, CommandType cmdtype) { DbParameter[] parameters = new DbParameter[0]; return ExecuteReader(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行查询,并以DataReader返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="parameters">参数</param> /// <returns>IDataReader</returns> public DbDataReader ExecuteReader(string sql, DbParameter[] parameters) { return ExecuteReader(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行查询,并以DataReader返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>IDataReader</returns> public DbDataReader ExecuteReader(string sql, CommandType cmdtype, DbParameter[] parameters) { DbDataReader _result; DbCommand _command = CreateCommand(sql, cmdtype, parameters); try { _command.Connection.Open(); _result = _command.ExecuteReader(CommandBehavior.CloseConnection); } catch { throw; } finally { } return _result; } #endregion //=====================================================GetDataSet()================================================ 执行查询,并以DataSet返回结果集 GetDataSet(string sql)#region 执行查询,并以DataSet返回结果集 GetDataSet(string sql) /**//// <summary> /// 执行查询,并以DataSet返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <returns>DataSet</returns> public DataSet GetDataSet(string sql) { DbParameter[] parameters = new DbParameter[0]; return GetDataSet(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行查询,并以DataSet返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <returns>DataSet</returns> public virtual DataSet GetDataSet(string sql, CommandType cmdtype) { DbParameter[] parameters = new DbParameter[0]; return GetDataSet(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行查询,并以DataSet返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="parameters">参数</param> /// <returns>DataSet</returns> public virtual DataSet GetDataSet(string sql, DbParameter[] parameters) { return GetDataSet(sql, CommandType.Text, parameters); } /**//// <summary> /// 执行查询,并以DataSet返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>DataSet</returns> public virtual DataSet GetDataSet(string sql, CommandType cmdtype, DbParameter[] parameters) { DataSet _result = new DataSet(); IDataAdapter _dataAdapter = CreateAdapter(sql, cmdtype, parameters); try { _dataAdapter.Fill(_result); } catch { throw; } finally { } return _result; } /**//// <summary> /// 执行查询,并以DataSet返回指定记录的结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="StartIndex">开始索引</param> /// <param name="RecordCount">显示记录</param> /// <returns>DataSet</returns> public virtual DataSet GetDataSet(string sql, int StartIndex, int RecordCount) { return GetDataSet(sql, StartIndex, RecordCount); } #endregion //=====================================================GetDataView()=============================================== 执行查询,并以DataView返回结果集 GetDataView(string sql)#region 执行查询,并以DataView返回结果集 GetDataView(string sql) /**//// <summary> /// 执行查询,并以DataView返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>DataView</returns> public DataView GetDataView(string sql) { DbParameter[] parameters = new DbParameter[0]; DataView dv = GetDataSet(sql, CommandType.Text, parameters).Tables[0].DefaultView; return dv; } /**//// <summary> /// 执行查询,并以DataView返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>DataView</returns> public DataView GetDataView(string sql, CommandType cmdtype) { DbParameter[] parameters = new DbParameter[0]; DataView dv = GetDataSet(sql, cmdtype, parameters).Tables[0].DefaultView; return dv; } /**//// <summary> /// 执行查询,并以DataView返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>DataView</returns> public DataView GetDataView(string sql, DbParameter[] parameters) { DataView dv = GetDataSet(sql, CommandType.Text, parameters).Tables[0].DefaultView; return dv; } /**//// <summary> /// 执行查询,并以DataView返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>DataView</returns> public DataView GetDataView(string sql, CommandType cmdtype, DbParameter[] parameters) { DataView dv = GetDataSet(sql, cmdtype, parameters).Tables[0].DefaultView; return dv; } /**//// <summary> /// 执行查询,并以DataView返回指定记录的结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="StartIndex">开始索引</param> /// <param name="RecordCount">显示记录</param> /// <returns>DataView</returns> public DataView GetDataView(string sql, int StartIndex, int RecordCount) { return GetDataSet(sql, StartIndex, RecordCount).Tables[0].DefaultView; } #endregion //=====================================================GetDataTable()============================================== 执行查询,并以DataTable返回结果集 GetDataTable(string sql)#region 执行查询,并以DataTable返回结果集 GetDataTable(string sql) /**//// <summary> /// 执行查询,并以DataTable返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>DataTable</returns> public DataTable GetDataTable(string sql) { DbParameter[] parameters = new DbParameter[0]; DataTable dt = GetDataSet(sql, CommandType.Text, parameters).Tables[0]; return dt; } /**//// <summary> /// 执行查询,并以DataTable返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>DataTable</returns> public DataTable GetDataTable(string sql, CommandType cmdtype) { DbParameter[] parameters = new DbParameter[0]; DataTable dt = GetDataSet(sql, cmdtype, parameters).Tables[0]; return dt; } /**//// <summary> /// 执行查询,并以DataTable返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>DataTable</returns> public DataTable GetDataTable(string sql, DbParameter[] parameters) { DataTable dt = GetDataSet(sql, CommandType.Text, parameters).Tables[0]; return dt; } /**//// <summary> /// 执行查询,并以DataTable返回结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="cmdtype">命令类型</param> /// <param name="parameters">参数</param> /// <returns>DataTable</returns> public DataTable GetDataTable(string sql, CommandType cmdtype, DbParameter[] parameters) { DataTable dt = GetDataSet(sql, cmdtype, parameters).Tables[0]; return dt; } /**//// <summary> /// 执行查询,并以DataTable返回指定记录的结果集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="StartIndex">开始索引</param> /// <param name="RecordCount">显示记录</param> /// <returns>DataTable</returns> public DataTable GetDataTable(string sql, int StartIndex, int RecordCount) { return GetDataSet(sql, StartIndex, RecordCount).Tables[0]; } /**//// <summary> /// 执行查询,返回以空行填充的指定条数记录集 /// </summary> /// <param name="sql">SQL语句</param> /// <param name="SizeCount">显示记录条数</param> /// <returns>DataTable</returns> public DataTable GetDataTable(string sql, int SizeCount) { DataTable dt = GetDataSet(sql).Tables[0]; int b = SizeCount - dt.Rows.Count; if (dt.Rows.Count < SizeCount) { for (int i = 0; i < b; i++) { DataRow dr = dt.NewRow(); dt.Rows.Add(dr); } } return dt; } #endregion } }
您还没有登录,请您登录后再发表评论
数据工厂访问多种数据库类,Oracle,oledb,Sql,Odbc.
可以实现在Web端无需事先手工编写或自动创建任何程序代码和数据实体类的情况下, 便可在Silverlight端对Web端数据库进行增加、删除、修改、查询等数据操作。此外, 还支持访问数据库的存储过程(StoredProcdures)、视图...
DbProviderFactory同时支持Sql Server和Oracle的注意事项,以及DbProviderFactory的用法
NET 2.0有一个抽象工厂模式的典型应用:通过DBProviderFactory 可以对不同数据库进行操作。
在Data.Dynamic命名空间的ObjectiveExtension类中,定义了一套IDbClient的扩展方法,能够使用更快捷的方式进行数据库操作。 .net对象传参 这些扩展方法具有与IDbClient中的方法很类似的签名,但能够接收一个用于...
采用DbProviderFactory 挂载不同数据库驱动,实现多数据库访问; 源码建议采用vs2019+ 打开; 源码包含同步,异步 其中 oracle与sqlserver 已测试并在使用中。 Wsw.DataAccess已上传Nuget,可以直接Nuget安装。此为...
数据库操作类 利用DbProviderFactory了. <br>1,方便,简单,扩展(复杂的话,专业的多多,不容自己来考虑) 2,方便无主键表的更新 3,方便输出到Excel(可以利用Select ..From [Sheet1$]来选择Excel数据再传...
一个通用的数据访问类,用vb.net实现,利用工厂模型,通过DbProviderFactory创建。
最近一直在思考如何做一个支持多种数据库的程序,打印了很多的资料,在.NET 2.0中,新增加了DbProviderFactory抽象工厂类,让数据层基类可以实现多种数据库,但在数据访问层中的参数部分我觉得是个麻烦。
conn.DbProviderFactory = "System.Data.SQLite.SQLiteFactory"; //创建一个数据命令 DbCommandSyn cmd = new DbCommandSyn(); //设置命令的连接 cmd.Connection = conn; //设置SQL语句,可以是存储过程 ...
EasyDb.NET 是一个 .NET 的非常轻量级的数据库操作助手类。内部由 Dapper 驱动。 示例代码: IConnectionFactory factory; // build factory with given DbProviderFactory and Dialect. factory = ...
12.2.3.Spring.NET提供的切入点实现类 12.2.3.1.静态切入点 12.2.3.2.动态切入点 12.2.4.自定义切入点 12.3.Spring.NET的通知类型 12.3.1.通知的生命周期 12.3.2.通知类型 12.3.2.1.拦截环绕通知 12.3.2.2.前置通知 ...
//设置数据工厂,这里是Oledb方式的数据工厂 conn.DbProviderFactory = "System.Data.OleDb.OleDbFactory"; //创建一个数据命令 DbCommandSyn cmd = new DbCommandSyn(); //设置命令的连接 cmd.Connection =...
今天有个朋友测试 SQLite,然后得出... // 创建数据库文件 File.Delete(“test1.db3”); SQLiteConnection.CreateFile(“test1.db3”); DbProviderFactory factory = SQLiteFactory.Instance; using (DbConnect
查询速度超快的数据库,自己测试过插入1000条数据,不用1秒时间! 官方主页: http://sqlite.phxsoftware.com/ 演示代码: using System; using System.Collections.Generic; using System.Text; using System.Data; ...
DbProviderFactory factory = SQLiteFactory.Instance; using (DbConnection conn = factory.CreateConnection()) { // 连接数据库 conn.ConnectionString = "Data Source=test1.db3"; conn.Open(); ...
DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DBHelper.dbProviderName); DbConnection dbconn = dbfactory.CreateConnection(); dbconn.ConnectionString = DBHelper.dbConnectionString; ...
相关推荐
数据工厂访问多种数据库类,Oracle,oledb,Sql,Odbc.
可以实现在Web端无需事先手工编写或自动创建任何程序代码和数据实体类的情况下, 便可在Silverlight端对Web端数据库进行增加、删除、修改、查询等数据操作。此外, 还支持访问数据库的存储过程(StoredProcdures)、视图...
DbProviderFactory同时支持Sql Server和Oracle的注意事项,以及DbProviderFactory的用法
NET 2.0有一个抽象工厂模式的典型应用:通过DBProviderFactory 可以对不同数据库进行操作。
在Data.Dynamic命名空间的ObjectiveExtension类中,定义了一套IDbClient的扩展方法,能够使用更快捷的方式进行数据库操作。 .net对象传参 这些扩展方法具有与IDbClient中的方法很类似的签名,但能够接收一个用于...
采用DbProviderFactory 挂载不同数据库驱动,实现多数据库访问; 源码建议采用vs2019+ 打开; 源码包含同步,异步 其中 oracle与sqlserver 已测试并在使用中。 Wsw.DataAccess已上传Nuget,可以直接Nuget安装。此为...
数据库操作类 利用DbProviderFactory了. <br>1,方便,简单,扩展(复杂的话,专业的多多,不容自己来考虑) 2,方便无主键表的更新 3,方便输出到Excel(可以利用Select ..From [Sheet1$]来选择Excel数据再传...
一个通用的数据访问类,用vb.net实现,利用工厂模型,通过DbProviderFactory创建。
最近一直在思考如何做一个支持多种数据库的程序,打印了很多的资料,在.NET 2.0中,新增加了DbProviderFactory抽象工厂类,让数据层基类可以实现多种数据库,但在数据访问层中的参数部分我觉得是个麻烦。
conn.DbProviderFactory = "System.Data.SQLite.SQLiteFactory"; //创建一个数据命令 DbCommandSyn cmd = new DbCommandSyn(); //设置命令的连接 cmd.Connection = conn; //设置SQL语句,可以是存储过程 ...
EasyDb.NET 是一个 .NET 的非常轻量级的数据库操作助手类。内部由 Dapper 驱动。 示例代码: IConnectionFactory factory; // build factory with given DbProviderFactory and Dialect. factory = ...
12.2.3.Spring.NET提供的切入点实现类 12.2.3.1.静态切入点 12.2.3.2.动态切入点 12.2.4.自定义切入点 12.3.Spring.NET的通知类型 12.3.1.通知的生命周期 12.3.2.通知类型 12.3.2.1.拦截环绕通知 12.3.2.2.前置通知 ...
//设置数据工厂,这里是Oledb方式的数据工厂 conn.DbProviderFactory = "System.Data.OleDb.OleDbFactory"; //创建一个数据命令 DbCommandSyn cmd = new DbCommandSyn(); //设置命令的连接 cmd.Connection =...
今天有个朋友测试 SQLite,然后得出... // 创建数据库文件 File.Delete(“test1.db3”); SQLiteConnection.CreateFile(“test1.db3”); DbProviderFactory factory = SQLiteFactory.Instance; using (DbConnect
查询速度超快的数据库,自己测试过插入1000条数据,不用1秒时间! 官方主页: http://sqlite.phxsoftware.com/ 演示代码: using System; using System.Collections.Generic; using System.Text; using System.Data; ...
DbProviderFactory factory = SQLiteFactory.Instance; using (DbConnection conn = factory.CreateConnection()) { // 连接数据库 conn.ConnectionString = "Data Source=test1.db3"; conn.Open(); ...
DbProviderFactory dbfactory = DbProviderFactories.GetFactory(DBHelper.dbProviderName); DbConnection dbconn = dbfactory.CreateConnection(); dbconn.ConnectionString = DBHelper.dbConnectionString; ...