EF Core 1.1 Preview Logs for Single & First Comparisons

Single vs First Logs EF Core

**TEST #1: First() ****
 Assert.IsInstanceOfType(_context.Samurais.First(s => s.Id == 1),typeof(Samurai));

COMPILING QUERY MODEL: 
'(from Samurai s in DbSet<Samurai>
where s.Id == 1
select s)
.First()'
Optimized query model: 
'(from Samurai s in DbSet<Samurai>
where s.Id == 1
select s)
.First()'

(QueryContext queryContext) => IEnumerable<Samurai> _ToSequence(
    element: Samurai First(
        source: IEnumerable<Samurai> _ShapedQuery(
            queryContext: queryContext, 
            shaperCommandContext: SelectExpression: 
                SELECT TOP(1) [s].[Id], [s].[Name]
                FROM [Samurais] AS [s]
                WHERE [s].[Id] = 1
            , 
            shaper: UnbufferedEntityShaper<Samurai>
        )
    )
)

Opening connection to database 'SamuraiData' on server '(localdb)\mssqllocaldb'.
Executed DbCommand (7ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [s].[Id], [s].[Name]
FROM [Samurais] AS [s]
WHERE [s].[Id] = 1
Closing connection to database 'SamuraiData' on server '(localdb)\mssqllocaldb'.


*******************************************************
**TEST #2: Single() **
 Assert.IsInstanceOfType(_context.Samurais.Single(s => s.Id == 1),typeof(Samurai));

COMPILING QUERY MODEL:
'(from Samurai s in DbSet<Samurai>
where s.Id == 1
select s)
.Single()'
Compiling query model: 
'(from Samurai s in DbSet<Samurai>
where s.Id == 1
select s)
.Single()'
Optimized query model: 
'(from Samurai s in DbSet<Samurai>
where s.Id == 1
select s)
.Single()'
Optimized query model: 
'(from Samurai s in DbSet<Samurai>
where s.Id == 1
select s)
.Single()'

(QueryContext queryContext) => IEnumerable<Samurai> _ToSequence(
    element: Samurai Single(
        source: IEnumerable<Samurai> _ShapedQuery(
            queryContext: queryContext, 
            shaperCommandContext: SelectExpression: 
                SELECT TOP(2) [s].[Id], [s].[Name]
                FROM [Samurais] AS [s]
                WHERE [s].[Id] = 1
            , 
            shaper: UnbufferedEntityShaper<Samurai>
        )
    )
)

TRACKED: True
(QueryContext queryContext) => IEnumerable<Samurai> _ToSequence(
    element: Samurai Single(
        source: IEnumerable<Samurai> _ShapedQuery(
            queryContext: queryContext, 
            shaperCommandContext: SelectExpression: 
                SELECT TOP(2) [s].[Id], [s].[Name]
                FROM [Samurais] AS [s]
                WHERE [s].[Id] = 1
            , 
            shaper: UnbufferedEntityShaper<Samurai>
        )
    )
)

Opening connection to database 'SamuraiData' on server '(localdb)\mssqllocaldb'.
Opening connection to database 'SamuraiData' on server '(localdb)\mssqllocaldb'.
Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(2) [s].[Id], [s].[Name]
FROM [Samurais] AS [s]
WHERE [s].[Id] = 1
Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(2) [s].[Id], [s].[Name]
FROM [Samurais] AS [s]
WHERE [s].[Id] = 1
Closing connection to database 'SamuraiData' on server '(localdb)\mssqllocaldb'.
Closing connection to database 'SamuraiData' on server '(localdb)\mssqllocaldb'.