AddMonth function in LINQ to Entities

The method 'System' is not recognized by LINQ to Entities. Linq.IQueryable

The simple solution is to add a .ToList() before your select(...). ... ViewDet = _db.Grp.ToList().Select(gh => new MultiDetailViewModel ...) ...That way the initial request will go to the database, come back with the results and you can then reproject them using a select statement against Linq to objects....But I have to ask why there isn't an FK...

Linq to Entities vs. Linq to SQL vs. Entity Framework

There are two ways of writing queries with Entity Framework:...Linq to Entities ( ...http://msdn.microsoft.com/en-us/library/bb386964.aspx... )...Entity SQL ( ...http://msdn.microsoft.com/en-us/library/bb387145.aspx... )...L2E is not a separate technology, but rather a part of EF....Have a look at this article for a comparison: ...http://thedatafar...

The LINQ expression node type 'Invoke' is not supported in the entity framework's LINQ to Entities.

This problem can be solved using the AsExpandable() method present in LINQKIT by Joe Albahari. He's the same creator of ...PredicateBuilder... that I see you're using....If querying with Entity Framework, change the last line to this:...return objectContext.Products.AsExpandable().Where(predicate);...You can grab LINQKIT DLL ...here... or install i...

LINQ-To-Entity (LINQ to Entities does not support the given type member ".)

The answer to your question is given there : ...Question : Can I create a linq to entity query on non entity member fields...When using thoses LinQ to entity queries, you can only use 'entity members' that are properties that are defined inside your data table....Since your queries are wrapped ("translated") into SQL commands, you must use properti...

LINQ to Entities does not recognize the method 'System.TimeSpan Subtract(System.DateTime)' method

You could use the ...EntityFunctions.DiffDays... method...EntityFunctions.DiffDays(product.EventDate, DateTime.Now) //this will return the difference in days ...UPDATE...EntityFunctions is now obsolete so you should use DBFunctions instead....System.Data.Entity.DbFunctions.DiffDays(product.EventDate, DateTime.Now)

LINQ to Entities does not recognize the method 'System.Linq.IQueryable`

The problem is that LINQ to Entities doesn't understand how to convert that ...Select... overload (the one that gives you the index) into a SQL query. You can fix this by first selecting the portion from the DB you need (to avoid selecting every column unnecessarily), then doing ...AsEnumerable()... to take it as an ...IEnumerable<T>... instead of ...

LINQ to Entities does not recognize the method 'System.String StringConvert(System.Nullable`1[System.Double])

I had the same problem and realized that I was using the wrong type of SqlFunctions. Make sure that you referenced the correct namespace: ...using System.Data.Entity.SqlServer; ...and not: ...using System.Data.Objects.SqlClient;

LINQ to Entities does not recognize the method 'System.DateTime ToDateTime(System.String)' method

Why is your date column a string? Shouldn't it be a ...DateTime...?...Regardless, if you attempt to perform conversions using .NET functions in a .Where statement against a repository of entities, you'll get that error....Your best option would be to change that column from a string to a DateTime and proceed from there. If you do, the ....Where..

LINQ to Entities does not recognize the method 'Int32 IndexOf(System.String, System.StringComparison)' method

The ...IndexOf... method Of string class will not recognized by Entity Framework, Please replace this function with ...SQLfunction... or ...Canonical functions...You can also take help from ...here... or maybe ...here...You can use below code sample:...DataContext.Groups.FirstOrDefault(item => System.Data.Objects.SqlClient.SqlFunctions.CharInd...

LINQ Query to LINQ Method; Why do I need CBool?

When you want the underlying value of a nullable variable, use the Value method. This applies to both vb.net and c#....TotalYearWages = If(DB.interview_earnings. Where(Function(t) t.IID = Input.ID AndAlso t.EarningsYear.Value = Input.EarningsYear). Select(Function(t) t.Amount).Sum(), 0) ...I suggest you make these two fields the same type i...