private static void Main(string[] args) { var container = new Container(); ContainerManager.RegisterComponentsTo(container); int customerId = 0; var dapperConnectionFactory = new DapperConnectionFactory( new ConnectionStringProvider() { ConnectionString = ConfigurationManager.ConnectionStrings["CqsContext"] .ConnectionString }); using (var dapperConnection = dapperConnectionFactory.CreateConnection()) { dapperConnection.Open(); customerId = dapperConnection.Query <int>("Select Id from Customer where LastName like 'Rogers'") .First(); } Console.WriteLine("NB - this test takes about 2 mins to run. Stick with it, it is worth it!"); Console.WriteLine(""); RunEfStandardQueries(container, customerId); RunEfProjectionQueries(container, customerId); RunDapperSprocQueries(container, customerId); RunDapperExtensionsQueries(container, customerId); RunDapperAsyncQueries(container, customerId); Console.ReadLine(); }
private static void Main(string[] args) { Console.WriteLine("Creating Cqs Database..."); using (var cqsContext = new CqsCommandContext()) { var customer = cqsContext.Customers.FirstOrDefault(); } Console.WriteLine("Created Cqs Database..."); var dapperConnectionFactory = new DapperConnectionFactory(new ConnectionStringProvider() { ConnectionString = ConfigurationManager.ConnectionStrings["CqsContext"].ConnectionString }); using (var dapperConnection = dapperConnectionFactory.CreateConnection()) { dapperConnection.Open(); Console.WriteLine("Adding Sprocs into the Cqs Database..."); dapperConnection.Execute(BuildDropSproc("usp_Read_Customer")); dapperConnection.Execute(BuildDropSproc("usp_Read_Order")); dapperConnection.Execute(BuildSproc("usp_Read_Customer")); dapperConnection.Execute(BuildSproc("usp_Read_Order")); Console.WriteLine("Inserting data into the Cqs Database..."); dapperConnection.Execute(BuildInsertCustomersSql("Joe", "Bloggs", "*****@*****.**")); var customerId = dapperConnection.Query <int>(BuildInsertCustomersSql("Sean", "Rogers", "*****@*****.**")) .First(); AddOrdersToCustomer(dapperConnection, customerId); } Console.WriteLine("Database successfully created and seeded."); Console.ReadLine(); }