Async Entity Framework Queries
Posted by Phil in .NET on Sep 7th, 2011 | 3 commentsI’ve been writing a lot of Node.js recently, and I’ve really love how the asynchronous database access works, and thought to myself “I wonder if I can do that with Entity Framework?”
While I couldn’t find anywhere in EF the inherently support any form of async calls, I did find that you can with the underlying SqlConnection (assuming you’re using MSSQL.)
So with a little bit of Async CTP magic mixed in, I created an extension method to read the data asynchronously.
Unfortunately I couldn’t find an obvious way to open the connection or write data asynchronously, but I think this is good step.
Phil
3 Responses to “ “Async Entity Framework Queries”
Trackbacks/Pingbacks
- EF ObjectQuery<T> Context, Parameters, Connection properties equivalent on DbSet<T> - [...] Here is an instance: http://philsversion.com/2011/09/07/async-entity-framework-queries [...]
Leave a Reply
About Me
Very nice implementation. I just voted for Support for asynchronous queries on ADO.NET Entity Framework (EF) Feature Suggestions site http://data.uservoice.com/forums/72025-ado-net-entity-framework-ef-feature-suggestions/suggestions/1015385-support-for-asynchronous-queries.
Do you use this now on production?
please also see this: http://stackoverflow.com/a/9434687/463785
“SQL Command is not truly asynchronous until you enable Asynchronous Processing=true on the connection string. While this is not set (and by default is not) your ‘asyncronous’ calls to BeginExecuteReader are nothing but a sham, the call will launch a thread and block that thread. When true async processing is enabled in the connection string then the call is truly async and the callback is based on IO completion.”
Ahh, sorry! You already added that :s
cmd.Connection.ConnectionString = new SqlConnectionStringBuilder(cmd.Connection.ConnectionString)
{
AsynchronousProcessing = true
}.ToString();