Top "Linq-to-entities" questions

The type or namespace name 'Objects' does not exist in the namespace 'System.Data'

I am using entities, C# and SQL Server to create an n-tier app. I am creating some base classes common …

c# .net visual-studio-2008 linq-to-entities entities

Linq to Entities join vs groupjoin

I have web searched but I still cant find a simple answer. Can someone please explain (in simple English) what …

c# linq linq-to-entities

How to get first record in each group using Linq

Considering the following records: Id F1 F2 F3 ------------------------------------------------- 1 Nima 1990 10 2 Nima 1990 11 3 Nima 2000 12 4 John 2001 1 5 John 2002 2 6 Sara 2010 4 I want to group by …

c# linq c#-4.0 linq-to-entities

The specified type member is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported

var result = (from bd in context.tblBasicDetails from pd in context.tblPersonalDetails.Where(x => x.UserId == bd.UserId).DefaultIfEmpty() …

entity-framework-4 linq-to-entities

inner join in linq to entities

I have entity called Customer and it has three properties: public class Customer { public virtual Guid CompanyId; public virtual long …

c# .net linq-to-entities

The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties

Using this code in Entity Framework I receive the following error. I need to get all the rows for a …

linq entity-framework-4 linq-to-entities

How to use LINQ to select into an object?

I have data that looks like so: UserId | SongId -------- -------- 1 1 1 4 1 12 2 95 I also have the following class: class SongsForUser { public …

c# .net linq linq-to-entities

Only parameterless constructors and initializers are supported in LINQ to Entities

I have this error in this linq expression : var naleznosci = (from nalTmp in db.Naleznosci where nalTmp.idDziecko == idDziec select …

c# linq-to-entities

How do I perform Date Comparison in EF query?

Please help. I am trying to figure out how to use DATE or DATETIME for comparison in a linq query. …

c# linq datetime linq-to-entities datetime-comparison

LINQ to Entities does not recognize the method 'System.String Format(System.String, System.Object, System.Object)'

I have this linq query: private void GetReceivedInvoiceTasks(User user, List<Task> tasks) { var areaIds = user.Areas.Select(…

linq entity-framework linq-to-entities