EF Core using Let in query throw "Argument types do not match" exception

c# entity-framework entity-framework-core linq

Question

I'm using EF Core 2.0.1. I'm trying to get the last order data along with a user info to populate UserDto as follows,

(from u in DbContext.User.Where(u => u.UserId == userId)
let last = u.Orders.LastOrDefault()
select new UserDto
{
    Id = u.Id,
    Name = u.Name,
    LastOrderId = (last == null ? null : last.Id),
    LastOrderDate = (last == null ? null : last.Date)
}

This throws following exception. How can I fix this?

at System.Linq.Expressions.Expression.Condition(Expression test, Expression ifTrue, Expression ifFalse, Type type)
at System.Linq.Expressions.ConditionalExpression.Update(Expression test, Expression ifTrue, Expression ifFalse)
at System.Linq.Expressions.ExpressionVisitor.VisitConditional(ConditionalExpression node)
at System.Linq.Expressions.ConditionalExpression.Accept(ExpressionVisitor visitor)
at System.Linq.Expressions.ExpressionVisitor.Visit(Expression node)
at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.RelationalProjectionExpressionVisitor.Visit(Expression expression)
at System.Linq.Expressions.ExpressionVisitor.VisitMemberAssignment(MemberAssignment node)
at System.Linq.Expressions.ExpressionVisitor.VisitMemberBinding(MemberBinding node)
at System.Linq.Expressions.ExpressionVisitor.Visit[T](ReadOnlyCollection`1 nodes, Func`2 elementVisitor)
at System.Linq.Expressions.ExpressionVisitor.VisitMemberInit(MemberInitExpression node)
at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.RelationalProjectionExpressionVisitor.VisitMemberInit(MemberInitExpression memberInitExpression)
at System.Linq.Expressions.MemberInitExpression.Accept(ExpressionVisitor visitor)
at System.Linq.Expressions.ExpressionVisitor.Visit(Expression node)
at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.RelationalProjectionExpressionVisitor.Visit(Expression expression)
at Microsoft.EntityFrameworkCore.Query.EntityQueryModelVisitor.VisitSelectClause(SelectClause selectClause, QueryModel queryModel)
at Microsoft.EntityFrameworkCore.Query.RelationalQueryModelVisitor.VisitSelectClause(SelectClause selectClause, QueryModel queryModel)
at Remotion.Linq.Clauses.SelectClause.Accept(IQueryModelVisitor visitor, QueryModel queryModel)
at Remotion.Linq.QueryModelVisitorBase.VisitQueryModel(QueryModel queryModel)
at Microsoft.EntityFrameworkCore.Query.EntityQueryModelVisitor.VisitQueryModel(QueryModel queryModel)
at Microsoft.EntityFrameworkCore.Query.RelationalQueryModelVisitor.VisitQueryModel(QueryModel queryModel)
at Microsoft.EntityFrameworkCore.Query.EntityQueryModelVisitor.CreateAsyncQueryExecutor[TResult](QueryModel queryModel)
at Microsoft.EntityFrameworkCore.Storage.Database.CompileAsyncQuery[TResult](QueryModel queryModel)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileAsyncQueryCore[TResult](Expression query, INodeTypeProvider nodeTypeProvider, IDatabase database)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass24_0`1.<CompileAsyncQuery>b__0()
at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQueryCore[TFunc](Object cacheKey, Func`1 compiler)
at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddAsyncQuery[TResult](Object cacheKey, Func`1 compiler)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileAsyncQuery[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteAsync[TResult](Expression query)
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.ExecuteAsync[TResult](Expression expression)
at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.System.Collections.Generic.IAsyncEnumerable<TResult>.GetEnumerator()
at System.Linq.AsyncEnumerable.<Aggregate_>d__6`3.MoveNext()
1
4
3/18/2020 3:23:45 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Formally there is nothing wrong with your query. But although EF Core tries to translate Last / LastOrDefault methods (EF6 simply throws NotSupportedException), apparently it still has issues doing so.

The problem is that Last / LastOrDefault is not quite defined for database originating sequences which are unordered by nature.

Shortly, avoid Last / LastOrDefault. Use OrderByDescending + First / FirstOrDefault instead.

The following works:

let last = u.Orders.OrderByDescending(o => o.Date).FirstOrDefault()

Just use the ordering column(s) which is appropriate for your data logic for determining what is supposed to be "first", "last" etc.

Actually this also works:

let last = u.Orders.OrderBy(o => o.Date).LastOrDefault()

but EF Core will try to convert it to the aforementioned construct, thus is more prone to EF Core implementation bugs than the explicit way.

4
3/31/2018 2:07:53 PM

Related Questions

EF Core: Argument type is not assignable to parameter

I have some inheritance chain which start from interface and endsup with actual implmenetation going a couple of steps....However, this code is 100% correct...IBaseModel model = new ErrorModel(); ...But when I'm trying something like that:...class MyContext: DbContext{ public DbSet<ErrorModel> Errors {get; set} } ...and later...DbSet<IBaseModel...
.net c# entity-framework entity-framework-core
asked by silent_coder

NotImplemented Exceptions using MySQL Provider in ASP.NET Core With EF Core

I am building an ASP.NET Core 1.1.0 application that needs to access an existing MySQL database using Entity Framework Core, which I'm building in Visual Studio 2015 with all the latest updates. I started using the "official" MySQL provider (MySql.Data.EntityFrameworkCore), but have the same problem with the Pomelo prvider (Pomelo.EntityFrameworkCo...
asp.net-core c# entity-framework-core mysql
asked by RiverRunner

Entity Framework Core throwing exception on querying

I'm using a generic repository class in my project, so an actual concrete repository is instantiated through dependency injection:...services.AddTransient<IRepository<Passenger>, EntityFrameworkRepository<Passenger>>(); ...Below is the generic repository itself, notice that i'm using specification pattern for query filtering. Specification themselv...
asp.net-core c# entity-framework-core
asked by Henrick Kakutalua

Entity Framework Core 2.0 mapping int to SQL Server smallint throws exception on query

I mapped an ...int... property to ...smallint... in SQL Server. When I query the database, I get the following exception:...InvalidOperationException: An exception occurred while reading a database value for property 'Tag.Count'. The expected type was 'System.Int32' but the actual value was of type 'System.Int16'...I want to do it this way bec...
c# entity-framework-core
asked by Michael Tranchida

Entity Framework Core 2.0 mapping enum to tinyint in SQL Server throws exception on query

I get the following exception when I try to map an ...enum... to ...smallint... in ...OnModelCreating...:...InvalidCastException: Unable to cast object of type 'System.Byte' to type 'System.Int32'....I want to do this because in SQL Server an ...int... is 4 bytes while a ...tinyint... is 1 byte....Relevant code: Entity:...namespace SOMapping.Data {...
c# entity-framework-core
asked by Michael Tranchida

MVC 5 with Ninject and EF Core, Context throws exception after one query

I am trying to use EF Core in our ASP.Net MVC 5 web application using Framework 4.6.1. We are using Ninject for dependency injection. I am injecting the Context in the DAL layer. I am successful a performing a single query but the context throws the following exception when the next query is run ...No database provider has been configured for this ...
.net-4.6.1 asp.net-mvc-5 c# entity-framework-core ninject
asked by Thomas927

.Net Core 2.1 EF Core Null Reference Exception when searching database with Where linq query

I have a pretty simple query here:...public async Task<IActionResult> Index(string sortOrder) { ApplicationUser user = await _userManager.GetUserAsync(User); var context = _context.Engine .Include(e => e.EngineType) .Where(e => e.Company == user.Company); return View(await context.ToListAsync());...
.net-core entity-framework-core
asked by Ian Gleeson

Could not parse expression '…: The given arguments did not match the expected arguments”

I am using the CompiledQueries feature of the framewok core 2.0 entity but even though it does not give syntax error, when the program is running, I get this exception:..."Could not parse expression 'value (Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1 [TaskManager.Entities.EntitiesDB.USER]) AsNoTracking (). Where (__ conditions)':...
.net-core asp.net-core c# entity-framework-core
asked by Samuel Silva De Carvalho

Argument types do not match, DateTime and DateTime

Exception Argument types do not match is thrown, although both of them are DateTime. Exception is thrown at ...CreatedAt = db.TransactionLogs .Last(x => x.TransactionId == a.Id) .CreatedAt ...Query works just fine if I put CreatedAt = DateTime.Now() instead...TransactionLogs.CreatedAt is not nullable an...
c# entity-framework-core linq
asked by Oskars

Using ".Any()" in lmbda query throws error in .net core EF project

I have this below query in which throws the error below mentioned,It used to work in the other project but no able to run in the .net core project....var lstAppForm = await _appDBContext.ApplicationForms.Where(qr => appFormViewModel.Any(any => any.kycId == qr.id )).ToListAsync(); ...The LINQ expression 'DbSet .Where(a => __appFormViewModel_0 ...
c# entity-framework entity-framework-core
asked by Mayank

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow