public void Insert() { var dbSessionFactory = new SmartSqlBuilder() .UseDataSource(DbProvider.MYSQL, "Data Source=localhost;database=SmartSqlTestDB;uid=root;pwd=SmartSql.net") .UseAlias("MySqlTest") .Build().GetDbSessionFactory(); var list = new List <User> { new User { Id = 3, UserName = "******" } , new User { Id = 4, UserName = "******" } }; using (var dbSession = dbSessionFactory.Open()) { var data = list.ToDataTable(); data.Columns.RemoveAt(0); data.TableName = "t_user"; BulkInsert bulkInsert = new BulkInsert(dbSession) { SecureFilePriv = "C:/ProgramData/MySQL/MySQL Server 8.0/Uploads", Table = data }; bulkInsert.Insert(); } }
public void Insert() { var dbSessionFactory = new SmartSqlBuilder() .UseDataSource(DbProvider.MYSQL_CONNECTOR, "Data Source=localhost;database=SmartSqlTestDB;uid=root;pwd=root") .UseAlias("MySqlConnectorTest") .Build().GetDbSessionFactory(); var list = new List <User> { new() { Id = 1, UserName = "******", IsDelete = true }, new() { Id = 2, UserName = "******", IsDelete = false } }; using var dbSession = dbSessionFactory.Open(); var data = list.ToDataTable(); data.TableName = "t_user"; var bulkInsert = new BulkInsert(dbSession) { SecureFilePriv = "C:/ProgramData/MySQL/MySQL Server 8.0/Uploads", Table = data }; bulkInsert.Expressions.Add("user_name = upper(user_name)"); bulkInsert.Expressions.Add("is_delete = convert(is_delete, unsigned )"); bulkInsert.Insert(); } }
public void Insert() { var dbSessionFactory = new SmartSqlBuilder() .UseDataSource(DbProvider.POSTGRESQL, "Server=localhost;Database=SmartSqlTestDB;Port=5432;User Id=postgres;Password=SmartSql.net;") .UseAlias("PostgreSqlTest") .Build().GetDbSessionFactory(); var list = new List <User> { new User { Id = 1, UserName = "******" } , new User { Id = 2, UserName = "******" } }; using (var dbSession = dbSessionFactory.Open()) { var data = list.ToDataTable(); data.Columns.RemoveAt(0); data.Columns["UserName"].ColumnName = "user_name"; data.Columns["Status"].ColumnName = "status"; data.TableName = "t_user"; BulkInsert bulkInsert = new BulkInsert(dbSession); bulkInsert.Table = data; bulkInsert.Insert(); } }
public void InsertByList() { IBulkInsert bulkInsert = new BulkInsert(DbSession); var list = DbSession.Query <AllPrimitive>(new RequestContext { Scope = nameof(AllPrimitive), SqlId = "Query", Request = new { Taken = 100 } }); bulkInsert.Insert(list); }
public void InsertByList() { using (var dbSession = _dbSessionFactory.Open()) { var list = dbSession.Query <AllPrimitive>(new RequestContext { RealSql = "Select Top(100) * From T_AllPrimitive Order By Id Desc" }); IBulkInsert bulkInsert = new BulkInsert(dbSession); bulkInsert.Insert(list); } }
public void Insert() { using (var dbSession = _dbSessionFactory.Open()) { var data = dbSession.GetDataTable(new RequestContext { RealSql = "Select Top(100) * From T_AllPrimitive Order By Id Desc" }); data.TableName = "T_AllPrimitive"; IBulkInsert bulkInsert = new BulkInsert(dbSession); bulkInsert.Table = data; bulkInsert.Insert(); } }
public void InsertByList() { using (var dbSession = SqlMapper.SessionStore.Open()) { IBulkInsert bulkInsert = new BulkInsert(dbSession); var list = SqlMapper.Query <AllPrimitive>(new RequestContext { Scope = nameof(AllPrimitive), SqlId = "Query", Request = new { Taken = 100 } }); bulkInsert.Insert(list); } }
public void BulkInsert(IEnumerable <Excerpt> excerpts) { using (var session = _repository.SqlMapper.SessionStore.Open()) { var table = excerpts.ToDataTable(); table.TableName = "t_excerpt"; var bulkInsert = new BulkInsert(session) { Table = table, SecureFilePriv = @"C:\ProgramData\MySQL\MySQL Server 8.0\Uploads" }; bulkInsert.Insert(); } }
public void InsertByListWithTypeHandler() { using (var dbSession = SqlMapper.SessionStore.Open()) { IBulkInsert bulkInsert = new BulkInsert(dbSession); var list = SqlMapper.Query <UserExtendedInfo>(new RequestContext { Scope = nameof(UserExtendedInfo), SqlId = "Query", Request = new { Taken = 100 } }); bulkInsert.Insert(list); } }
public void Insert() { var data = DbSession.GetDataTable(new RequestContext { Scope = nameof(AllPrimitive), SqlId = "Query", Request = new { Taken = 100 } }); data.TableName = "T_AllPrimitive"; IBulkInsert bulkInsert = new BulkInsert(DbSession); bulkInsert.Table = data; bulkInsert.Insert(); }
public void Insert() { using (var dbSession = SqlMapper.SessionStore.Open()) { var data = SqlMapper.GetDataTable(new RequestContext { Scope = nameof(AllPrimitive), SqlId = "Query", Request = new { Taken = 100 } }); data.TableName = "T_AllPrimitive"; IBulkInsert bulkInsert = new BulkInsert(dbSession); bulkInsert.Table = data; bulkInsert.Insert(); } }
private void ImportData() { try { using (var dt = CreateSourceDataTable()) { using (var session = CreateSession()) { using (var bulkInsert = new BulkInsert <T, int>(session.Connection)) { foreach (DataRow dr in dt.Rows.OfType <DataRow>()) { var target = DataRowToTarget(dr); bulkInsert.Insert(target); } } } } } catch (Exception ex) { Logger.Write(ex); } }