public DbConnection(string connectionString, string providerName) { if (string.IsNullOrEmpty(providerName)) { throw new ArgumentNullException("providerName"); } if (string.IsNullOrEmpty(connectionString)) { throw new ArgumentNullException("connectionString"); } this.ConnectionString = connectionString; this.ProviderName = providerName; System.Data.Common.DbProviderFactory factory; factory = System.Data.Common.DbProviderFactories.GetFactory(providerName); if (factory != null) { this.connection = factory.CreateConnection(); this.connection.ConnectionString = connectionString; this.connection.Open(); } else { throw new InvalidOperationException("Failed creating connection."); } }
public void Initialize() { try { EffortProviderConfiguration.RegisterProvider(); connection = Effort.DbConnectionFactory.CreateTransient(); databaseContext = new TestContext(connection); objRepo = new CountryRepository(databaseContext); } catch (Exception ex) { } }
public static void ConnectDB() { if (DBConn != null) { if (DBConn.State == ConnectionState.Closed) { try { DBConn.Open(); } catch (Exception ex) { //EventLog log = new EventLog(); //log.Source = "COPLibrary"; //log.WriteEntry(ex.Message , EventLogEntryType.Error); LogEvent(ex.Message, EventLogEntryType.Error); } } return; } if (WebConfigurationManager.ConnectionStrings["DBType"].ConnectionString == "Oracle") { DBConn = new OracleConnection(); DbType = "Oracle"; } //else if (WebConfigurationManager.ConnectionStrings["DBType"].ConnectionString == "MySql") //{ // DBConn = new MySql.Data.MySqlClient.MySqlConnection(); // DbType = "MySql"; //} else { DBConn = new SqlConnection(); DbType = "SQLServer"; } if(DBConn.ConnectionString != null) DBConn.ConnectionString = WebConfigurationManager.ConnectionStrings["COP"].ConnectionString; //if (DBConn.State == ConnectionState.Open) // DBConn.Close(); try { DBConn.Open(); } catch (Exception ex) { //EventLog log = new EventLog(); //log.Source = "COPLibrary"; //log.WriteEntry(ex.Message , EventLogEntryType.Error); LogEvent(ex.Message, EventLogEntryType.Error); } }
private async Task LiteralReplacementDynamic(IDbConnection conn) { var args = new DynamicParameters(); args.Add("id", 123); try { await conn.ExecuteAsync("drop table literal2"); } catch { } await conn.ExecuteAsync("create table literal2 (id int not null)"); await conn.ExecuteAsync("insert literal2 (id) values ({=id})", args); args = new DynamicParameters(); args.Add("foo", 123); var count = (await conn.QueryAsync<int>("select count(1) from literal2 where id={=foo}", args)).Single(); count.IsEqualTo(1); }
private async Task LiteralReplacement(IDbConnection conn) { try { await conn.ExecuteAsync("drop table literal1"); } catch { } await conn.ExecuteAsync("create table literal1 (id int not null, foo int not null)"); await conn.ExecuteAsync("insert literal1 (id,foo) values ({=id}, @foo)", new { id = 123, foo = 456 }); var rows = new[] { new { id = 1, foo = 2 }, new { id = 3, foo = 4 } }; await conn.ExecuteAsync("insert literal1 (id,foo) values ({=id}, @foo)", rows); var count = (await conn.QueryAsync<int>("select count(1) from literal1 where id={=foo}", new { foo = 123 })).Single(); count.IsEqualTo(1); int sum = (await conn.QueryAsync<int>("select sum(id) + sum(foo) from literal1")).Single(); sum.IsEqualTo(123 + 456 + 1 + 2 + 3 + 4); }
/// <summary> /// Gets the feature set based on the passed connection /// </summary> public static FeatureSupport Get(IDbConnection connection) { string name = connection?.GetType().Name; if (string.Equals(name, "npgsqlconnection", StringComparison.OrdinalIgnoreCase)) return postgres; return @default; }
internal IDbCommand SetupCommand(IDbConnection cnn, Action<IDbCommand, object> paramReader) { var cmd = cnn.CreateCommand(); var init = GetInit(cmd.GetType()); init?.Invoke(cmd); if (Transaction != null) cmd.Transaction = Transaction; cmd.CommandText = CommandText; if (CommandTimeout.HasValue) { cmd.CommandTimeout = CommandTimeout.Value; } else if (SqlMapper.Settings.CommandTimeout.HasValue) { cmd.CommandTimeout = SqlMapper.Settings.CommandTimeout.Value; } if (CommandType.HasValue) cmd.CommandType = CommandType.Value; paramReader?.Invoke(cmd, Parameters); return cmd; }
public IdDao(System.Data.Common.DbConnection connection) { _connection = connection; }
public IdProvider(ISession session) { _connection = session.GetPort<System.Data.Common.DbConnection>(); }
public CartDao(ISession session) { _connection = session.GetPort<System.Data.Common.DbConnection>(); }
protected override void recUpdateInsertDelete(ref System.Data.Common.DbConnection dbConn, out int err) { throw new NotImplementedException(); }
protected override void initialize(ref System.Data.Common.DbConnection dbConn, out int err, out string errMsg) { err = 0; errMsg = string.Empty; }
/// <summary> /// 装饰 /// </summary> /// <param name="Connection"></param> public DbConnectionHelper(System.Data.Common.DbConnection Connection) { this._Connection = Connection; }
public TestRepository(System.Data.Common.DbConnection connc) { conn = connc; }