1 / 21

Writing Clean & efficient data access code with ADO.NET ENTITY FRAMEWORK

Writing Clean & efficient data access code with ADO.NET ENTITY FRAMEWORK. Niraj Bhatt MVP | ASP.NET http://nirajrules.wordpress.com | niraj@indiamvps.net. I am unhappy …. Entity Framework???. Object Relational Mapper

luella
Download Presentation

Writing Clean & efficient data access code with ADO.NET ENTITY FRAMEWORK

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Writing Clean & efficient data access code withADO.NET ENTITY FRAMEWORK Niraj Bhatt MVP | ASP.NET http://nirajrules.wordpress.com | niraj@indiamvps.net

  2. I am unhappy …

  3. Entity Framework??? • Object Relational Mapper • Bridges the impedance mismatch between conceptual (object) & storage (relational) world. STORAGE CONCEPTUAL

  4. More than O/R mapper ADO.NET DATA SERVICES OSLO SQL SERVER REPORTING SERVICES AZURE SQL SERVER ANALYSIS SERVICES

  5. Entity Framework Architecture

  6. DEMO Creating EDM Required Software for Demos: VS.NET 2008 SP1, .NET 3.5 SP1, SQL SERVER 2005 SP2

  7. Exploring EDM

  8. DEMO Querying via EntityClient Required Software for Demos: VS.NET 2008 SP1, .NET 3.5 SP1, SQL SERVER 2005 SP2

  9. DEMO Querying via ObjectQuery Required Software for Demos: VS.NET 2008 SP1, .NET 3.5 SP1, SQL SERVER 2005 SP2

  10. DEMO Querying via LINQ To Entities Required Software for Demos: VS.NET 2008 SP1, .NET 3.5 SP1, SQL SERVER 2005 SP2

  11. DEMO Tracking with ObjectStateManager Required Software for Demos: VS.NET 2008 SP1, .NET 3.5 SP1, SQL SERVER 2005 SP2

  12. CHANGING GEAR Moving to Advanced Concepts

  13. DEMO Tracing, Concurrency, Lazy Loading, Inheritance Required Software for Demos: VS.NET 2008 SP1, .NET 3.5 SP1, SQL SERVER 2005 SP2

  14. What you can expect in V2? • Better integration with rest of .NET stack • WPF, WCF, WF, … • PI Support (Persistence Ignorance) • N-Tier Support • Flip switch for Lazy Loading • Table Value Functions • Improved Tracing • …

  15. References • TSQL vs. ESQL http://msdn.microsoft.com/en-us/library/bb738573.aspx • EF Overview http://www.scip.be/index.php?Page=ArticlesNET12#EntitySQL • eSqlBlasthttp://code.msdn.microsoft.com/esql/Release/ProjectReleases.aspx?ReleaseId=991

  16. References • EF N-Tier Support Discussion http://blogs.msdn.com/efdesign/archive/2008/11/20/n-tier-improvements-for-entity-framework.aspx • EF Performance http://blogs.msdn.com/adonet/archive/2008/02/04/exploring-the-performance-of-the-ado-net-entity-framework-part-1.aspx http://blogs.msdn.com/adonet/archive/2008/06/20/how-to-use-a-t4-template-for-view-generation.aspx

  17. References • EF V2 http://mschnlnine.vo.llnwd.net/d1/pdc08/WMV-HQ/TL20.wmv • EF Automatic Lazy Loading http://www.singingeels.com/Articles/Entity_Framework_and_Lazy_Loading.aspx • EF 3rd Party Providers http://www.sybase.com/detail?id=1057559 http://pgfoundry.org/frs/shownotes.php?release_id=1230 http://sqlite.phxsoftware.com/ http://devart.com/news/2008/directs475.html

  18. Reference Blogs • http://blogs.msdn.com/jkowalski/default.aspx • http://johnpapa.net/ • http://www.thedatafarm.com/blog/ • http://blogs.msdn.com/dsimmons/default.aspx • http://blogs.msdn.com/adonet/default.aspx

  19. Feedback / QnA • Your Feedback is Important! Please take a few moments to fill out our online feedback form • Use the Question Manager on LiveMeeting to ask your questions now!

  20. Contact • Blog Address http://nirajrules.wordpress.com • Email Address niraj@indiamvps.net

More Related