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.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 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 Build_By_DataSource() { var dbSessionFactory = new SmartSqlBuilder() .UseDataSource(DbProvider.SQLSERVER, ConnectionString) .Build().GetDbSessionFactory(); using (var dbSession = dbSessionFactory.Open()) { } }
public void Build_By_DataSource() { var dbSessionFactory = new SmartSqlBuilder() .UseDataSource(DbProvider.SQLSERVER, ConnectionString) .UseAlias("Build_By_DataSource") .AddTypeHandler(new Configuration.TypeHandler { Name = "Json", HandlerType = typeof(JsonTypeHandler) }) .Build().GetDbSessionFactory(); using (var dbSession = dbSessionFactory.Open()) { } }