public void Execute1742(CustomerDetails_1742 details) { CreateDatabase925(); var loggingFactory = new TestSqlLoggerFactory(); var serviceProvider = new ServiceCollection() .AddEntityFrameworkNpgsql() .AddSingleton <ILoggerFactory>(loggingFactory) .BuildServiceProvider(); using (var ctx = new MyContext925(serviceProvider)) { var firstName = details.FirstName; ctx.Customers.Where(c => c.FirstName == firstName && c.LastName == details.LastName).ToList(); const string expectedSql = @"@__firstName_0: Foo @__8__locals1_details_LastName_1: Bar SELECT ""c"".""FirstName"", ""c"".""LastName"" FROM ""Customer"" AS ""c"" WHERE (""c"".""FirstName"" = @__firstName_0) AND (""c"".""LastName"" = @__8__locals1_details_LastName_1)"; Assert.Equal(expectedSql, TestSqlLoggerFactory.Sql); } }
public void Execute1742(CustomerDetails_1742 details) { CreateDatabase925(); var loggingFactory = new TestSqlLoggerFactory(); var serviceProvider = new ServiceCollection() .AddEntityFramework() .AddSqlServer() .ServiceCollection() .AddInstance <ILoggerFactory>(loggingFactory) .BuildServiceProvider(); using (var ctx = new MyContext925(serviceProvider)) { var firstName = details.FirstName; ctx.Customers.Where(c => c.FirstName == firstName && c.LastName == details.LastName).ToList(); const string expectedSql = @"@__firstName_0: Foo @__8__locals1_details_LastName_1: Bar SELECT [c].[FirstName], [c].[LastName] FROM [Customer] AS [c] WHERE ([c].[FirstName] = @__firstName_0) AND ([c].[LastName] = @__8__locals1_details_LastName_1)"; Assert.Equal(expectedSql, TestSqlLoggerFactory.Sql); } }