TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国(简体中文)
Brasil (Português)
Skip to locale bar
Editing: Entity Framework FAQ: Introduction
Wiki
>
TechNet Articles
>
Entity Framework FAQ: Introduction
Article
History
Title
<html> <body> <p>[[articles:Entity Framework FAQ|Back to EF FAQs Table of Contents]] <br> <br> [toc] </p> <h2><a name="Where_else_should_I_go_to_learn_more_about_the_EF"></a>Where else should I go to learn more about the EF?</h2> <strong> <br> Get started: <br> </strong> <ul> <li><a href="http://msdn.microsoft.com/en-us/data/aa937723.aspx">MSDN Getting Started with the Entity Framework page</a> </li><li><a href="http://blogs.msdn.com/b/adonet/archive/2010/07/19/absolue-beginners-guide-to-entity-framework.aspx">Absolute Beginners Guide to Entity Framework</a> </li><li><a href="http://msdn.microsoft.com/en-us/library/bb399572.aspx">MSDN Docs</a> </li><li><a href="http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=533&SiteID=1">Entity Framework Forum</a> </li><li><a href="http://stackoverflow.com/tags/entity-framework/faq">Stack Overflow EF FAQs</a> </li><li><a href="http://code.msdn.microsoft.com/adonetefx">Entity Framework Samples</a> </li><li><a href="http://msdn.microsoft.com/en-us/data/ee712907.aspx">Beginner's Guide to the Entity Framework</a> </li><li><a href="http://thedatafarm.com/blog/data-access/eight-entity-framework-tutorials-on-datadeveloper-net/">Entity Framework Tutorials</a> </li><li><a href="http://blogs.msdn.com/b/adonet/archive/2010/06/23/teched-north-america-sessions-online-now.aspx">TechEd North America Sessions Online</a> </li><li><a href="http://msdn.microsoft.com/en-us/data/bb525059.aspx#Q3">Top ten questions and answers on data</a> </li><li><a href="http://blogs.msdn.com/b/alexj/archive/2009/03/26/index-of-tips.aspx">Alex James EF Tips and Tricks</a> </li><li><a href="http://www.asp.net/entity-framework/tutorials">Getting Started with the Entity Framework in ASP.NET</a> </li></ul> <strong>Entity Framework team blogs:</strong> <br> <ul> <li><a href="http://blogs.msdn.com/efdesign">EF Design blog</a> </li><li><a href="http://blogs.msdn.com/adonet">ADO.Net team blog</a> </li><li><a href="http://blogs.msdn.com/b/dmcat/">Data and Modeling Customer Advisory team blog</a> </li></ul> <strong>Some individuals (inside and outside Microsoft) who blog about EF:</strong> <br> <ul> <li><a href="http://blogs.rev-net.com/ddewinter/">David DeWinter</a> </li><li><a href="http://weblogs.asp.net/zeeshanhirani">Zeeshan Hirani</a> </li><li><a href="http://blogs.msdn.com/alexj">Alex James</a> </li><li><a href="http://blogs.msdn.com/jkowalski/">Jarek Kowalski</a> </li><li><a href="http://blogs.msdn.com/juyik/">Ju-Yi Kuo</a> </li><li><a href="http://www.thedatafarm.com/blog/">Julie Lerman</a> </li><li><a href="http://blogs.msdn.com/timmall">Tim Mallalieu</a> </li><li><a href="http://blogs.msdn.com/meek">Colin Meek</a> </li><li><a href="http://romiller.com/">Rowan Miller</a> </li><li><a href="http://geekswithblogs.net/iupdateable">Eric Nelson</a> </li><li><a href="http://oakleafblog.blogspot.com/">Oakleaf Systems</a> </li><li><a href="http://blogs.msdn.com/dsimmons/">Danny Simmons</a> </li><li><a href="http://blogs.teamb.com/craigstuntz/">Craig Stuntz</a> </li><li><a href="http://blog.tonysneed.com/">Tony Sneed</a> </li><li><a href="http://blogs.msdn.com/diego/">Diego Vega</a> </li></ul> <strong>MSDN Magazine: <br> </strong> <ul> <strong></strong> <li><a href="http://msdn.microsoft.com/en-us/magazine/ee335715.aspx">Building N<strong>-</strong>Tier Apps with EF4 by Daniel Simmons</a> </li><li><a href="http://msdn.microsoft.com/en-us/magazine/ee321569.aspx">Entity Framework: N-Tier Application Patterns by Daniel Simmons</a> </li><li><a href="http://msdn.microsoft.com/en-us/magazine/dd882522.aspx">Entity Framework: Anti-Patterns To Avoid In N-Tier Applications by Daniel Simmons</a> </li><li><a href="http://msdn.microsoft.com/en-us/magazine/ee336128.aspx">Entity Framework 4.0 and WCF Data Services 4.0 in Visual Studio 2010 by Elisa Flasko</a> </li><li><a href="http://msdn.microsoft.com/en-us/magazine/cc337893.aspx">Standard Query Operators with LINQ by John Papa</a> </li><li><a href="http://msdn.microsoft.com/en-us/magazine/ff898427.aspx">Deny Table Access to the Entity Framework Without Causing a Mutiny by Julie Lerman</a> </li><li><a href="http://msdn.microsoft.com/en-us/magazine/ee336024.aspx">Precompiling LINQ Queries by Julie Lerman</a> </li><li><a href="http://msdn.microsoft.com/en-us/magazine/ee236639.aspx">EF v2 and Data Access Architecture Best Practices by Tim Mallalieu</a> </li></ul> <br> <strong>.NET Framework 4 webcasts: </strong><br> <ul> <li><a href="http://www.oreillynet.com/pub/e/1412">Julie Lerman's Tips and Tricks</a> </li><li><a href="http://channel9.msdn.com/posts/Eric+Nelson/Entity-Framework-4-Part-1-Simple-Model-First/">Entity Framework 4: Part 1 - Simple Model First</a> </li><li><a href="http://channel9.msdn.com/shows/10-4/10-4-Episode-15-Model-First-Development-with-the-Entity-Framework-40/">Model-First Development with the Entity Framework 4</a> </li><li><a href="http://live.ineta.org/videos/notatpdc/agileentityframework4part1.wmv">Agile Entity Framework Part 1: POCO Classes</a> </li><li><a href="http://live.ineta.org/videos/notatpdc/agileentityframework4part2.wmv">Agile Entity Framework Part 2: Repositories & Testing</a> </li><li><a href="http://channel9.msdn.com/posts/Eric+Nelson/MSDN-Flash-Podcast-014--Entity-Framework-and-ADONET-Data-Services-at-TechEd-Europe/">Entity Framework and ADO.NET Data Services</a> </li><li><a href="http://microsoftpdc.com/Sessions/FT10">Evolving ADO.NET Entity Framework in .NET 4 and Beyond</a> </li></ul> <br> <strong>Books: <br> </strong> <ul> <li><a href="http://oreilly.com/catalog/9780596807252">Programming Entity Framework, second edition</a> </li><li><a href="http://www.amazon.com/Entity-Framework-4-0-Recipes-Problem-Solution/dp/1430227036/ref=sr_1_1?ie=UTF8&s=books&qid=1275575646&sr=1-1">Entity Framework 4.0 Recipes: A Problem-Solution Approach</a> </li><li><a href="http://www.amazon.com/Microsoft-Entity-Framework-Stefano-Mostarda/dp/1935182188/ref=sr_1_10?ie=UTF8&s=books&qid=1275575690&sr=1-10">Microsoft Entity Framework in Action</a> </li></ul> <strong>Forums / Places to Ask Questions: <br> </strong> <ul> <li><a href="http://social.msdn.microsoft.com/forums/en-US/adodotnetentityframework/threads">MSDN EF Forum</a> </li><li><a href="http://social.msdn.microsoft.com/Forums/en-US/adonetefx/threads">MSDN EF Pre-Release Forum</a> </li><li><a href="http://stackoverflow.com/tags/entity-framework/faq">Stack Overflow Entity Framework FAQ</a> </li><li><a href="http://forums.asp.net/1227.aspx?ADO.NET%2c+Entity+Framework%2c+LINQ+to+SQL%2c+NHibernate">ASP.NET Entity Framework forum</a> </li></ul> <h2><a name="How_can_I_get_the_Entity_Framework_bits"></a>How can I get the Entity Framework bits?</h2> <p>The first release of the Entity Framework (called EF 3.5 SP1) is part of Visual Studio 2008 sp1 and the .Net Framework 3.5 sp1. <br> <br> The second release of the Entity Framework (called EF4) is part of Visual Studio 2010 and the .Net Framework 4. </p> <h2><a name="What_s_new_in_EF4"></a>What's new in EF4?</h2> <p>See the following resources: </p> <ul> <li><a href="http://msdn.microsoft.com/en-us/library/ex6y04yf.aspx"><span style="color:#0066dd">What's New in ADO.Net</span></a> </li><li><a href="http://thedatafarm.com/blog/data-access/screencast-ndash-what-rsquo-s-new-in-the-entity-data-model-designer-in-vs2010/"><span style="color:#0066dd">Screencast -- What's new in the Entity Data Model Designer in VS2010</span></a> </li><li><a href="http://www.asp.net/entity-framework/tutorials/what-s-new-in-the-entity-framework-4">What's New in the Entity Framework 4</a> </li></ul> <h2><a name="Why_use_the_EF_and_Entity_Data_Model_EDM_How_do_they_help"></a>Why use the EF and Entity Data Model (EDM)? How do they help?</h2> <p>The first way to look at this is to ask, why use an Object/Relational Mapper (O/RM) at all. For that I suggest looking at Glenn Block's post <a href="http://blogs.msdn.com/b/gblock/archive/2006/10/26/ten-advantages-of-an-orm.aspx?wa=wsignin1.0"> Ten Advantages of an ORM</a>. <br> <br> Next, you might ask, why use the EF in particular. One opinion about that question appears in the post <a href="http://blogs.msdn.com/b/dsimmons/archive/2008/05/17/why-use-the-entity-framework.aspx"> Why use the Entity Framework</a>. <br> <br> If you ask about the Entity Data Model in particular, the key thing is that it enables developers to reason about and write queries in terms of a higher-level conceptual model rather than the relational database schema of tables, joins, foreign keys, and so on. Many enterprise systems have multiple applications/databases with varying degrees of normalization, different schema styles, and different naming conventions for tables and columns. Furthermore, in complex systems the entities of interest may be scattered across multiple rows in multiple tables, and changes to the logical schema can be painful to track within applications. By adding an additional level of abstraction, the EDM insulates developers from the low-level details of the logical model, and frees them to focus on the essential aspects of the application/problem at hand. For more information, see <a href="http://msdn.microsoft.com/en-us/library/bb399567.aspx">Introducing the Entity Framework</a>. </p> <h2><a name="Where_can_I_learn_about_plans_for_the_next_release_of_the_EF"></a>Where can I learn about plans for the next release of the EF?</h2> <p>The <a href="http://blogs.msdn.com/efdesign/">EF Design blog</a> is intended to significantly increase the transparency of design for the EF. The Entity Framework team also launched a website that allows you to easily submit and vote on feature requests for the EF: <a href="http://ef.mswish.net/">http://ef.mswish.net/</a>. </p> <h2><a name="What_are_some_tools_that_work_with_the_Entity_Framework"></a>What are some tools that work with the Entity Framework?</h2> <p>The following tools help with debugging and troubleshooting: </p> <ul> <li><a href="http://blogs.msdn.com/b/dmcat/archive/2010/04/30/profiling-entity-framework-using-the-visual-studio-2010-profiler.aspx">Visual Studio 2010 Profiler</a>. </li><li><a href="http://efprof.com/">Entity Framework Profiler</a> is a real-time visual debugger. </li><li><a href="http://msdn.microsoft.com/en-us/library/dd264915.aspx">IntelliTrace</a> is part of Visual Studio 2010 Ultimate. This tool provides an enhanced picture of your application compared with traditional debuggers. </li><li><a href="http://msdn.microsoft.com/en-us/library/ms181091.aspx">SQL Server Profiler</a> allows you to see which queries are hitting the database. </li><li><a href="http://visualstudiogallery.msdn.microsoft.com/en-us/99468ece-689b-481c-868c-19e00e0a4e69">Visualizer</a> is an add-in for Visual Studio that enables you to see what queries will be issued based on your ObjectQuery query. </li><li><a href="http://huagati.com/L2SProfiler/">Huagati Query Profiler</a> is a runtime query profiling toolkit for <a href="http://huagati.blogspot.com/2010/06/entity-framework-support-in-huagati.html"> Entity Framework 4</a>, Linq-to-SQL, and LLBLGen. </li></ul> The following are some tools that work in combination with the Entity Framework: <br> <ul> <li><a href="http://www.huagati.com/dbmltools/">Huagati DBML/EDMX Tools</a> is an add-in for Visual Studio that adds new functionality to the ADO.NET Entity Framework designer in Visual Studio 2008 and 2010, such as e.g.: rule-based mass renaming of entities and members, selective compare and sync between the database, SSDL, and CSDL portions of EFv4 models. </li><li><a href="http://www.devart.com/entitydeveloper/">Entity Developer</a> is a modeling and code generation tool for the ADO.NET Entity Framework. </li><li><a href="http://www.llblgen.com/defaultgeneric.aspx">LLBLGen Pro</a> is an advanced O/RM Designer for the .NET Framework and offers, among other things, Entity Framework support. This tool is highly complementary to the Entity Framework designer. </li><li><a href="http://www.linqpad.net/">LINQPad</a> is a great tool for learning LINQ and the Entity Framework. </li><li><a href="http://www.nakedobjects.net/home/index.shtml">The Naked Objects framework</a> works with the Entity Framework to create fully functional web applications from domain objects automatically. </li></ul> <h2><a name="How_can_I_contribute_to_this_FAQ"></a>How can I contribute to this FAQ?</h2> <p>The content on this site resides on the <a href="http://social.technet.microsoft.com/wiki/"> Microsoft Technet Wiki</a>. As a wiki, it is very easy to contribute to.<br> <br> The only thing you have to do in order to get set up to contribute is go here (<a href="http://social.technet.microsoft.com/wiki/contents/articles/129.aspx">http://social.technet.microsoft.com/wiki/contents/articles/129.aspx</a>) and sign up. What this consists of is getting a <a class="zem_slink" title="Windows Live ID" href="http://login.live.com/" rel="homepage"> Windows Live ID</a>, and registering a Display Name so you can earn points, which count towards attaining <a class="zem_slink" title="Most Valuable Player" href="http://en.wikipedia.org/wiki/Most_Valuable_Player" rel="wikipedia"> MVP</a> status. </p> <p>Once you do that, you are good to go, and can edit and create wiki topics at will. If you haven’t worked with <a class="zem_slink" title="Wiki" href="http://en.wikipedia.org/wiki/Wiki" rel="wikipedia"> wikis</a> before, the above link has further links that will introduce you to the process.<br> <br> The easiest way to start is to edit an existing topic. The FAQs are divided into categories, and each category is a separate wiki topic that contains multiple questions. So if you want to add to an existing question, that is probably the easiest thing to do. If you have a new queston that fits into an existing category, you can also do that pretty easily: just try to be consistent with the existing styles. Questions that don't fit into existing categories are a bit harder: you will need to create a new Category page, and add it to the table of contents. Perhaps a simple solution would be to add a Miscellaneous category, and only add other new categories when enough questions arise to populate it.</p> <h2><a name="What_would_be_some_good_additions_to_this_FAQ"></a>What would be some good additions to this FAQ?</h2> <p>The existing content reflects the latest Entity Framework version that had been released when it was written: version 4.0. So content relating to the following is not there: </p> <ul> <li>DbContext </li><li>DbSet </li><li>Code-First </li></ul> <h2><a name="Didn_t_there_used_to_be_a_different_FAQs_web_site_Why_did_you_move_it"></a>Didn't there used to be a different FAQs web site? Why did you move it?</h2> <p>Glad you asked! There were two main reasons:</p> <ul> <li>The current build process for that site requires someone to run it who understands it, but more importantly: </li><li>The FAQs site ought to be a community resource, and members of the Entity Framework community ought to be able to contribute to it easily, without going through a “single person bottleneck”. The wiki format meets this requirement much better. </li></ul> <p>The old website will not be maintained: at some point we will add a link to this site.</p> <h2><a name="What_s_with_the_Technet_name_in_the_wiki_I_m_a_developer_and_never_go_to_Technet_why_isn_t_this_content_on_MSDN"></a>What's with the Technet name in the wiki? I'm a developer and never go to Technet: why isn't this content on MSDN?</h2> <p>Well, the truth is, Microsoft is experimenting with different ways to involve the community. We have been doing wikis for a relatively shorter period of time, and are still experimenting: the Technet wiki site was available for us to use, and doing so allows us to focus on the best ways to engae with the community, rather than on learning a new technology and all the associated infrastructure. At the present time, this wiki is a very convenient testbed for us as we learn to use this medium.<br> <br> Although this content is on Technet, our main audience is you the developer.<br> <br> </p> <h1><a name="Other_Languages"></a>Other Languages </h1> <blockquote dir="ltr" style="margin-right:0px"> <p> <span class="breadcrumb-item"><a class="last" href="http://social.technet.microsoft.com/wiki/contents/articles/6433.aspx"><span style="color:#00749e">Entity Framework FAQ: Introducción (es-ES)<br> </span></a>[[articles:Entity Framework FAQ: Introduction (ru-RU)|Russian]] <strong> </strong></span></p> </blockquote> <p><span style="color:#ff0000"> <br> <br> [[articles:Entity Framework FAQ|Back to EF FAQs Table of Contents]]</span></p> <p> </p> </body> </html>
Comment
Tags
Please add 3 and 2 and type the answer here: