Learning about LINQ [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. We don’t allow questions seeking recommendations for books, … Read more
linq-to-entities
The cast to value type ‘Int32’ failed because the materialized value is null
I have the following code. I’m getting error: “The cast to value type ‘Int32’ failed because the materialized value is null. Either the … Read more
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’ (Value). … Read more
What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
I know some differences of LINQ to Entities and LINQ to Objects which the first implements IQueryable and the second implements IEnumerable and … Read more
Linq-to-Entities Join vs GroupJoin
Can someone please explain what a GroupJoin() is? How is it different from a regular Join()? Is it commonly used? Is it only … Read more
“A lambda expression with a statement body cannot be converted to an expression tree”
In using the EntityFramework, I get the error “A lambda expression with a statement body cannot be converted to an expression tree” when … Read more
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 you replicate that … Read more
How to use DbContext.Database.SqlQuery(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 results: context.Database.SqlQuery<myEntityType>(“mySpName”, param1, … Read more
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 Organization FROM Organizations O JOIN … Read more
Entity Framework VS LINQ to SQL VS ADO.NET with stored procedures? [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question … Read more