public override void Single_SingleOrDefault_without_orderby_doesnt_issue_warning()
{
base.Single_SingleOrDefault_without_orderby_doesnt_issue_warning();
Assert.DoesNotContain(
CoreResources.LogFirstWithoutOrderByAndFilter(new TestLogger <SqlServerLoggingDefinitions>()).GenerateMessage(
@"(from Customer c in DbSet<Customer> where c.CustomerID == ""ALFKI"" select c).Single()"),
Fixture.TestSqlLoggerFactory.Log.Select(l => l.Message));
}
public override void Paging_operation_on_string_doesnt_issue_warning()
{
base.Paging_operation_on_string_doesnt_issue_warning();
Assert.DoesNotContain(
CoreResources.LogFirstWithoutOrderByAndFilter(new TestLogger <SqlServerLoggingDefinitions>()).GenerateMessage(
"(from char <generated>_1 in [c].CustomerID select [<generated>_1]).FirstOrDefault()"),
Fixture.TestSqlLoggerFactory.Log.Select(l => l.Message));
}
public override void FirstOrDefault_without_orderby_and_filter_issues_warning_subquery()
{
base.FirstOrDefault_without_orderby_and_filter_issues_warning_subquery();
Assert.Contains(
CoreResources.LogFirstWithoutOrderByAndFilter(new TestLogger <SqlServerLoggingDefinitions>()).GenerateMessage(
"(from Order <generated>_1 in [c].Orders select (Nullable<int>)[<generated>_1].OrderID).FirstOrDefaul..."),
Fixture.TestSqlLoggerFactory.Log.Select(l => l.Message));
}
#pragma warning disable CS0612 // Type or member is obsolete
public override void Last_without_order_by_issues_client_eval_warning()
{
base.Last_without_order_by_issues_client_eval_warning();
Assert.Contains(
CoreResources.LogFirstWithoutOrderByAndFilter(new TestLogger <SqlServerLoggingDefinitions>()).GenerateMessage(
"(from Customer <generated>_1 in DbSet<Customer> select [<generated>_1]).Last()"),
Fixture.TestSqlLoggerFactory.Log.Select(l => l.Message));
}
public override void Paging_operation_on_string_doesnt_issue_warning()
{
base.Paging_operation_on_string_doesnt_issue_warning();
Assert.DoesNotContain(
#pragma warning disable CS0612 // Type or member is obsolete
CoreResources.LogFirstWithoutOrderByAndFilter(new TestLogger <TestLoggingDefinitions>()).GenerateMessage(
#pragma warning restore CS0612 // Type or member is obsolete
"(from char <generated>_1 in [c].CustomerID select [<generated>_1]).FirstOrDefault()"),
Fixture.TestSqlLoggerFactory.Log.Select(l => l.Message));
}
public virtual void FirstOrDefault_without_filter_order_by()
{
using var context = CreateContext();
var customer = context.Set <Customer>().FirstOrDefault();
Assert.NotNull(customer);
Assert.Equal(
CoreResources.LogFirstWithoutOrderByAndFilter(new TestLogger <SqlServerLoggingDefinitions>()).GenerateMessage(),
Fixture.TestSqlLoggerFactory.Log[1].Message);
}
public void Throws_when_warning_as_error_all()
{
var serviceProvider = new ServiceCollection()
.AddEntityFrameworkInMemoryDatabase()
.BuildServiceProvider();
using (var context = new WarningAsErrorContext(serviceProvider))
{
Assert.Equal(
CoreStrings.WarningAsErrorTemplate(
CoreEventId.FirstWithoutOrderByAndFilterWarning.ToString(),
CoreResources.LogFirstWithoutOrderByAndFilter(new TestLogger <InMemoryLoggingDefinitions>()).GenerateMessage(
"(from WarningAsErrorEntity <generated>_1 in DbSet<WarningAsErrorEntity> select [<generated>_1]).Firs..."),
"CoreEventId.FirstWithoutOrderByAndFilterWarning"),
Assert.Throws <InvalidOperationException>(
() => context.WarningAsErrorEntities.FirstOrDefault()).Message);
}
}