1 / 21

ADO.NE X T Advances in Data Access for 2008

ADO.NE X T Advances in Data Access for 2008. Mike Taulty Developer & Platform Group Microsoft Ltd Mike.Taulty@microsoft.com http://miketaulty.com. What’s Coming in ADO.NET?. Slated for Summer, 2008 as part of an update to VS 2008 and Framework V3.5

yuma
Download Presentation

ADO.NE X T Advances in Data Access for 2008

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. ADO.NEXTAdvances in Data Access for 2008 Mike Taulty Developer & Platform Group Microsoft Ltd Mike.Taulty@microsoft.com http://miketaulty.com

  2. What’s Coming in ADO.NET? • Slated for Summer, 2008 as part of an update to VS 2008 and Framework V3.5 • Current bits are packaged in ASP.NET 3.5 Extensions Preview • More about that package in the next session

  3. Entity Framework

  4. Entity Framework – Key Facts • Extends the ADO.NET Provider Model • Pluggable to support any database • Functionality • Abstracts a model from your store schema • ADO.NET API or LINQ-enabled ORM • Status • Currently at Beta 3

  5. Provider Specific (PL/SQL) “SELECT * FROM CUSTOMERS” ADO.NET Today App Code ADO.NET Command Providers Execute SQL Server DataReader Oracle Oracle Customers Customers Customers ...

  6. ADO.NET Entity Framework Conceptual Model Map Customers UKCustomer UKPremiumCustomer

  7. Provider Agnostic (ESQL) “SELECT * FROM UKCUSTOMER” ADO.NET Entity Framework App Code ADO.NET Conceptual Model Map Entity Provider Command Execute DataReader UKCustomer UKCustomer UKPremiumCustomer Customers UKCustomer Providers* SQL Server Oracle Oracle ...

  8. ADO.NET Entity Framework EF EF .NET Entity Provider (Entity SQL) Programming Model EF Entity Data Model (CSDL) Conceptual Model LINQ Reader Connection Command Entity Entity Object Relational Mapping relationship Mapping (MSL) V2.0 Store Model (SSDL) .NET Data Provider Store Reader Connection Adapter Command

  9. LINQ to SQL? LINQ to Entities?

  10. { Entity Framework } demo

  11. LINQ to Entities – Lots of Topics

  12. EF Providers in Progress

  13. Data Services

  14. Data Services – Key Facts • Extends Windows Communication Foundation V3.5 • Functionality • CRUD access to data over RESTful web services • Built-in URI-based query syntax • Client-side libraries for .NET and AJAX clients • Status • Currently in CTP ( latest December )

  15. RESTful Web Services? Resources HTTP Request Res 1 URL GET Res 2 VERB POST Payload PUT Res 3 JSON JSON XML XML DELETE Res 4 HTTP Response Status Payload

  16. RESTful? • REpresentationalState Transfer • Server-side resources identified by a URI • Access is over HTTP, verb tied to action • GET to read the value of a resource • POST to create a new resource • PUT to update an existing resource • DELETE to delete a resource • Returned data is “plain” – XML or JSON • Is this “the death of SOAP”?

  17. data? what kind of data? • Provide a type with public properties which are; • IQueryable<T>, IEnumerable<T> • Also get write access if your type implements; • IUpdatable • Works well with generated code from; • ADO.NET Entity Framework (ObjectContext) • LINQ to SQL (DataContext*)

  18. { Data Services } demo

  19. What’s Coming in ADO.NET? • Slated for Summer, 2008 as part of an update to VS 2008 and Framework V3.5 • Current bits ASP.NET 3.5 Extensions Preview

  20. Resources http://www.msdnroadshow.co.uk

More Related