Top "Linq-to-entities" questions

This tag is for questions about LINQ to Entities, which means LINQ queries using the ADO.

Dynamic query with OR conditions in Entity Framework

I am creating an application that searches the database and allows the user to dynamically add any criteria (around 50 possible), …

c# sql-server entity-framework linq linq-to-entities
The LINQ expression node type 'ArrayIndex' is not supported in LINQ to Entities

public List<string> GetpathsById(List<long> id) { long[] aa = id.ToArray(); long x; List<string&…

c# arrays linq entity-framework linq-to-entities
Can't get EntityFunctions.TruncateTime() to work

I am using Entity Framework Code First. Using LINQ to Entity I want to grab a record based on a …

c#-4.0 entity-framework-4 linq-to-entities entity-functions
Joining tables using more than one column in Linq To Entities

Every single example of joins in Linq to Entities involves only one column in the on clause. What is the …

entity-framework entity-framework-4 linq-to-entities
How to create LINQ Expression Tree to select an anonymous type

I would like to generate the following select statement dynamically using expression trees: var v = from c in Countries where …

c# linq entity-framework linq-to-entities expression-trees
Group by Weeks in LINQ to Entities

I have an application that allows users to enter time they spend working, and I'm trying to get some good …

c# linq entity-framework linq-to-entities
LINQ to Entities does not recognize the method 'System.TimeSpan Subtract(System.DateTime)' method

I try to select records in database in 60 days 30 days 20 days differents in current date. Please see this query in …

c# linq entity-framework linq-to-sql linq-to-entities
How to create a dynamic LINQ join extension method

There was a library of dynamic LINQ extensions methods released as a sample with Visual Studio 2008. I'd like to extend …

linq linq-to-sql c#-3.0 linq-to-entities linq-to-objects
ADO.NET Entity Connection String for Multiple Projects

I am using multiple layer project where the DataModel hosts the ADo.NET Entity model and DataAccess layer does the …

entity-framework ado.net linq-to-entities ado.net-entity-data-model
How to do a SQL "Where Exists" in LINQ to Entities?

I really want to do something like this: Select * from A join B on A.key = B.key join C …

c# linq linq-to-entities