Top "Linq-to-entities" questions

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

How to do SQL Like % in Linq?

I have a procedure in SQL that I am trying to turn into Linq: SELECT O.Id, O.Name as …

.net linq tsql linq-to-entities sql-like
How to use DbContext.Database.SqlQuery<TElement>(sql, params) with stored procedure? EF Code First CTP5

I have a stored procedure that has three parameters and I've been trying to use the following to return the …

c# sql ado.net linq-to-entities entity-framework-ctp5
Problem with converting int to string in Linq to entities

var items = from c in contacts select new ListItem { Value = c.ContactId, //Cannot implicitly convert type 'int' (ContactId) to 'string' (…

c# asp.net linq-to-entities tostring
Linq to Entities - SQL "IN" clause

In T-SQL you could have a query like: SELECT * FROM Users WHERE User_Rights IN ("Admin", "User", "Limited") How would …

.net linq linq-to-entities in-clause
LEFT JOIN in LINQ to entities?

I'm trying out LINQ to entities. I have a problem with the following: I want it to do this: SELECT …

c# linq entity-framework entity-framework-4 linq-to-entities
How to store a list in a column of a database table

So, per Mehrdad's answer to a related question, I get it that a "proper" database table column doesn't store a …

sql linq linq-to-sql database-design linq-to-entities
Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures?

How would you rate each of them in terms of: Performance Speed of development Neat, intuitive, maintainable code Flexibility Overall …

sql linq-to-sql entity-framework ado.net linq-to-entities
Entity framework left join

How do I change this query so it returns all u.usergroups? from u in usergroups from p in u.…

c# linq entity-framework linq-to-entities left-join
Best way to check if object exists in Entity Framework?

What is the best way to check if an object exists in the database from a performance point of view? …

entity-framework linq-to-entities exists
"NOT IN" clause in LINQ to Entities

Is there anyway I can create a not in clause like I would have in SQL Server in Linq to …

c# linq-to-entities