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
PowerPivot for Excel to perform data analysis using the familiar toolset of Microsoft Excel.
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.
T4 Templates and the Entity Framework
This paper will discuss how the Entity Framework uses T4 Templates to generate custom code from an ADO.NET Entity Data Model (EDM), and assumes the reader is already familiar with the Entity Framework...
Wednesday, Jan 26
Microsoft Drivers for PHP for SQL Server 2.0 The Microsoft Drivers for PHP for SQL Server provide connectivity to Microsoft SQL Server from PHP applications. In addition to some important bug fixes for the existing SQLSRV driver, version 2.0 rel...
Thursday, Aug 5
Alex James Alex James is a Program Manager on the Data Services Team at Microsoft. He is passionate about unlocking the inherent value in data, and loves cooking up crazy ideas that generally involve leveraging Metadata somehow.
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.