I’d like to use Entity Framework 5 to change pages using Take + Skip. I’ve heard that SQL Server 2012 provides a better way for paging using FETCH and OFFSET which could have a big impact on performance. Does Entity Framework 5 support this? Will the LINQ queries be translated into the new 2012 TSQL if EF is targeting SQL Server 2012?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!