Entity Framework 6 - Knowledge Base (KB)

C# Silverlight with Entity Framework - Change Return Type On AutoGenerated EntityQuery?

Background...Currently I have a C# Silverlight business application which uses RIA Services. The application is hosted in ASP.NET using the ADO.NET Entity Framework and a domain service class to read and write to the SQL Server database....Scenario...I ha...

Using 'Contains' Clause Like 'IN' SQL Clause in Entity Framework

I am working on a tag cloud application. There are 3 database tables....Content...: ContentID, Text...Tag...: TagID, Name...TagRelation...: TagRelationID, TagID, ContentID...The code below is wrong. Because 'Contains' clause doesn't take a list of paramet...

Differences when using IEnumerable and IQueryable as a type of ObjectSet

As I understand it when I use LINQ extension methods (with lambda expression syntax) on ...IQueryable... that is in the fact instance of ...ObjectSet... they are translated into LINQ to SQL queries. What I mean is that command...IQueryable<User> users = d...

.NET Entity Framework - IEnumerable VS. IQueryable

Please see this line of code. This is an invocation of a stored procedure, which returns an ...ObjectResult<long?>.... In order to extract the long values I added the Select:...dbContext.FindCoursesWithKeywords(keywords).Select(l => l.Value); ...Based on ...

With Entity Framework is it better to use .First() or .Take(1) for "TOP 1"?

We are implementing some EF data repositories, and we have some queries which would include ...TOP 1...I have read many posts suggesting to use ....Take(1)... The code I'm reviewing uses ....First()...I understand that both of these produce the same resul...

LINQ ToListAsync expression with a DbSet

I have coded a C# MVC5 Internet application, and have a question about using the ....ToListAsync... LINQ expression....Here is my code that works in an Index action result:...IEnumerable<IMapLocationItem> mapLocationImageGalleries = await db.mapLocationIm...

Why DbSet<TEntity> doesn't implement EnumerableAsync

In Entity framework 6.1.1 an IDbSet represents the collection of entities which can be queried from the database and its concrete implementation is DbSet as described in...DbSet...How come this interface or its concrete implementation doesn't contain any ...

Using Dynamic LINQ Where in a one-to-many Entity Framework relationship

I am using EF 6 and .net 4.5. I have a "Documents" table with the PK "DocumentId" (Int) and another column, "Title". I have another table called "DocumentFilters" with the columns "DocumentId" (Int) and "DocGUID" (Guid). There is a FK on "Doc Id" between...

How to use IEnumerable as a navigation property instead of IList

How to use ...IEnumerable... as a navigation property, I don't want to expose a List for the client developer and give him extra distracted,undesirable functionalities like ...Clear(),CopyTo().... ...So I did the following :... private readonly List<WorkT...