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);
}
}
