Entity Framework 6 - Knowledge Base (KB)

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

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 the 'Contains' Clause in Entity Framework instead of the 'IN' SQL Clause

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 between IEnumerable and IQueryable as ObjectSet types

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...

IQueryable vs. IEnumerable in the.NET Entity Framework

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 ...

It is preferable to utilize Entity Framework. First() or . For "TOP 1," how about (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...