Adventure Works by Logotec App Studio for Windows 10 Adventure Works is a Windows 10 (Universal Windows Platform) cloud solution based on Microsoft example database Adventure Works. The new Wide World Importers sample databases are now available! For documentation and download information, see SQL Server Samples on MSDN. This site contains downloads for AdventureWorks and corresponding scripts that showcase features available in SQL Server 2016 CTP3.
-->
This topic describes how to connect to an AdventureWorks Light (AdventureWorksLT) sample database using SQL Server 2008 for use with ASP.NET Web sites or projects in Visual Studio. Because the AdventureWorksLT sample databases are used with many code examples and sample applications, it is helpful to have an instance of the sample database set up in your development environment. You can also follow the steps in this topic to set up and access any other SQL Server 2008 database in a Web site or project.
Two versions of the AdventureWorksLT database are included with the AdventureWorks 2008 database samples. AdventureWorksLT 2008 is an updated version of the original AdventureWorks sample database that has a new schema and data types. AdventureWorksLT is the 2005 version of the database with the original schema, updated to run on SQL Server 2008. You can use either version.
This topic describes how to perform the following tasks:
In order to complete the procedures that are described in this topic, you will need:
Installing the DatabaseTo install the sample database
Connecting to the Database
After the installation process for the database has completed, you can add a connection to the database in Visual Studio. You can use this connection with any kind of ASP.NET Web site, service, or project that can use a data connection.
To add a connection to the database
Example
After you have installed the AdventureWorksLT database and added a connection in Visual Studio, you can access the data from an ASP.NET Web site or project. There is not a single way to do this, because the approach that you use to access data depends on the type of Web site or project you create. If you have already created a Web site or project in Visual Studio, you can use the connection to AdventureWorksLT that is described previously with any kind of wizard or data source control to access the data. Microsoft sam voices download.
In general, you can access the AdventureWorksLT data in Visual Studio using one of the following approaches:
Download Adventureworkslt
The following example shows a connection string in a Web.config file that references the AdventureWorkLT2008 sample database that is running on a local SQL Server 2008 Express instance.
See AlsoTasksSql Server 2016 Adventureworks DownloadOther ResourcesComments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |