Click here to Skip to main content
14,547,542 members
Articles » Database » Database » ADO.NET » Revisions

Select N+1 Problem – How to Decrease Your ORM Performance

Rate this:
4.95 (12 votes)
Please Sign up or sign in to vote.
4.95 (12 votes)
18 Aug 2010CPOL
This post will introduce the select N+1 pitfall and explain how to avoid it in Entity Framework.



Compare Revision Minor Date Status Editor
3 - publicly available No 18-Aug-10 2:11 Available Deeksha Shenoy
1 No 17-Aug-10 23:14 Composing


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Gil Fink
Technical Lead sparXys
Israel Israel
Gil Fink is a web development expert and ASP.Net/IIS Microsoft MVP. He is the founder and owner of sparXys. He is currently consulting for various enterprises and companies, where he helps to develop Web and RIA-based solutions. He conducts lectures and workshops for individuals and enterprises who want to specialize in infrastructure and web development. He is also co-author of several Microsoft Official Courses (MOCs) and training kits, co-author of "Pro Single Page Application Development" book (Apress) and the founder of Front-End.IL Meetup. You can read his publications at his website:

Comments and Discussions


11 bookmarked