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