ADO Entity Framework

ADO Entity Framework PowerPoint PPT Presentation


  • 207 Views
  • Updated On :
  • Presentation posted in: General

What Is It?. The ADO.NET Entity Framework is part of Microsoft's next generation of .NET technologies.It is intended to make it easier and more effective for object-oriented applications to work with data.. 11/26/2011. Daugherty Business Solutions * Brad Tutterow. When Do We Get It?. Originally intended to be part of the Visual Studio 2008 ReleaseNow scheduled for

Download Presentation

ADO 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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


1. ADO.NET Entity Framework Oct 2 2007 * Brad Tutterow

2. What Is It? The ADO.NET Entity Framework is part of Microsoft’s next generation of .NET technologies. It is intended to make it easier and more effective for object-oriented applications to work with data. 11/26/2011 Daugherty Business Solutions * Brad Tutterow

3. When Do We Get It? Originally intended to be part of the Visual Studio 2008 Release Now scheduled for “later”. Entity Framework is currently Beta 2 Entity Framework Tools are currently CTP 11/26/2011 Daugherty Business Solutions * Brad Tutterow

4. The Problem Being Addressed Inherit differences between data expression in a relational database and the same data expressed in an object-oriented application. 11/26/2011 Daugherty Business Solutions * Brad Tutterow

5. The Logical Data Model Almost any business application today has to speak to a relational database. This involves the usual suspects of tables with foreign keys, a smattering of views, and generally a gob of stored procedures. 11/26/2011 Daugherty Business Solutions * Brad Tutterow

6. The Object-Oriented Domain Model Applications themselves are written in a completely different world. The same data that lives in the relational database is represented entirely differently in the application. 11/26/2011 Daugherty Business Solutions * Brad Tutterow

7. The Result The result of this “impedance mismatch” is that developers devote a lot of time and energy writing code to translate between how the database likes to see data and how the application likes to see data. 11/26/2011 Daugherty Business Solutions * Brad Tutterow

8. Other Ways to Address The Same Problem Hibernate (Java) Enterprise Objects Framework (Mac OS) NHibernate (.NET) LINQ to SQL (Visual Studio 2008) And many, many, more … 11/26/2011 Daugherty Business Solutions * Brad Tutterow

9. The ADO.NET Entity Framework The ADO.NET Entity Framework seeks to remedy the problem by providing a layer of abstraction between the logical data model and the application domain. 11/26/2011 Daugherty Business Solutions * Brad Tutterow

10. Why the Entity Model? Closer to the application problem space Better suited for object oriented programming Supports Inheritance Supports complex types Relationships are more meaningful to the application 11/26/2011 Daugherty Business Solutions * Brad Tutterow

11. The “Stuff” in ADO.NET Entity Framework The tools and technology that developers will interact with when using the ADO.NET Entity Framework 11/26/2011 Daugherty Business Solutions * Brad Tutterow

12. Entity Data Model A gob of XML that defines Logical Data Tables, Views, Foreign Keys Entity Objects that Map to the Logical Data The Mapping Between the Two 11/26/2011 Daugherty Business Solutions * Brad Tutterow

13. Entity Data Model Designer A Visual Studio Designer that protects developers from the XML that is the EDM 11/26/2011 Daugherty Business Solutions * Brad Tutterow

14. ObjectContext A code-generated data context created from the Entity Data Model Responsible for managing communication between the conceptual data model and the logical data model 11/26/2011 Daugherty Business Solutions * Brad Tutterow

15. Entities Code-generated class definitions for objects defined in the EDM. 11/26/2011 Daugherty Business Solutions * Brad Tutterow

16. Getting the Data Out How do we get data out of the fancy Entity Data Model? 11/26/2011 Daugherty Business Solutions * Brad Tutterow

17. eSQL (Entity SQL) A brand new SQL language to learn Leverages the rich, object-oriented Entity Data Model Inheritance Collections Complex Types Literal Strings – No Compiler Checking Questionable value in embedded SQL in code 11/26/2011 Daugherty Business Solutions * Brad Tutterow

18. Extensions Methods and String Predicates Queries the object model created against the EDM Still string-based. No compiler checking An ugly mix of code and eSQL statements 11/26/2011 Daugherty Business Solutions * Brad Tutterow

19. LINQ to Entities Full compiler checking. No wondering if the query is valid. A fun new SQL-Like syntax More OO-ish 11/26/2011 Daugherty Business Solutions * Brad Tutterow

20. DEMO Getting data out of the Entity Data Model using LINQ to Entities 11/26/2011 Daugherty Business Solutions * Brad Tutterow

21. What Can You Do? The power of the Entity Data Model contrasted to a logical data model of tables and stored procedures. 11/26/2011 Daugherty Business Solutions * Brad Tutterow

22. Combine Multiple Logical Tables into One Entity Database Tables Entity Data Model 11/26/2011 Daugherty Business Solutions * Brad Tutterow

23. DEMO Combining Two Tables into one EDM Entity 11/26/2011 Daugherty Business Solutions * Brad Tutterow

24. Implement Inheritance Database Tables Entity Data Model 11/26/2011 Daugherty Business Solutions * Brad Tutterow

25. DEMO Implementing Inheritance by marking one Entity as a subclass of another 11/26/2011 Daugherty Business Solutions * Brad Tutterow

26. Other Fun Stuff Implement Complex Types (e.g. Address) Consume Conceptual Model with Reporting Services and other BI Tools Create an EDM that talks to stored procedures Use transactions, manage concurrency, cache execution plans 11/26/2011 Daugherty Business Solutions * Brad Tutterow

27. Manipulate Data By Manipulating Objects 11/26/2011 Daugherty Business Solutions * Brad Tutterow

28. Finding More Information 11/26/2011 Daugherty Business Solutions * Brad Tutterow

  • Login