public static void TestMsSql()
{
string ConnectionString = "Data Source=(Local);Initial Catalog=Northwind;User ID=test;Password=test";
var connectionProvider = new MsSQLP.ConnectionStringConnectionProvider(ConnectionString);
MsSqlRepoFactory.UseConnectionProvider(connectionProvider);
MsSqlRepoFactory.UseStatementExecutor(new DapperStatementExecutor(connectionProvider));
MsSqlRepoFactory.UseDataReaderEntityMapper(new DapperEntityMapper());
var repository = MsSqlRepoFactory.Create <Customers>();
var result = repository.Query().Select(e => e.CustomerID, e => e.CompanyName, e => e.Address).Top(10);
Console.WriteLine(result.Sql());
var rs = result.Go();
foreach (var r in rs)
{
Console.WriteLine($"{r.CustomerID}\t {r.CompanyName}\t\t\t {r.Address}");
}
}
