1 / 17

What’s Coming in 2008 for ADO.NET Data Access

What’s Coming in 2008 for ADO.NET Data Access. Mike Taulty Developer & Platform Group Microsoft Ltd Mike.Taulty@microsoft.com http://www.mtaulty.com. Agenda. ADO.NET Entity Framework Currently at Beta 3 Graphical tooling for VS 2008 at 2 nd preview ADO.NET Data Services

lethia
Download Presentation

What’s Coming in 2008 for ADO.NET Data Access

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. What’s Coming in 2008 for ADO.NET Data Access Mike Taulty Developer & Platform Group Microsoft Ltd Mike.Taulty@microsoft.com http://www.mtaulty.com

  2. Agenda • ADO.NET Entity Framework • Currently at Beta 3 • Graphical tooling for VS 2008 at 2nd preview • ADO.NET Data Services • Currently at December CTP • Both in the ASP.NET 3.5 Extensions Preview • EF releases 1st half of 2008

  3. Entity Framework

  4. ADO.NET Entity Framework • Extends existing ADO.NET model • Adds additional capabilities • Abstraction from the underlying store schema • Abstraction from the underlying SQL dialect ADO .NET V2.0 .NET Provider Store

  5. ADO.NET Entity Framework V3.0 V3.0 .NET Entity Provider (Entity SQL) Programming Model V3.0 ER 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

  6. ADO.NET Entity Framework V3.0 • “Schema independence” • “Store independence” • Higher level constructs • Relationships • Inheritance • Composite Entities ORM & LINQ .NET Provider (EntitySQL) Conceptual Model Mapping V2.0 .NET Provider Store

  7. ADO.NET Entity Framework

  8. Data Services

  9. Data Services • Exposes data over a RESTful web service interface • Entity Framework data • LINQ to SQL data • Any IQueryable data • Server-side is built with Windows Communication Foundation • Returns Atom Publishing Protocol (APP) or JSON • Client-side libraries for .NET and AJAX

  10. RESTful? • REpresentationalState Transfer • In a nutshell; • 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

  11. Data Services - Querying • General Pattern • EntitySet • Key • Navigation Property http://.../<EntitySet>[(<Key>)[/<NavigationProperty>[(<Key>)/...]]] http://.../Customers http://.../Customers(‘ALFKI’) http://.../Customers(‘ALFKI’)/Orders

  12. Data Services - Querying • Query string parameters; • expand • orderby • skip • top • filter http://.../Customers(‘ALFKI’)?$expand=Orders http://.../Customers?$orderby=Country http://.../Customers?$orderby=Country&$skip=10 http://.../Customers?$orderby=Country&$top=10 http://.../Customers?$filter=City eq ‘London’

  13. Data Services – Other Features • Service Operations • Expose more advanced functionality • Query Interceptors • Hook into requests for resources and run custom logic • Update Interceptors • Hook into modifications for resources and run custom logic

  14. ADO.NET Data Services

  15. Resources http://www.asp.net (3.5 Extensions)

  16. MSDN in the UK • Visit http://msdn.co.uk • Newsletter • Events • Screencasts • Blogs

More Related