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