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.
Darren Jefford Darren Jefford is a Solution Architect for Microsoft Consulting Services in the UK working with a wide range of customers to architect and implement complex solutions on the Microsoft platform.