Home  TechNews  Features  Training  Events  Jobs and Contracts  Forums  Blogs  About  Submit   Advertise  Contact

 

Mike Pizzo: From ODBC to ADO.NET Data Services

Michael Pizzo of Microsoft has a long history of working on database access and data programmability. He's been a frequent conference speaker, including several of Ken North's Data Access Workshops at events in North America and Europe.

At DataServices World in New York, Mike Pizzo presented a session about the newest generation of data programmability technology from Microsoft. He was also one of the workshop instructors and demonstrated ADO.NET Entity Framework and ADO.NET Data Services.

Data Access and Data Services Workshop

Adobe PDF logo Slides  

Workshop Part 2 Video   (duration 17:52   Windows Media   MP4  Quicktime)

ADO.NET Entity Framework Podcast (MP3 audio)

The workshop moderator was Michael M. Gorman of Whitemarsh Information Systems. Other panel members included:

  • Dr. Michael Carey (Senior Engineering Director, Oracle BEA Systems)
  • Dr. Carlo Innocenti (Senior XML Program Manager, DataDirect Technologies)
  • LINQ, ADO.NET Entity Framework and Data Services for the Web

    Adobe PDF icon Slides    Video (duration 28:53  Windows Media   MP4  Quicktime  3GP)

    ADO.NET Entity Framework Podcast (MP3 audio, duration 30:06)

    The new wave of Web applications are built on technologies such as AJAX and Microsoft Silverlight, which enable developers to build better, richer user experiences. These technologies bring a shift in how applications are organized, including a stronger separation of presentation from data. Technologies such as Language Integrated Query (LINQ) and ADO.NET Entity Framework and Data Services simplify the job of developers. The ADO.NET Entity Framework raises the level of abstraction for data programming. It is the evolution of ADO.NET that allows developers to program in terms of the standard ADO.NET abstraction or in terms of persistent objects (ORM) and is built upon the standard ADO.NET Provider model. The Entity Framework introduces a set of services around the Entity Data Model (EDM) (a medium for defining domain models for an application). The goal of ADO.NET Data Services is to enable applications to expose data as a REST-based data service that can be consumed by Web clients within a corporate network and across the Internet. The data service is reachable over HTTP, and URIs are used to identify the various pieces of information available through the service. Interactions with the data service happens in terms of HTTP verbs, such as GET, POST, PUT, and DELETE, and the data exchanged in those interactions is represented in simple formats, such as AtomPub and JavaScript Object Notation (JSON).

    About Mike Pizzo

    Mike Pizzo is Principal Architect with the Data Programmability Team at Microsoft. He has been at the forefront of data access for the last 18 of his 21 years at Microsoft, including contributing to ODBC, OLEDB, ADO, ADO.NET and now the Entity Framework. Mike has been a member of the ANSI X3H2 Database Standards Group. He was a US representative in the ISO meeting that approved the SQL/CLI as an extension to the SQL-92 standard.



    Michael Pizzo photo