ado.net data services

ADO.NET Data Services:

The glue between users, data and websites

How do I work with data on my website?

Problem

Database ?

House of cards

WCF Service

WCF ClientVisual Studio

Visual Studio

How do I work with data on my website where I am not restrained?

Problem Revised

Database ?

Expose data differently = REST

Solution

It is an architectural style for connecting distributed applications

What is REST?

ADO.NET Data Services is a RESTful implementation

Solution

Architecture

URLHTTP

METHOD

LINQ to Entities

SQL

ADO.NET Data Services

Entity Framework

SQL Server

ClientClient

Server1

2 HTML + JavaScript

DEMO

Step 1

Build the RESTful Service

Layers

URLHTTP

METHOD

LINQ to Entities

SQL

ADO.NET Data Services

Entity Framework

SQL Server

http://[site]:[port]/coolmail.svc/Mails(guid'id')

var result = (from m in Mails where m.Id=new Guid('id') select m).First();

SELECT m.Id, m.Sent, m.Subject, m.Sender FROM MailsWHERE m.Id = ‘id’

DEMO

Enhance the Service

DEMO

Step 2

Build the Client

It can do Create/Update/Delete - as easy as changing the HTTP method

Can consume just like a WCF service

What have I skipped?

www.sadev.co.za

The slide deck

Expanded demo code

www.drp.co.za

ADO.NET Data Services Cheat Sheet

Want More?