Entity Framework 6 - Knowledge Base (KB)

EF6 alpha Async Await on an Entity Stored Procedure / Function Import?

I'd like to apply the new async await functionality to Stored Procedures / Function Imports imported in my Entity model, but have as yet been unable to with the EF6 alpha....Is it yet possible in EF6 alpha2 (or the nightly build as of 20211) to call any o...

How to asynchronously call a database with subrecords using LINQ?

I'm using EF6 and want to make the following query fully asynchronous:... await MyDataContext.ADbSet. First(a => a.Something == "Something"). ASubCollection. Select(x => new { x.SubCollectionI...

ASPNET.Identity and MVC5

I am trying to build authentication using the new Identity and MVC5 but I would like to "join" a separate ...user... table to the registration and manage pages. I have read lots on extending the AspNetUser table, but I am desperate to find how to join a s...

How to get column names and and their values to array tuple list with Entity Framework

I would like to get "Column Name, Column's Value" in an tuple array list with ...entity framework.......I have this:...var colNames = typeof(tbl_ObisSchema).GetProperties().Select(a => a.Name).ToList(); ...to get all column names... using (var dbContext =...

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

Unable to Connect to MySQL in ASP.NET MVC using Entity Framework 6.0.0.0

Unable to Connect to MySQL in ASP.NET MVC using Entity Framework 6.0.0.0...a few seconds ago|LINK...Hi,...I have tried all night to connect my ASP.NET MVC project to MySQL database but am unsuccessful. I found code to connect to a MySQL database (using MV...

ASP.NET Identity + Entity Framework + SQLite to share

For our project needs, I created my own ASP.NET Identity 2.0 Provider with SQLite database, and Entity Framework used in MVC 5.2 application. It's methods are all async. All of the problems with the connection to SQLite DB are resolved (I saw many questio...

Group by some columns depending on values in Entity Framework

I have the following simple statement in my Entity Framework code:... query = query .Where(c => c.NotificationType == NotificationType.AppMessage) .GroupBy(c => c.ConversationId) .Select(d => d.OrderB...