Entity Framework 6 - Knowledge Base (KB)
45 results in tag: async-await
async-await issue in EF 6
I'm trying async-await programming with entity-framework 6 (code first) + WPF and I can't see why the UI still freezes after I made the code asynchronous. Here is what I'm doing from the very first line:...first there is an event handler responding to a c...
asked by Vahid
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...
asked by blueFish
Entity Framework 6 - how to convert this line to async?
I am wondering how do I change this statement to be async?... var findBarCode = context.Barcodes .Where(x => x.Code == barcode) .Select(x => x.Product).FirstOrDefault(); ...I don't see like any ...async where... statement I can use.
asked by chobo2
EntityFramework (6) and async ( waitingForActivation)?
I've downloaded ...EF6... ( in order to use ...async...)...So I wrote this simple method : ... public async Task<List<int>> MyasyncMethod() { var locations = await MyDumpEntities.AgeGroups.Select(f=>f.endYear).ToListAsync(); ret...
asked by Royi Namir
FindAsync with non-primary key value
public class Foo { public int Id { get; set; } public int UserId { get; set; } } ...This appears to be the way to do this asynchronously:...DatabaseContext db = new DatabaseContext(); Foo foo = await db.Foos.FindAsync(fooid); ...How does one asy...
asked by Robert
How do I kick off an entity stored procedure in EF6 async and not wait for a return?
I'd like to just punt a call over to the SQL Server and not wait for a return. I have an imported Entity Function from a Stored Procedure that I'd like to call asynchronously this way in Entity Framework 6.0.0-rc1. Is this possible? What's the syntax?..
asked by dirq
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...
asked by Alex
What is the benefit to using await with an async database call
I am just looking at the default MVC5 project and how it uses async in the controllers....I would like to know what benefit async provides here over simply using synchronous calls:... [HttpPost] [ValidateAntiForgeryToken] public async Task<Acti...
asked by Not loved
EF Data Context - Async/Await & Multithreading
I frequently use ...async/await... to ensure ASP.NET MVC Web API threads are not blocked by longer-running I/O and network operations, specifically database calls....The ...System.Data.Entity... namespace provides a variety of helper extensions here, such...
asked by Alex
EntityFramework ToListAsync() does not work
I try to call EF method ToListAsync. But nothing happend - no exception, no timeout just running. ...This is my code.... private IQueryable<Place> placeCompleteQuery; protected IQueryable<Place> PlaceCompleteQuery { get { ...
asked by Martin Majoroš
Why does the EF 6 tutorial use asynchronous calls?
The latest EF tutorial that goes through how to use EF 6 with MVC 5 seems to lean towards using asych calls to the database like:...Department department = await db.Departments.FindAsync(id); ...Is this the new standard/best practice? ...I'm not sure wha...
asked by public static
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...
asked by user3736648
Creating an Async version of a Generic Repository
I have a Generic repository implementing the following interface :...public interface IRepository { IUnitOfWork UnitOfWork { get; } IEnumerable<TEntity> GetWithRawSql<TEntity>(string query, params object[] parameters) where TEntity : class; TEnti...
asked by MHOOS
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 ...
asked by MHOOS
ToListAsync() does not complete at all
I want to execute some queries async. But when I debug through the code, most times when an ToListAsync() is called the program stops. There is no visible exception, and the callstack window is cleared. When I press the pause button in VS, I can see the s...
asked by alex.enjoy
Why isn't SaveChangesAsync actually saving all of my changes?
I think I may be missing something in my understanding of how this is supposed to work. I have some code that imports a file. It loops through each record, does some processing, then adds that record to a table via a ...DbContext... instance....I initiali...
asked by Paul Mrozowski
Entity Framework Queryable async
I'm working on some some Web API stuff using Entity Framework 6 and one of my controller methods is a "Get All" that expects to receive the contents of a table from my database as ...IQueryable<Entity>.... In my repository I'm wondering if there is any ad...
asked by Jesse Carter
EF6 - Using the await keyword with the Where() clause
I am coding a MVC 5 internet application with entity framework 6 and have a question in regards to using the ...await... keyword when using the ....Where()... clause....Here is my code that works:...public async Task<Account> GetAccount(string userName) {...
asked by user3736648
Entity Framework 6 async operations and TranscationScope
I search on stackoverflow but could not find a similar question, please point me if there is already one....I was trying to implement a generic reusable repository with both sync and async operations but with my little knowledge with Entity Framework and ...
asked by Sandeep Kumar
How to create a long running background task from MVC
I am using EF6, MVC 5 in VS 2013.I have a long running task which is causing timeout errors and so I want to set it running as a separate background task and return immediately to the web controller. The background task will report progress to an SQL serv...
asked by Peter Smith
