public DbBulkCopy(ProviderType providerType, string connectionString, int bulkcopyTimeout = 1800, int batchSize = 102400, BulkCopyOptions dbBulkCopyOption = BulkCopyOptions.KeepIdentity) : this(providerType, connectionString) { this.BatchSize = batchSize; this.BulkCopyTimeout = bulkcopyTimeout; this.DbBulkCopyOption = dbBulkCopyOption; if (ProviderName == ProviderType.SqlServer) { if (sqlBulkCopy == null || this.ConnectionString != ConnectionString) { sqlBulkCopy = new SqlBulk(ConnectionString, BulkCopyTimeout, DbBulkCopyOption); } } else if (ProviderName == ProviderType.DB2) { if (db2BulkCopy == null || this.ConnectionString != ConnectionString) { //db2BulkCopy = new Db2Bulk(ConnectionString, BulkCopyTimeout, DbBulkCopyOption); throw new Exception("暂时不支持DB2数据库"); } } else if (ProviderName == ProviderType.Oracle) { if (oracleBulkCopy == null || this.ConnectionString != ConnectionString) { oracleBulkCopy = new OracleBulk(ConnectionString, BulkCopyTimeout, DbBulkCopyOption); } } else if (ProviderName == ProviderType.MySql) { mySqlBulkCopy = new MysqlBulk(ConnectionString, BulkCopyTimeout); } }
public TestParam Get(int id) { SqlBulk.InsertTwo(); RedisHelper redisHelper = new RedisHelper("127.0.0.1:6379"); redisHelper.SetValue("mykey", "abc111"); var person = new Users { UserName = "******", Email = "*****@*****.**", Address = "浙江" }; // redisHelper.SetEntryInHash("Hash", "Name", "wujf"); redisHelper.SetHashValue("user:123", person); var ts = new TestParam(); ts.ID = id; return(ts); }
public DbBulkCopy(ProviderType providerType, string connectionString, IDbConnection dbConnection, int bulkcopyTimeout = 1800, int batchSize = 102400, BulkCopyOptions dbBulkCopyOption = BulkCopyOptions.KeepIdentity, bool isTransaction = true) : this(providerType, connectionString) { this.BatchSize = batchSize; this.BulkCopyTimeout = bulkcopyTimeout; this.DbBulkCopyOption = dbBulkCopyOption; this.IsTransaction = isTransaction; this.dbConn = dbConnection; if (ProviderName == ProviderType.SqlServer) { if (sqlBulkCopy != null || this.ConnectionString != connectionString) { if (sqlBulkCopy != null) { sqlBulkCopy.Dispose(); } } if (dbConn.State != ConnectionState.Open) { dbConn.Open(); } if (IsTransaction) { dbTrans = dbConn.BeginTransaction(); } sqlBulkCopy = new SqlBulk(dbConn, dbTrans, BulkCopyTimeout, DbBulkCopyOption); } else if (ProviderName == ProviderType.DB2) { //if (db2BulkCopy != null || this.ConnectionString != connectionString) //{ // if (db2BulkCopy != null) // db2BulkCopy.Dispose(); //} //if (dbConn.State != ConnectionState.Open) dbConn.Open(); //if (isTransaction) //{ // dbTrans = dbConn.BeginTransaction(); //} //db2BulkCopy = new Db2Bulk(dbConn, BulkCopyTimeout, DbBulkCopyOption); throw new Exception("暂时不支持DB2数据库"); } else if (ProviderName == ProviderType.Oracle) { if (oracleBulkCopy != null || this.ConnectionString != connectionString) { if (oracleBulkCopy != null) { oracleBulkCopy.Dispose(); } } if (dbConn.State != ConnectionState.Open) { dbConn.Open(); } if (isTransaction) { dbTrans = dbConn.BeginTransaction(); } oracleBulkCopy = new OracleBulk(dbConn, BulkCopyTimeout, DbBulkCopyOption); } else if (ProviderName == ProviderType.MySql) { if (mySqlBulkCopy != null || this.ConnectionString != connectionString) { if (mySqlBulkCopy != null) { mySqlBulkCopy.Dispose(); } } mySqlBulkCopy = new MysqlBulk(ConnectionString, BulkCopyTimeout); } }
public void insertBulk(IList <CovalcoDTO> airportTaxes) { this.truncateTable("CovalcoDetails"); SqlBulk.BulkInsertByTake(_conn.DatabaseConnString, "CovalcoDetails", airportTaxes); }