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())
{
}
}
