M3 So Many Choices, So Little Time: Understanding Your .NET 4.0 Data Access Options

11/15/2010

9:15 am - 10:30 am

Level: Intermediate

Prerequisite: None

Leonard Lobel

MVP

CTO

Sleek Technologies, Inc.

Leonard Lobel is the chief technology officer and co-founder of Sleek Technologies, a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, a Microsoft National Systems Integrator and Gold Competency Partner. He is also a Microsoft MVP, Data Platform. Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive!, Live! 360, SQL PASS, and other industry conferences. Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.

We all know that Microsoft loves to drop new data access APIs in our laps, but since .NET 3.5 SP1, and now with .NET 4.0, the variety of new capabilities and options available is unprecedented, even for Microsoft. The .NET 3.5 SP1 framework gave us Entity Framework (EF), Language-Integrated Query (LINQ), LINQ to SQL (and a variety of other LINQ providers) and WCF Data Services (fka ADO.NET Data Services, aka “Astoria”). Now .NET 4.0 sports a revamped EF 4.0 with N-tier support and add-on WCF RIA Services.

How do you sort out this chaos? Is conventional ADO.NET dead? Is it possible to bridge the DataSet with Silverlight? How do you build an n-tier Silverlight app using domain services and EF 4.0? Lenni will answer these questions (and more) to help demystify the Microsoft data access juggernaut. We’ll compare the real advantages and disadvantages across this set of technologies so that you can choose the best architecture for your application. Attend this session and develop a clear perspective of .NET data access in today’s world.

You will learn: The differences, advantages, and disadvantages across data access technologies including conventional ADO.NET, LINQ to SQL, Entity Framework, WCF Data Services, and WCF RIA Services.