public ConnectionManager(IRootPathProvider rootPathProvider) { this.factory = DbProviderFactories.GetFactory("System.Data.SQLite"); this.databaseName = Path.Combine(rootPathProvider.GetRootPath(), "data.db"); CreateDatabase(); }
public AdoResponseCache(DbProviderFactory factory, string connectionString) { _factory = factory; _connectionString = connectionString; EnsureTableExists(); }
private int LastInsertedId() { string lib = GetProviderFactoryLib(providerName); System.Data.Common.DbProviderFactory provider = RegisterProvider(providerName); DbConnection con = provider.CreateConnection(); con.ConnectionString = BuildConnectionString(providerName, this.dbName); DbCommand com = provider.CreateCommand(); com.CommandTimeout = 30; com.Connection = con; com.CommandText = LastInsertIdCommand(providerName); com.CommandType = CommandType.Text; int lastId = 0; try { con.Open(); com.Prepare(); lastId = Convert.ToInt32(com.ExecuteScalar()); } catch (Exception ex) { throw ex; } con.Close(); return(lastId); }
private System.Data.Common.DbProviderFactory RegisterProvider(string providerName) { System.Data.Common.DbProviderFactory f = null; if (this.providerName == ProviderFactoryType.MySql.ToString()) { using (var dt = new DataTable()) { dt.Columns.Add("Name"); dt.Columns.Add("Description"); dt.Columns.Add("InvariantName"); dt.Columns.Add("AssemblyQualifiedName"); dt.Rows.Add("ADO.Net driver for MySQL", "mysql more", "mysqlClient", "MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.7.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d"); f = DbProviderFactories.GetFactory(dt.Rows[0]); } } if (this.providerName == ProviderFactoryType.SQLServer.ToString()) { using (var dt = new DataTable()) { dt.Columns.Add("Name"); dt.Columns.Add("Description"); dt.Columns.Add("InvariantName"); dt.Columns.Add("AssemblyQualifiedName"); dt.Rows.Add("SqlClient Data Provider", "SqlClient Data Provider", "System.Data.SqlClient", "System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"); f = DbProviderFactories.GetFactory(dt.Rows[0]); } } return(f); }
public static bool CheckMembershipSchemaVersion (DbProviderFactory factory, string connStr, string feature, string compatibleVersion) { using (DbConnection connection = CreateConnection (factory, connStr)) { DbCommand command = factory.CreateCommand (); command.Connection = connection; command.CommandText = @"aspnet_CheckSchemaVersion"; command.CommandType = CommandType.StoredProcedure; AddParameter (factory, command, "@Feature", ParameterDirection.Input, feature); AddParameter (factory, command, "@CompatibleSchemaVersion", ParameterDirection.Input, compatibleVersion); DbParameter returnValue = AddParameter (factory, command, "@ReturnVal", ParameterDirection.ReturnValue, null); try { command.ExecuteNonQuery (); } catch (Exception) { throw new ProviderException ("ASP.NET Membership schema not installed."); } if ((int) (returnValue.Value ?? -1) == 0) return true; return false; } }
internal static DbProviderServices GetProviderServices(DbProviderFactory factory) { EDesignUtil.CheckArgumentNull(factory, "factory"); // Special case SQL client so that it will work with System.Data from .NET 4.0 even without // a binding redirect. if (factory is SqlClientFactory) { return SqlProviderServices.Instance; } IServiceProvider serviceProvider = factory as IServiceProvider; if (serviceProvider == null) { throw MetadataUtil.ProviderIncompatible(System.Data.Entity.Design.Strings.EntityClient_DoesNotImplementIServiceProvider( factory.GetType().ToString())); } DbProviderServices providerServices = serviceProvider.GetService(typeof(DbProviderServices)) as DbProviderServices; if (providerServices == null) { throw MetadataUtil.ProviderIncompatible( System.Data.Entity.Design.Strings.EntityClient_ReturnedNullOnProviderMethod( "GetService", factory.GetType().ToString())); } return providerServices; }
private void Initialize(string connectionStringName) { connectionStringName = string.IsNullOrEmpty(connectionStringName) ? "default" : connectionStringName; ConnectionConfig info = SimpleDALConfig.GetConnectionConfig(connectionStringName); _ConnectionString = info.ConnectionString; _Schema = SimpleDALConfig.GetSchemaService(info.ProviderName); _IsCustomToken = info.IsCustomToken; _Factory = DbProviderFactories.GetFactory(info.ProviderName); _ParamToken = _Schema.ParameterToken; _Connection = CreateConnection(); _DalLogger = SimpleDALConfig.GetLogService(info.LoggerName); _IsLoggable = info.IsDebug; _SessionID = Guid.NewGuid().ToString(); Info("New Create SimpleDB"); Debug("Connection Name is: " + connectionStringName); Debug("Provider is " + info.ProviderName); }
public DataAccess(DbProviderFactory factory, string connectionString, string provider, int? commandTimeout) { _factory = factory; _provider = provider; _commandTimeout = commandTimeout; _connection = GetConnection(connectionString); }
public DbBase(ConnObject co) { this.connObject = co; this.conn = co.Master.Conn; this.providerName = co.Master.ProviderName; dalType = co.Master.ConnDalType; _fac = GetFactory(providerName); _con = _fac.CreateConnection(); _con.ConnectionString = DalCreate.FormatConn(dalType, conn); _com = _con.CreateCommand(); if (_com != null)//Txt| Xml 时返回Null { _com.Connection = _con; _com.CommandTimeout = AppConfig.DB.CommandTimeout; } if (IsAllowRecordSql)//开启秒表计算 { _watch = new Stopwatch(); } //if (AppConfig.DB.LockOnDbExe && dalType == DalType.Access) //{ // string dbName = DataBase; // if (!_dbOperator.ContainsKey(dbName)) // { // try // { // _dbOperator.Add(dbName, false); // } // catch // { // } // } //} //_com.CommandTimeout = 1; }
internal static EntityCommandDefinition CreateCommandDefinition(DbProviderFactory storeProviderFactory, DbCommandTree commandTree) { DebugCheck.NotNull(storeProviderFactory); DebugCheck.NotNull(commandTree); return new EntityCommandDefinition(storeProviderFactory, commandTree); }
private DbConfiguration(string providerName, string connectionString, DbProviderFactory dbProviderFactory) { this.providerName = providerName; this.connectionString = connectionString; this.dbProviderFactory = dbProviderFactory; this.dbDriver = currentDbDrivers[providerName]; }
public void SetConfiguration() { try { string ConnectionStringName = ConfigurationManager.ConnectionStrings["InmoCon"].ConnectionString; if (ConnectionStringName == "") { strProvider = ""; strConnectionString = ""; } else { strProvider = ConfigurationManager.ConnectionStrings["InmoCon"].ProviderName; strConnectionString = ConfigurationManager.ConnectionStrings["InmoCon"].ConnectionString; } if (dbFactory != null) { dbFactory = null; } if (strProvider != "") { dbFactory = DbProviderFactories.GetFactory(strProvider); } } catch (Exception ex) { throw ex; } }
/// <summary> /// Initializes a new instance of the <see cref="DatabaseManager"/> class. /// </summary> /// <param name="connectionProvider">The connection provider.</param> /// <param name="providerName">Name of the provider.</param> public DatabaseManager(DbProvider provider, string connectionString) { string providerName = provider.GetEnumMemberValue(); this.connectionProvider = DbProviderFactories.GetFactory(providerName); this.providerName = providerName; this.connectionString = connectionString; }
// SchemaReader.ReadSchema public override Tables ReadSchema(DbConnection connection, DbProviderFactory factory) { var result=new Tables(); this._connection=connection; this._factory=factory; var cmd=this._factory.CreateCommand(); cmd.Connection=connection; cmd.CommandText=TABLE_SQL; //cmd.GetType().GetProperty("BindByName").SetValue(cmd, true, null); //pull the tables in a reader using(cmd) { using (var rdr=cmd.ExecuteReader()) { while(rdr.Read()) { Table tbl=new Table(); tbl.Name=rdr["name"].ToString(); tbl.Schema = ""; tbl.IsView=String.Compare(rdr["type"].ToString(), "view", true)==0; tbl.CleanName=CleanUp(tbl.Name); tbl.ClassName=Inflector.MakeSingular(tbl.CleanName); tbl.SQL = rdr["sql"].ToString(); result.Add(tbl); } } } foreach (var tbl in result) { tbl.Columns=this.LoadColumns(tbl); tbl.Indexes = this.LoadIndices(tbl.Name); tbl.ForeignKeys = this.LoadForeignKeys(tbl.Name); } return result; }
/* * Method to get a database connection from the server or local embedded database. * built on generic ADO.Net */ public static DbConnection GetUasAdoConnection() { DbConnection dbConn = null; try { System.Configuration.ConnectionStringSettings connectionString = new System.Configuration.ConnectionStringSettings(); if (SessionHelper.IsVentureMode) { connectionString = DataContext.getUASEntitiesAdoVenture(); } else { connectionString = System.Configuration.ConfigurationManager.ConnectionStrings[DataContext.GetUasConnectionStringName()]; } // Loads the factory System.Data.Common.DbProviderFactory factory = System.Data.Common.DbProviderFactories.GetFactory(connectionString.ProviderName); dbConn = factory.CreateConnection(); dbConn.ConnectionString = connectionString.ConnectionString; } catch (Exception ex) { Debug.WriteLine("* * * GetUasAdoConnection: " + ex.Message); // GetProviderFactoryClasses(); } return(dbConn); }
/// <summary> /// Create a dynamic model /// </summary> /// <param name="connectionStringName">the connection string name or the connection stirng itself</param> /// <param name="tableName">the table name</param> /// <param name="primaryKeyField">the primary key field name</param> public DynamicModel(string connectionStringName, string tableName = "", string primaryKeyField = "") { TableName = string.IsNullOrEmpty(tableName) ? GetType().Name : tableName; PrimaryKeyField = string.IsNullOrEmpty(primaryKeyField) ? "ID" : primaryKeyField; try { _factory = DbProviderFactories.GetFactory(ProviderName); } catch (FileLoadException ex) { throw new MassiveException(string.Format("Could not load the specified provider: {0}. Have you added a reference to the correct assembly?", ProviderName), ex); } catch (ArgumentException e) { var foundClasses = "I did find these Factories:"; var dt = DbProviderFactories.GetFactoryClasses(); for (var i = 0; i < dt.Rows.Count; i++) foundClasses += String.Format("|{0}|", dt.Rows[i][2]); throw new ArgumentException(String.Format("{0}{1}{2}", e.Message, Environment.NewLine, foundClasses)); } var conString = ConfigurationManager.ConnectionStrings[connectionStringName]; _connectionString = conString != null ? conString.ConnectionString : connectionStringName; }
/// <summary> /// Initializes a new instance of the <see cref="T:DbProvider"/> class. /// </summary> /// <param name="connStr">The conn STR.</param> /// <param name="dbProviderFactory">The db provider factory.</param> protected DbProvider(string connStr, System.Data.Common.DbProviderFactory dbProviderFactory) { dbConnStrBuilder = new DbConnectionStringBuilder(); dbConnStrBuilder.ConnectionString = connStr; this.dbProviderFactory = dbProviderFactory; }
public IDbConnection GetConnection(string connectionString, string provider) { System.Data.Common.DbProviderFactory factory = System.Data.Common.DbProviderFactories.GetFactory(provider); System.Data.Common.DbConnection conn = factory.CreateConnection(); conn.ConnectionString = connectionString; return(conn); }
private static SDC.DbCommand BuildCommand(string sproc, List <ParamStruct> list) { SDC.DbProviderFactory factory = SDC.DbProviderFactories.GetFactory(Properties.Settings.Default.provider); SDC.DbCommand comm = factory.CreateCommand(); comm.CommandText = sproc; comm.CommandType = System.Data.CommandType.StoredProcedure; SDC.DbParameter param = factory.CreateParameter(); foreach (ParamStruct item in list) { param.ParameterName = item.paramId; param.Value = item.paramValue; param.DbType = item.paramType; param.Size = item.paramLength; param.Direction = item.paramDirection; comm.Parameters.Add(param); param = factory.CreateParameter(); } return(comm); }
/// <summary>Instancia a DbFactory "setando a string de conexao" /// </summary> public DAOFactory(string connectionStringValue, string provider) { AppSettingsReader apps = new AppSettingsReader(); objProvider = DbProviderFactories.GetFactory(provider); connectionString = connectionStringValue; objConn = objProvider.CreateConnection(); }
public int CreateDatabase(String queryString) { string lib = GetProviderFactoryLib(providerName); System.Data.Common.DbProviderFactory provider = RegisterProvider(providerName); DbConnection con = provider.CreateConnection(); con.ConnectionString = BuildConnectionString(providerName, ""); int rowsAffected = 0; try { con.Open(); DbCommand com = provider.CreateCommand(); com.CommandTimeout = 30; com.Connection = con; com.CommandText = queryString; com.CommandType = CommandType.Text; object result = com.ExecuteNonQuery(); if (result != null) { rowsAffected = Convert.ToInt32(result); } } catch (Exception ex) { throw ex; } con.Close(); return(rowsAffected); }
private static async Task<IEnumerable<Fortune>> LoadRows(string connectionString, DbProviderFactory dbProviderFactory) { var result = new List<Fortune>(); using (var db = dbProviderFactory.CreateConnection()) using (var cmd = db.CreateCommand()) { cmd.CommandText = "SELECT [Id], [Message] FROM [Fortune]"; db.ConnectionString = connectionString; await db.OpenAsync(); using (var rdr = await cmd.ExecuteReaderAsync(CommandBehavior.CloseConnection)) { while (await rdr.ReadAsync()) { result.Add(new Fortune { Id = rdr.GetInt32(0), Message = rdr.GetString(1) }); } } } result.Add(new Fortune { Message = "Additional fortune added at request time." }); result.Sort(); return result; }
private static async Task<World> LoadRow(string connectionString, DbProviderFactory dbProviderFactory) { using (var db = dbProviderFactory.CreateConnection()) using (var cmd = db.CreateCommand()) { cmd.CommandText = "SELECT [Id], [RandomNumber] FROM [World] WHERE [Id] = @Id"; var id = cmd.CreateParameter(); id.ParameterName = "@Id"; id.DbType = DbType.Int32; id.Value = _random.Next(1, 10001); cmd.Parameters.Add(id); db.ConnectionString = connectionString; await db.OpenAsync(); using (var rdr = await cmd.ExecuteReaderAsync(CommandBehavior.CloseConnection)) { await rdr.ReadAsync(); return new World { Id = rdr.GetInt32(0), RandomNumber = rdr.GetInt32(1) }; } } }
private FindByUserDatabase(IRepositoryContext context, DbProviderFactory providerFactory, string connectionString) { Context = context; ProviderFactory = providerFactory; ConnectionString = connectionString; Connection = GetConnection(); }
/// <summary> /// Ham nay de mo ket noi den database /// </summary> /// <param name="ServerName"></param> /// <param name="DatabaseName"></param> /// <param name="UserId"></param> /// <param name="Password"></param> /// <returns></returns> public static bool DB_OpenConnection(string ServerName, string DatabaseName, string UserId, string Password) { DbProviderFactory = System.Data.SqlClient.SqlClientFactory.Instance; DbConnectionStringBuilder DbConnectionStringBuilder = DbProviderFactory.CreateConnectionStringBuilder(); DbConnectionStringBuilder.Add("Data Source", ServerName); DbConnectionStringBuilder.Add("User ID", UserId); DbConnectionStringBuilder.Add("Password", Password); DbConnectionStringBuilder.Add("Initial Catalog", DatabaseName); bool IsConnected; try { if (DbConnection == null) { DbConnection = DbProviderFactory.CreateConnection(); } if (DbConnection.State != ConnectionState.Open) { DbConnection.ConnectionString = DbConnectionStringBuilder.ConnectionString; DbConnection.Open(); } IsConnected = true; } catch { IsConnected = false; } return(IsConnected); }
/// <summary> /// 构造函数--重载方法二 /// </summary> /// <param name="connectionstring">数据库链接</param> /// <param name="databasetype">数据库的类型</param> public DBHelper(string connectionstring, string databasetype) { MyFactory = DbProviderFactories.GetFactory(databasetype); MyConnection = MyFactory.CreateConnection(); MyConnection.ConnectionString = (databasetype.ToString() == "System.Data.OleDb") ? ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + GetDataPath(connectionstring) + ";") : (connectionstring); MyCommand = MyConnection.CreateCommand(); }
internal StubDataMapper(DbProviderFactory dbfactory, DbCommand command, DbConnection connection, DbParameterCollection parameters) : base(dbfactory, "connection string") { _command = command; _connection = connection; _parameters = parameters; }
private DbCommand BuildInsertCommand(System.Data.Common.DbProviderFactory provider, DbConnection con) { DbCommand com = provider.CreateCommand(); com.CommandType = CommandType.Text; com.Connection = con; string fieldList = SetFieldList(); if (providerName == ProviderFactoryType.MySql.ToString()) { com.CommandText = String.Format("Insert Into {0} SET {1}", this.tableName, fieldList) + ";" + this.LastInsertIdCommand(providerName); foreach (DataRow row in this.tableStruct.Rows) { MySqlParameter parameter = new MySqlParameter(); parameter.ParameterName = "?" + row["fieldName"]; parameter.MySqlDbType = GetMySqlType(row["ValueType"].ToString()); parameter.SourceColumn = row["fieldName"].ToString(); parameter.IsNullable = true; if (row["fieldName"].ToString() == this.identityColumn) { parameter.Direction = ParameterDirection.Output; } else { parameter.Direction = ParameterDirection.Input; } com.Parameters.Add(parameter); } } return(com); }
public DynamicModel(ConnectionStringSettings settings, DbProviderFactory factory) { Errors = new List<string>(); _dbProviderFactory = factory; _connectionString = settings.ConnectionString; }
public ProxyDbConnection(DbConnection proxiedConnection, DbProviderFactory proxiedFactory) { ProxiedConnection = proxiedConnection; ProxiedFactory = proxiedFactory; Context = GetContext(this); Guid = System.Guid.NewGuid().ToString(); }
public DynamicModel(ConnectionStringSettings settings, string providerName = "System.Data.SqlClient") { Errors = new List<string>(); _dbProviderFactory = DbProviderFactories.GetFactory(providerName); _connectionString = settings.ConnectionString; }
public CachedFactory(DbProviderFactory factory, string factoryName, string factoryDescription, string factoryAssemblyQualifiedNameKey) { Factory = factory; FactoryName = factoryName; FactoryDescription = factoryDescription; FactoryAssemblyQualifiedNameKey = factoryAssemblyQualifiedNameKey; }
/// <summary> /// Initializes a new instance of the <see cref="DynamicModel"/> class. /// </summary> /// <param name="connectionStringName">Name of the connection string.</param> /// <param name="tableName">Name of the table.</param> /// <param name="primaryKeyField">The primary key field.</param> /// <remarks></remarks> public DynamicModel(string connectionStringName = "", string tableName = "", string primaryKeyField = "") { this.TableName = tableName == "" ? this.GetType().Name : tableName; this.PrimaryKeyField = string.IsNullOrEmpty(primaryKeyField) ? "ID" : primaryKeyField; if (connectionStringName == "") { connectionStringName = ConfigurationManager.ConnectionStrings[0].Name; } var providerName = "System.Data.SqlClient"; if (ConfigurationManager.ConnectionStrings[connectionStringName] != null) { if (!string.IsNullOrEmpty(ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName)) { providerName = ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName; } } else { throw new InvalidOperationException(string.Format("Can't find a connection string with the name '{0}'", connectionStringName)); } this._factory = DbProviderFactories.GetFactory(providerName); this._connectionString = ConfigurationManager.ConnectionStrings[connectionStringName].ConnectionString; }
/// <summary> /// 通过name 、数据库连接串、提供者名称, 创建database实例 /// </summary> /// <param name="name">DBDatabase名称,唯一,主键</param> /// <param name="connectionString">数据库连接串</param> /// <param name="providername">数据库提供者名称</param> /// <returns>database实例</returns> public static Database Create(string name, string connectionString, string strDBtype) { if (string.IsNullOrEmpty(connectionString)) { throw new ArgumentNullException("connectionString", String.Format(DbError.ConnstrNull)); } if (string.IsNullOrEmpty(strDBtype)) { throw new ArgumentNullException("providername", String.Format(DbError.ProviderNameNull)); } string providername = getProviderName(strDBtype); System.Data.Common.DbProviderFactory fact = System.Data.Common.DbProviderFactories.GetFactory(providername); if (null == fact) { throw new ArgumentNullException("providername", String.Format(DbError.InvalidProviderNameForConn, providername)); } DBProvider datafact = DBProvider.GetProvider(providername); if (null == datafact) { throw new ArgumentNullException("providername", String.Format(DbError.InvalidProviderNameForDBFactory, providername)); } Database db = datafact.CreateDatabase(connectionString, providername, fact); //设置名字 db.Name = name; //返回实例 return(db); }
/// <summary> /// 构造函数 /// </summary> /// <param name="dbConnectString">链接字符串</param> /// <param name="dbProviderNamespace">数据提供者的命名空间,例如:"System.Data.SqlClient"</param> public DBHelper(string dbConnectString, string dbProviderNamespace) { dbProviderFactory = DbProviderFactories.GetFactory(dbProviderNamespace); dbConnection = dbProviderFactory.CreateConnection(); dbConnection.ConnectionString = dbConnectString; dbCommand = dbConnection.CreateCommand(); }
internal static EntityCommandDefinition CreateCommandDefinition(DbProviderFactory storeProviderFactory, DbCommandTree commandTree) { //Contract.Requires(storeProviderFactory != null); //Contract.Requires(commandTree != null); return new EntityCommandDefinition(storeProviderFactory, commandTree); }
private static object CreateObject(DbProviderFactory factory, ProviderSupportedClasses kindOfObject, string providerName) { switch (kindOfObject) { case ProviderSupportedClasses.DbConnection: return factory.CreateConnection(); case ProviderSupportedClasses.DbDataAdapter: return factory.CreateDataAdapter(); case ProviderSupportedClasses.DbParameter: return factory.CreateParameter(); case ProviderSupportedClasses.DbCommand: return factory.CreateCommand(); case ProviderSupportedClasses.DbCommandBuilder: return factory.CreateCommandBuilder(); case ProviderSupportedClasses.DbDataSourceEnumerator: return factory.CreateDataSourceEnumerator(); case ProviderSupportedClasses.CodeAccessPermission: return factory.CreatePermission(PermissionState.None); } throw new InternalException(string.Format(CultureInfo.CurrentCulture, "Cannot create object of provider class identified by enum {0} for provider {1}", new object[] { Enum.GetName(typeof(ProviderSupportedClasses), kindOfObject), providerName })); }
public SqlWriterCommonTest(SqlType sqlType, DatabaseTable table, DbProviderFactory factory, string connectionString) { _connectionString = connectionString; _factory = factory; _table = table; _sqlType = sqlType; }
protected DbProvider(string connectionString, System.Data.Common.DbProviderFactory dbProviderFactory) { this.dbConnectionStringBuilder = new DbConnectionStringBuilder(); this.dbConnectionStringBuilder.ConnectionString = connectionString; this.dbProviderFactory = dbProviderFactory; }
public SQLQueryProvider(DbProviderFactory dbFactory, string dbConnStr, string tableName, SetterDelegate setter) { m_dbFactory = dbFactory; m_dbConnStr = dbConnStr; m_tableName = tableName; m_setter = setter; }
protected DbProvider(string connectionString, System.Data.Common.DbProviderFactory dbFactory, char leftToken, char rightToken, char paramPrefixToken) { this.leftToken = leftToken; this.rightToken = rightToken; this.paramPrefixToken = paramPrefixToken; this.dbHelper = new DbHelper(connectionString, dbFactory); this.Timeout = -1; }
public DbConnectionEx(DbConnection inner, IAopFilter appender, Guid connectionId, System.Data.Common.DbProviderFactory providerFactory) { this.inner = inner; this.providerFactory = providerFactory; this.connectionId = connectionId; this.appender = appender; appender.ConnectionStarted(connectionId); }
public SqlQueryFactory(char leftToken, char rightToken, char paramPrefixToken, char wildcharToken, char wildsinglecharToken, System.Data.Common.DbProviderFactory fac) { this.leftToken = leftToken; this.rightToken = rightToken; this.paramPrefixToken = paramPrefixToken; this.wildcharToken = wildcharToken; this.wildsinglecharToken = wildsinglecharToken; this.fac = fac; }
/// <summary> /// Initializes a new instance of the <see cref="T:DbProvider"/> class. /// </summary> /// <param name="connectionString">The conn STR.</param> /// <param name="dbProviderFactory">The db provider factory.</param> /// <param name="leftToken">leftToken</param> /// <param name="paramPrefixToken">paramPrefixToken</param> /// <param name="rightToken">rightToken</param> protected DbProvider(string connectionString, DbProviderFactory dbProviderFactory, char leftToken, char rightToken, char paramPrefixToken) { dbConnStrBuilder = new DbConnectionStringBuilder(); dbConnStrBuilder.ConnectionString = connectionString; this.dbProviderFactory = dbProviderFactory; this.leftToken = leftToken; this.rightToken = rightToken; this.paramPrefixToken = paramPrefixToken; }
public DataTable RetrieveTableStructure(string tableName) { DataTable tableStruct = new DataTable(); string lib = GetProviderFactoryLib(providerName); System.Data.Common.DbProviderFactory provider = RegisterProvider(providerName); DbConnection con = provider.CreateConnection(); con.ConnectionString = BuildConnectionString(providerName, ""); DbCommand com = provider.CreateCommand(); com.CommandTimeout = 30; com.Connection = con; string queryString = ""; if (providerName == ProviderFactoryType.MySql.ToString()) { queryString = string.Format(@" SELECT lower( Column_name) as FieldName, Column_name as FieldCaption, Data_type As ValueType, 0 As ColumnIsHide, 0 As FieldIsHide, 0 As IsFake, 0 As IsReadOnly, 0 As IsRequiered, '' As FieldCategory, '' As UserHelp, Extra As Extra, if( isnull( Character_Maximum_Length),Numeric_Precision, Character_Maximum_Length) As Length, if( isnull(Numeric_Scale), 000, Numeric_Scale) As DecimalPosition From information_schema.COLUMNS Where Table_Schema = '{0}' And LOWER(Table_Name) = '{1}'" , this.dbName, tableName.ToLower()).Replace("\r", "").Replace("\n", " ").Replace("\t", " ").Replace(" ", " "); } com.CommandText = queryString; com.CommandType = CommandType.Text; DataSet ds = new DataSet(); DbDataAdapter da = provider.CreateDataAdapter(); da.SelectCommand = com; try { con.Open(); da.Fill(ds); tableStruct = ds.Tables[0]; } catch (Exception ex) { throw ex; } con.Close(); return(tableStruct); }
private void ClickSelectedIndexChanged(object sender, EventArgs e) { if (comboBoxProviders.SelectedItem != null) { factory = DbProviderFactories.GetFactory(comboBoxProviders.SelectedItem.ToString()); connection = factory.CreateConnection(); providerName = GetConnectionStringByProvider(comboBoxProviders.SelectedItem.ToString()); textBoxConnectionString.Text = providerName; } }
public static void PinFor() { string tblname = "RDBMS_Table_ADONET_RegressionTest_" + Guid.NewGuid().ToString().Replace("-", ""); System.Data.Common.DbProviderFactory fact = DbProviderFactories.GetFactory("DSpace_DataProvider"); DbConnection conn = fact.CreateConnection(); conn.ConnectionString = "Data Source = localhost"; conn.Open(); DbCommand cmd = conn.CreateCommand(); //Create table { cmd.CommandText = "CREATE TABLE " + tblname + " (num INT, str CHAR(40), num2 LONG, num3 DOUBLE)"; int rows = cmd.ExecuteNonQuery(); } //Select from table { cmd.CommandText = "SELECT PIN FOR 10 * FROM " + tblname; DbDataReader reader = cmd.ExecuteReader(); reader.Close(); } //Drop table { cmd.CommandText = "DROP PIN FOR 20 TABLE " + tblname + ""; cmd.ExecuteNonQuery(); } //Select from table bool ok = false; { try { cmd.CommandText = "SELECT PIN FOR 10 * FROM " + tblname; DbDataReader reader = cmd.ExecuteReader(); reader.Close(); } catch { ok = true; } } conn.Close(); if (!ok) { throw new Exception("Table didn't get dropped."); } }
public SqlQueryFactory(char leftToken, char rightToken, char paramPrefixToken, char wildcharToken, char wildsinglecharToken, System.Data.Common.DbProviderFactory fac) { Check.Require(fac != null, "fac could not be null!"); this.leftToken = leftToken; this.rightToken = rightToken; this.paramPrefixToken = paramPrefixToken; this.wildcharToken = wildcharToken; this.wildsinglecharToken = wildsinglecharToken; this.fac = fac; }
/// <summary> /// 数据库提供者工厂实例,取配置文件 /// </summary> private static System.Data.Common.DbProviderFactory GetProviderFactory() { if (_mfactory == null) { DbConnection dbConnection = null; dbConnection = new SQLiteConnection(_msConnection); _mfactory = DbProviderFactories.GetFactory(dbConnection); } return(_mfactory); }
public Database(string _connectionString, System.Data.Common.DbProviderFactory dbProviderFactory) { if (string.IsNullOrEmpty(_connectionString)) { throw new ArgumentException("", "connectionString"); } if (dbProviderFactory == null) { throw new ArgumentNullException("dbProviderFactory"); } this.connectionString = _connectionString; this.dbProviderFactory = dbProviderFactory; }
public static void DbAggregators_DropTable(string tablename) { System.Data.Common.DbProviderFactory fact = DbProviderFactories.GetFactory("DSpace_DataProvider"); DbConnection conn = fact.CreateConnection(); conn.ConnectionString = "Data Source = localhost"; conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.CommandText = "drop table " + tablename; cmd.ExecuteNonQuery(); conn.Close(); }
public static SDC.DbDataReader ReadData(string sproc, List <ParamStruct> paramList) { SDC.DbProviderFactory factory = SDC.DbProviderFactories.GetFactory(Properties.Settings.Default.provider); SDC.DbCommand comm = factory.CreateCommand(); comm = BuildCommand(sproc, paramList); SDC.DbConnection conn = Connection(factory); comm.Connection = conn; conn.Open(); SDC.DbDataReader dr = comm.ExecuteReader(System.Data.CommandBehavior.CloseConnection); return(dr); }
/// <summary> /// 获取TNS信息 /// Columns:InstanceName,ServerName,ServiceName,Protocol,Port /// </summary> /// 需要安装ODP.NET /// <returns></returns> internal static DataTable GetTNSInstance() { try { System.Data.Common.DbProviderFactory factory = System.Data.Common.DbProviderFactories.GetFactory("Oracle.DataAccess.Client"); if (factory.CanCreateDataSourceEnumerator) { System.Data.Common.DbDataSourceEnumerator dsenum = factory.CreateDataSourceEnumerator(); return(dsenum.GetDataSources()); //InstanceName,ServerName,ServiceName,Protocol,Port } } catch { } return(null); }
public static void ConnClose() { System.Data.Common.DbProviderFactory fact = DbProviderFactories.GetFactory("DSpace_DataProvider"); DbConnection conn = fact.CreateConnection(); conn.ConnectionString = "Data Source = localhost"; conn.Open(); conn.Close(); if (conn.State != ConnectionState.Closed) { throw new Exception("FAILED: State = {0}" + conn.State.ToString()); } }
//{ //{ProviderType.DB2,"IBM.Data.DB2.DB2Factory,IBM.Data.DB2, Culture=neutral,Version=9.7.7.4,PublicKeyToken=7c307b91aa13d208"}, //{ProviderType.SQLite,"Devart.Data.SQLite.SQLiteProviderFactory, Devart.Data.SQLite, Culture=neutral, Version=5.2.244.0, PublicKeyToken=09af7300eec23701"}, //{ProviderType.Oracle,"Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Culture=neutral, Version=4.121.2.0,PublicKeyToken=89b483f429c47342"},//Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342 //{ProviderType.MySql,"MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data.MySqlClient, Culture=neutral, Version=5.1.7.0, PublicKeyToken=c5687fc88969c44d"}, //{ProviderType.MsOracle,"System.Data.OracleClient.OracleClientFactory,System.Data.OracleClient, Culture=neutral,Version=4.0.0.0, PublicKeyToken=b77a5c561934e089"}, //{ProviderType.OleDb,"System.Data.OleDb.OleDbFactory, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c"}, //{ProviderType.SqlServer,"System.Data.SqlClient.SqlClientFactory, System.Data, Culture=neutral, Version=4.0.0.0, PublicKeyToken=b77a5c561934e089"}, //{ProviderType.Odbc,"System.Data.Odbc.OdbcFactory, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"} //}; /// <summary> /// 构造 /// </summary> /// <param name="dbProviderType"></param> /// <param name="IsSingleton"></param> protected DbCommonBuilder(ProviderType dbProviderType, bool IsSingleton) { this.IsSingleton = IsSingleton; this.DbProviderType = dbProviderType; string invariantName = GetInvariantName(dbProviderType); dbFactory = GetDbProviderFactory(invariantName); if (dbFactory == null) { throw new Exception("不提供支持该" + dbProviderType.ToString() + "类型的实例"); } }
private System.Data.Common.DbCommandBuilder getDbCommandBuilder(string providerName) { System.Data.Common.DbCommandBuilder returnValue = null; if (!String.IsNullOrEmpty(providerName)) { System.Data.Common.DbProviderFactory factory = System.Data.Common.DbProviderFactories.GetFactory(providerName); if (factory != null) { returnValue = factory.CreateCommandBuilder(); } } return(returnValue); }
public void RecordUpdate <T>(out int rowsAffected, T row) { rowsAffected = 0; readConectionSettings(); string lib = GetProviderFactoryLib(providerName); provider = RegisterProvider(providerName); con = provider.CreateConnection(); con.ConnectionString = BuildConnectionString(providerName, dbName); tableStruct = RetrieveTableStructure(tableName); if (tableStruct.Columns.Count == 0) { return; } dataAdapter = provider.CreateDataAdapter(); dataAdapter.UpdateCommand = BuildUpdateCommand(provider, con); dataAdapter.AcceptChangesDuringFill = true; dataAdapter.AcceptChangesDuringUpdate = true; dataAdapter.ContinueUpdateOnError = false; DbCommand updCmd = dataAdapter.UpdateCommand; Console.WriteLine("Update cmd: " + updCmd.CommandText); try { updCmd.Connection.Open(); foreach (DbParameter parameter in updCmd.Parameters) { string fieldName = parameter.SourceColumn; parameter.Value = row.GetType().GetProperty(fieldName).GetValue(row, null); if (fieldName == identityColumn) { parameter.SourceVersion = DataRowVersion.Original; } } object returnVal = updCmd.ExecuteNonQuery(); rowsAffected = Convert.ToInt16(returnVal); } catch (Exception ex) { throw ex; } finally { updCmd.Connection.Close(); } }
/* * Method to test the database provider version (only use for testing) */ public static string GetProviderVersion() { string versionInfo = String.Empty; try { // SELECT COUNT(*) // VistaDBConnection sqlConn = new VistaDBConnection("data source='|DataDirectory|\forms.vdb5';Password=aj80995"); System.Configuration.ConnectionStringSettings connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["UASEntitiesVenture"]; // Loads the factory System.Data.Common.DbProviderFactory factory = System.Data.Common.DbProviderFactories.GetFactory(connectionString.ProviderName); using (DbConnection connection = factory.CreateConnection()) { connection.ConnectionString = connectionString.ConnectionString; connection.Open(); Debug.WriteLine("* * * GetProviderVersion ServerVersion: " + connection.ServerVersion); Debug.WriteLine("* * * GetProviderVersion DataSource: " + connection.DataSource); using (DbCommand command = connection.CreateCommand()) { command.CommandText = "SELECT @@VERSION;"; command.CommandType = CommandType.Text; using (DbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { string result = reader.GetString(0); if (!reader.IsDBNull(0)) { versionInfo = result; Debug.WriteLine("* * * GetProviderVersion versionInfo: " + versionInfo); } } } } } } catch (Exception ex) { versionInfo = "Exception: " + ex.Message; Debug.WriteLine("* * * AuthenticateLocalUser uas_User row count error: " + ex.Message); } return(versionInfo); }
private DbCommand BuildSelectCommand(System.Data.Common.DbProviderFactory provider, DbConnection con, string queryString, params dynamic[] args) { DbCommand com = provider.CreateCommand(); com.CommandTimeout = 30; com.Connection = con; com.CommandText = queryString; com.CommandType = CommandType.Text; foreach (var param in args) { DbParameter par = provider.CreateParameter(); par.Direction = ParameterDirection.Input; par.ParameterName = param.Name; par.Value = param.Value; com.Parameters.Add(par); } return(com); }
private bool TestConnection(string cs, out string reason) { reason = ""; try { System.Data.Common.DbProviderFactory fact = DbProviderFactories.GetFactory("Qizmt_DataProvider"); DbConnection conn = fact.CreateConnection(); conn.ConnectionString = txtConnStr.Text.Trim(); conn.Open(); conn.Close(); return(true); } catch (Exception e) { reason = e.ToString(); return(false); } }