【IT168 技术文档】
Microsoft SQL Server 2008 and
Microsoft Data Platform Development
SQL Server Technical Article
Writer: Lin Joyner (Content Master)
Technical Reviewers: Anthony Carrabino (Microsoft), Elisa Flasko (Microsoft)
Project Editor: Joanne HodginsPublished: August 2007
Applies To: SQL Server 2008
Summary: Microsoft SQL Server 2008 and the Microsoft data platform provide developers with a comprehensive programming framework in which to create data centric solutions that target mobile devices, desktops, Web servers, and enterprise servers. This data programming environment improves developer productivity by integrating data access and management into the business logic of an application. It provides a comprehensive platform for data access and management from disparate data sources and a scalable solution for data storage and applications.
For the latest information about SQL Server 2008, please see http://www.microsoft.com/sql.
Copyright
This is a preliminary document and may be changed substantially prior to final commercial release of the software described herein.
The information contained in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication.
This White Paper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.
Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.
Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.
Ó2007 Microsoft Corporation. All rights reserved.
Microsoft, IntelliSense, SQL Server, Visual C# and Visual Studio are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.
The names of actual companies and products mentioned herein may be the trademarks of their respective owners.
Table of Contents
Introduction 1
Improved Productivity 1
ADO.NET Entity Framework 1
LINQ 2
Visual Studio 3
Comprehensive Data Platform 3
Data Connectivity Technologies 4
Rich Data Programmability Capabilities 4
Your Data, Any Place, Any Time 5
Scalable Data-Centric Solutions 5
Scalable Data Storage 5
Scalable Applications 6
Conclusion 6
Introduction
As database systems and programming languages have evolved over the years they have each concentrated on their specific functionality and drifted apart in terms of communication between the two. This has resulted in an impedance mismatch between the data storage and business logic in today’s applications. SQL Server 2008 in conjunction with the Microsoft Data Platform technologies enables you to quickly and easily build comprehensive and scalable data-centric solutions that bridge the mismatch.
Specifically, the ADO.NET Entity Framework defines a new way for developers to conceptualize data into easy-to-use entities and a revolutionary technology called LINQ defines a new and powerful data access query syntax to communicate directly with virtually any type of data, including entities and SQL Server 2008.
SQL Server 2008 focuses on three key areas to meet today’s data programmability needs:
Productivity. SQL Server 2008 and Microsoft Visual Studio® enable developers to be more productive through the use of new data models, syntax, and team tools.
Connectivity. SQL Server 2008 supports new and legacy data connectivity technologies, which enables developers to work with the most appropriate technology for their requirements.
Scalability. SQL Server 2008 provides a scalable database system for many different types of workloads, from mobile devices to enterprise solutions. It also integrates with Visual Studio, and so enables developers to build scalable solutions.