Microsoft SQL Server 2008 R2 Unleashed- P186:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 1804 CHAPTER 45 SQL Server and the .NET Framework Let s get started. First create a new web application project or website using Visual Studio 2008. Next right-click that project and select Add New Item. On the ensuing Add New Item dialog click on the Data node under the Categories heading on the left. Under Templates click Entity Data Model and name your model file . This is illustrated in Figure . FIGURE Creating a new Entity Data Model in Visual Studio 2008. On the ensuing Entity Data Model Wizard dialog be sure the Generate from Database option is selected and click Next. On the Choose Your Data Connection screen select or create a connection to AdventureWorks2008 and then click Next. The result of this step is a new connection string written to your file. NOTE If you examine this connection string you will notice that it utilizes the new provider rather than the traditional . It also uses a new metadata parameter in its connection string itself which points to Conceptual Schema Definition Language CSDL and Storage Metadata Schema SSDL XML content found in the EDM file. CSDL provides markup for describing content models such as EDMs. SSDL provides markup for describing the underlying data stores used by EDMs. For more information consult the MSDN articles Conceptual Schema CSDL and Storage Metadata Schema SSDL . On the Choose Your Database Objects screen that follows expand the Tables node and then select the same four tables used previously in the LINQ to SQL examples Using Data Services 1805 and . Take note of the name of your model AdventureWorks2008Model and then click Finish. The EDM Designer surface opens to reveal your new EDM with your four selected entities as illustrated in Figure . FIGURE Visualizing the Entity Data .
