public static void TestMySqlUpdate()
{
string ConnectionString = "datasource=127.0.0.1;username=test;password=test;database=sqlrepotest;charset=gb2312;SslMode = none;";
var connectionProvider = new MySQLP.ConnectionStringConnectionProvider(ConnectionString);
MySqlRepoFactory.UseConnectionProvider(connectionProvider);
MySqlRepoFactory.UseStatementExecutor(new DapperStatementExecutor(connectionProvider));
MySqlRepoFactory.UseDataReaderEntityMapper(new DapperEntityMapper());
MySqlRepoFactory.UseWritablePropertyMatcher(new SimpleWritablePropertyMatcher());
var repository11 = MySqlRepoFactory.Create <ToDo>();
var results11 = repository11.Query().Where(c => c.Id == 2).Go().FirstOrDefault();
results11.Task = "B21";
var rest2 = repository11.Update().For(results11);
Console.WriteLine(rest2.ParamSql());
var rest3 = rest2.ParamSqlWithEntity();
IDbConnection dbConnection = repository11.GetConnectionProvider.GetDbConnection;
// with dapper
dbConnection.Execute(rest3.paramsql, rest3.entity);
}
public static void TestMySql()
{
string ConnectionString = "datasource=127.0.0.1;username=test;password=test;database=sqlrepotest;charset=gb2312;SslMode = none;";
var connectionProvider = new MySQLP.ConnectionStringConnectionProvider(ConnectionString);
MySqlRepoFactory.UseConnectionProvider(connectionProvider);
MySqlRepoFactory.UseStatementExecutor(new DapperStatementExecutor(connectionProvider));
MySqlRepoFactory.UseDataReaderEntityMapper(new DapperEntityMapper());
var repository11 = MySqlRepoFactory.Create <ToDo>();
var results11 = repository11.Query().Select(e => e.Id, e => e.Task, e => e.CreatedDate).Top(6);
foreach (var item in results11.Go())
{
Console.WriteLine($"{item.Id}\t {item.Task}\t {item.CreatedDate}\t {item.Remark}");
}
Console.WriteLine();
Console.WriteLine();
var repository = MySqlRepoFactory.Create <ToDo>();
var results = repository.Query().Select(e => e.Id, e => e.Task, e => e.CreatedDate, e => e.Remark);
var results5 = repository.Query()
.InnerJoin <TaskRemark>()
.On <TaskRemark>((r, l) => r.Task == l.Task, l => l.Remark)
.Select(e => e.Id, e => e.Task, e => e.CreatedDate, e => e.Remark)
.WhereBetween(e => e.Id, 1, 5);
var results6 = repository.Query()
.InnerJoin <TaskRemark>()
.On <TaskRemark>((r, l) => r.Task == l.Task, l => l.Remark)
.Select(e => e.Id, e => e.Task, e => e.CreatedDate, e => e.Remark)
.WhereBetween(e => e.Id, 10, 15);
// Console.WriteLine(results.UnionSql(new List<UnionSql> { new UnionSql { Sql = results5.Sql(), UnionType = UnionType.Union } }));
var results2 = results.Union(new List <UnionSql> {
UnionSql.New(results5, UnionType.Union),
UnionSql.New(results6, UnionType.Union)
});
foreach (var item in results2)
{
Console.WriteLine($"{item.Id}\t {item.Task}\t {item.CreatedDate}\t {item.Remark}");
}
}
