SQL Server Database Engine to create relational databases for online transaction processing or online analytical processing data.
SQL Azure to move your database to the cloud and
SQL Server Compact to build standalone and occasionally connected applications for mobile devices, desktops, and Web clients.
Entity Framework to easily access databases using LINQ, with direct access to SQL Server and the option to control the mapping between an Entity Data Model (EDM) and raw relational structures.
Data Services for a near-turnkey solution to easily create and consume
OData services on both the web and intranet
Use the core
ADO.NET technology to manually implement a data access layer on top of any data store, and
System.Xml for XML access in .NET. Also see
LINQ to SQL for access to SQL Server tables represented as objects.
Sync Framework to enable offline access to any data type, any data store, any transfer protocol, and any network topology.
Reactive Extensions (Rx) to perform event stream programming and simplify asynchronous programming using observable sequences and LINQ-style query operators.
Shawn Wildermuth Shawn is a Microsoft MVP (C#), MCSD.NET, MCT and is the founder of Wildermuth Consulting Services, LLC, a company that is dedicated to delivering architecture, mentoring and software solutions. He is also a speaker on the INETA Speaker's Bureau and has appeared at several national and international conferences to speak on a variety of subjects.