EF core exception System.ArgumentException:Argument types do not match System.Linq.Expressions.Expression.Condition(Expression test, Expression ....)

c# entity-framework-core linq

Question

I'm using Entityframework-core 2.1.4, want to run following query and trying to get value from navigation property based on some condition.

var openInvoiceData = _Context.Invoice
    .Where(i => i.InvoiceDate.Date == model.CurrentDate.Date)
    .Select(i => new Contracts.OpenInvoiceData() {
        CustomerId = i.BillToId != null && i.BillTo.CustomerBillTo.Where(x => x.CustomerType == Enum.EnumCustomerType.BillTo).FirstOrDefault() != null
           ? i.BillTo.CustomerBillTo.Where(x => x.CustomerType == Enum.EnumCustomerType.BillTo).FirstOrDefault().Customer.CustomerId 
           : i.Customer.CustomerId
    }).ToList();

When its true part executed, its returning following exception.

System.ArgumentException: Argument types do not match
   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 Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.SqlTranslatingExpressionVisitor.VisitConditional(ConditionalExpression expression)
   at System.Linq.Expressions.ConditionalExpression.Accept(ExpressionVisitor visitor)
   at System.Linq.Expressions.ExpressionVisitor.Visit(Expression node)
   at Remotion.Linq.Parsing.ThrowingExpressionVisitor.Visit(Expression expression)
   at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.SqlTranslatingExpressionVisitor.Visit(Expression expression)
   at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.SqlTranslatingExpressionVisitor.VisitUnary(UnaryExpression expression)
   at System.Linq.Expressions.UnaryExpression.Accept(ExpressionVisitor visitor)
   at System.Linq.Expressions.ExpressionVisitor.Visit(Expression node)
   at Remotion.Linq.Parsing.ThrowingExpressionVisitor.Visit(Expression expression)
   at Microsoft.EntityFrameworkCore.Query.ExpressionVisitors.SqlTranslatingExpressionVisitor.Visit(Expression expression)
   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 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.CreateQueryExecutor[TResult](QueryModel queryModel)
   at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](QueryModel queryModel)
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](Expression query, IQueryModelGenerator queryModelGenerator, IDatabase database, IDiagnosticsLogger`1 logger, Type contextType)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass13_0`1.<Execute>b__0()
   at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQueryCore[TFunc](Object cacheKey, Func`1 compiler)
   at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression)
   at Remotion.Linq.QueryableBase`1.GetEnumerator()
   at System.Collections.Generic.List`1.AddEnumerable(IEnumerable`1 enumerable)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at TintPro.Repository.InvoiceRepository.GetOpenInvoices(GetOpenInvoice model) in C:\\Devendra Work\\TintPro\\Source BitBucket\\TintProAPI\\Repository\\Repository\\InvoiceRepository.cs:line 163
   at TintPro.Services.InvoiceService.GetOpenInvoices(GetOpenInvoice model) in C:\\Devendra Work\\TintPro\\Source BitBucket\\TintProAPI\\Services\\Service\\InvoiceService.cs:line 486
   at TintProAPI.Controllers.InvoiceController.GetOpenInvoice(GetOpenInvoice model) in C:\\Devendra Work\\TintPro\\Source BitBucket\\TintProAPI\\TintProAPI\\Controllers\\InvoiceController.cs:line 159
   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at System.Threading.Tasks.ValueTask`1.get_Result()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()

I noticed the following things:

  1. The exception is throwing only when I'm trying to get value from Customer navigation property, which is written in its true part, that is
? i.BillTo.CustomerBillTo.Where(x => x.CustomerType == Enum.EnumCustomerType.BillTo).FirstOrDefault().Customer.CustomerId
  1. If I use the following statement instead of this, then it's working
? i.BillTo.CustomerBillTo.Where(x => x.CustomerType == Enum.EnumCustomerType.BillTo).FirstOrDefault().CustomerId

I'm unable to catch the cause of this problem, please help.

1
0
9/8/2019 11:16:10 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I guess the issue is foreign key is not properly set in the CustomerBillTo entity. Just double check you have done it correctly as bellow.

public class CustomerBillTo 
{
    [Required]
    [ForeignKey("Customer")]
    public string CustomerId { get; set; }

    public virtual Customer Customer { get; set; }
}

Also since your are accessing as .FirstOrDefault().Customer.CustomerId. You must have Customer with CustomerBillTo Entity. So make it Required. If not you will have to deal with null reference exception as well.

0
9/8/2019 10:35:34 AM

Related Questions

Unable to cast Anonymous Type from 'System.Linq.IQueryable' to 'System.Data.Entity.Core.Objects.ObjectQuery'

The following query was working well with EF5 but gives me error with EF6. I use DbContext and CodeFirst....Error raised with EF6:...Unable to cast the type 'System.Linq.IQueryable...1[[<>f__AnonymousType5...4[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089],[System.Int32, mscorlib, Version=4.0.0.0, Cultur...
c# entity-framework entity-framework-6 linq linq-to-entities
asked by Dan

Unable to cast object of type 'System.Linq.Expressions.FieldExpression' to type 'System.Linq.Expressions.ParameterExpression

I am using ...Entity Framework rc1-final... in ...ASP.NET5....I have the following table....public class PlayerComment { [Key] public int Id { get; set; } public int? PeriodId { get; set; } [ForeignKey("PeriodId")] public Period Period { get; set; } public int? PlayerId { get; set; } [ForeignKey("PlayerId")] publ...
entity-framework entity-framework-core linq
asked by dfmetro

Entityframework Core Unable to cast object of type 'System.Int32' to type 'System.Int64'

It was my mistake.. When I first created the table, productNo was bigint and I created the model based on that table. After that somehow (it must be me...) productNo changed to int. It is working just fine after changing productNo back to bigint
c# entity-framework-core sql-server
asked by jong shin

System.Core error: "Code supposed to be unreachable" using C# Entity Framework and Linq with Expression

I'm getting a "Code supposed to be unreachable" error when executing the following Linq to Sql statement. I'm using EF 6.1.3. I think this is a known bug related to filtering a navigation property. It seems like it might be fixed in EF7 but I don't see anything related to this in the EF 6.2 release notes nor the EF6 open items on GitHub so I guess ...
c# entity-framework entity-framework-6 linq-expressions linq-to-entities
asked by SteveB

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

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 == nu...
c# entity-framework entity-framework-core linq
asked by sajith

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

Unable to cast object of type 'System.Linq.Expressions.MethodCallExpression' to type 'System.Linq.Expressions.LambdaExpression'

I am using EntityFramework and having trouble with the above error. When I invoke ...var documents = docRepository.GetAllSavedDocuments(); var withRatings = documentFilter.GetDocumentsWithRating(documents, 1); ...I get the error in the title....My code is split across a few classes...public class DocRepository { public IQueryable<Document> GetA...
c# entity-framework entity-framework-6 linq sql
asked by bookshopkeeper

EF Core SQL Function LIKE Method with Linq Expression not working for Non String types

am able to create an invoke Expression with SQL Functions like as shown below...var likeMethod = typeof(DbFunctionsExtensions).GetMethod("Like", new[] { typeof(DbFunctions), typeof(string), typeof(string) }); Expression.Call(null, likeMethod, Expression.Constant(EF.Functions), searchKeyExpression, Expression.Constant($"%{filter.Value}%")); ...I ju...
c# ef-core-2.1 entity-framework-core expression-trees
asked by Akshay Joy

Using an existing expression/func to build out another expression/func

The ...Any... methods in your question look like they were intended to be extension methods on a source sequence but they were missing the parameter for the target object....Conceptually, this is what I believe you were looking to do:...public static bool Any<TEntity, TProperty>(this IEnumerable<TEntity> source, Func<TEntity, TProperty> selector, T...
c# entity-framework-core expression generics lambda
asked by madreflection

assign null value to ifFalse parameter of Expression.Condition throws type mismatch exception

I want to create a static method that can be used with automapper to map a string value (retrieved from MS SQL database) to an enum and get the description of that enum which is stored in an annotation (using Entity Framework core). I get the code to work using Expression.Condition (resulting in a CASE WHEN THEN ELSE), except when there are more th...
automapper c# entity-framework-core linq-expressions
asked by StefanE

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