Skip to main content

Data Development...

...uses Microsoft's data platform to create data-centric solutions across mobile devices and desktops for web servers, enterprise servers, and the cloud.

Read: Technologies At-a-Glance | Guide for .NET Developers
Technologies Past, Present, & Future

Database Technologies

Database Technologies

Use the SQL Server Database Engine to create relational databases for online transaction processing or online analytical processing data.

Use 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.

  
.NET Technologies

.NET Technologies

Use the 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.

Use 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.

Use the Sync Framework to enable offline access to any data type, any data store, any transfer protocol, and any network topology.

Use the Reactive Extensions (Rx) to perform event stream programming and simplify asynchronous programming using observable sequences and LINQ-style query operators.

  
Application Services

Application Services

Regardless of where your data is stored, you can depend on powerful technologies built into SQL Server, such as SQL Server Integration Services, SQL Server Reporting Services and SQL Server Service Broker to expand the power and scope of your applications.

SQL Server Analysis Services Data Mining and SQL Server Analysis Services Multidimensional Data are powerful tools for analyzing the data contained in your databases.

SQL Server Master Data Services enables you to create a single source of master data and maintain an auditable record of that data as it changes over time.

Look to SQL Server StreamInsight to quickly implement robust and highly efficient event processing applications.

  
Native Technologies

Native and Cross-Platform Technologies

Depend on the MSXML technologies for working with XML.

Access a wide range of data sources via ODBC, OLE DB, and ADO using Windows Data Access Components (WDAC). Get high performance access to Microsoft SQL Server via ODBC and OLE DB connectivity with SQL Server Native Client.

The SQL Server JDBC Driver and the SQL Server Driver for PHP enable rich, scalable Java and PHP applications

Use the Reactive Extensions for JavaScript (RxJS) to simplify asynchronous callback-based and event-driven programming on the web using observable sequences.

  
Tools

Tools

Use SQL Server Data Tools to enhance your ability to create and edit databases, tables, stored procedures and more.

Organize, discover, and enrich your data with Microsoft Power Query for Excel.

  

Roadmap to the Future

Look to new features being planned for the Entity Framework and Data Services.

Data Development Highlights Data and Modeling Highlights

Data Developer Center

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... more
Wednesday, Jan 26
Microsoft announces SQL Server Migration Assistant for MySQL
Microsoft announced today the release of first version of SQL Server Migration Assistant (SSMA) for MySQL! Along with this release, Microsoft refreshed the existing SSMA family of products for Oracle... more
Thursday, Aug 12
Building an AtomPub Server Using WCF Data Services
Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live... more
Monday, Aug 9
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... more
Thursday, Aug 5

View all...

How Do I? Video Series  

View all...

 

Featured Team Blog

Jeff Pinkston
Pinky (also known as Jeff Pinkston) works on the SQL Server "Montego" team.

 

More...

Featured Community Blogger

Lars Wilhelmsen
Lars Wilhelmsen is a Development Manager with KrediNor, Norway. He manages the day-to-day operations in the development department of one of Norway’s largest debt collection agencies by coordinating and supporting his teams with technical mentoring. He’s a Microsoft Connected Systems MVP, Connected Technology Advisor, and the Country Lead of the Norwegian .NET User Group – NNUG (INETA Norway).

 

More...

More Data Development Resources

Data Development Connect

Submit bugs and provide feedback on Microsoft data access technologies.

Data & Modeling Screencasts on Channel 9 Channel 9 Screencasts

Watch videos and connect with your peers.

Data Development Code Gallery Samples Code Gallery

Find the latest data development code samples or upload your own.

Data Development Projects on CodePlex CodePlex

Find open source projects on CodePlex or start your own.

Data Development Articles in MSDN Magazine MSDN Magazine

Read in-depth articles on data development.

patterns & practices patterns & practices

Use Microsoft's proven practices for software engineering.

Open Data Protocol Open Data Protocol

Read about Microsoft's support for the Open Data Protocol (OData)

Email Feedback

Send us your feedback on this site.

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?