4

Are there any plans to add support for the new features in SQL Server 2014 (namely in-memory OLTP) in the next version(s) of Entity Framework?

Improve this question

1 Answer 1

Reset to default
3

You can connect your Entity Framework (EF) application to a database that has the new memory-optimized tables. The main things you need to look out for is dealing with retries. Also, to get the most out of in-memory OLTP you will want to use natively compiled stored procedures. It is possible to use stored procs in EF, but I guess it's not the default.

At this stage entity framework itself does not support generating memory-optimized tables from code. This is something we are thinking about for a future version.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Thanks for the answer and the retries related warning, I'll add these new error codes in my retry logic now.
Honestly, I still don't know what to make out of the new natively compiled stored procedures... On one hand they'd be great for batch processing, but for business logic - not so much. Business logic does not belong in the data tier in at least 90% of the applications. Improving performance is great but I wish MS had a better answer to the scalability problems addressed by the big data/NoSQL DB-s.
@Valo here is a great explanation of the benefits of this tech, its faster to aggregate large data than passing all the data to C# for example: msdn.microsoft.com/en-us/library/dn452287.aspx

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.