|
A new kid on the block - with a big slingshot
** November 2–4, 2021 | Free digital event Sign in: LINQ to SQL Getting Started What You Can Do With LINQ to SQL
Typical Steps for Using LINQ to SQL
Date: 10/25/2021 12:56:19 AM ( 3 y ) ... viewed 729 times
Microsoft Ignite
November 2–4, 2021 | Free digital event
Join us November 2–4, 2021 for our digital experience, including the latest product demos, Q&A with Microsoft experts, technical deep-dives, and more. All skill levels welcome!
Sign in:
Docs .NET .NET Framework Data and modeling ADO.NET SQL Server and ADO.NET LINQ to SQL
Search
LINQ to SQL
Getting Started
What You Can Do With LINQ to SQL
Typical Steps for Using LINQ to SQL
Download Sample Databases and Tools
Samples
Get the sample databases for ADO.NET code samples
09/15/2021
2 minutes to read
A number of examples and walkthroughs in the LINQ to SQL documentation use sample SQL Server databases and SQL Server Express. You can download these products free of charge from Microsoft.
Get the Northwind sample database for SQL Server
Download the script instnwnd.sql from the following GitHub repository to create and load the Northwind sample database for SQL Server:
Northwind and pubs sample databases for Microsoft SQL Server
Before you can use the Northwind database, you have to run the downloaded instnwnd.sql script file to recreate the database on an instance of SQL Server by using SQL Server Management Studio or a similar tool. Follow the instructions in the Readme file in the repository.
Tip
If you're looking for the Northwind database for Microsoft Access, see Install the Northwind sample database for Microsoft Access.
Get the Northwind sample database for Microsoft Access
The Northwind sample database for Microsoft Access is not available on the Microsoft Download Center. To install Northwind directly from within Access, do the following things:
Open Access.
Enter Northwind in the Search for Online Templates box, and then select Enter.
On the results screen, select Northwind. A new window opens with a description of the Northwind database.
In the new window, in the File Name text box, provide a filename for your copy of the Northwind database.
Select Create. Access downloads the Northwind database and prepares the file.
When this process is complete, the database opens with a Welcome screen.
Get the AdventureWorks sample database for SQL Server
Download the AdventureWorks sample database for SQL Server from the following GitHub repository:
AdventureWorks sample databases
After you download one of the database backup (*.bak) files, restore the backup to an instance of SQL Server by using SQL Server Management Studio (SSMS). See Get SQL Server Management Studio.
Get SQL Server Management Studio
If you want to view or modify a database that you've downloaded, you can use SQL Server Management Studio (SSMS). Download SSMS from the following page:
Download SQL Server Management Studio (SSMS)
You can also view and manage databases in the Visual Studio integrated development environment (IDE). In Visual Studio, connect to the database from SQL Server Object Explorer, or create a Data Connection to the database in Server Explorer. Open these explorer panes from the View menu.
Get SQL Server Express
SQL Server Express is a free, entry-level edition of SQL Server that you can redistribute with applications. Download SQL Server Express from the following page:
SQL Server Express Edition
If you're using Visual Studio, SQL Server Express LocalDB is included in the free Community edition of Visual Studio, as well as the Professional and higher editions.
See also
Getting Started
Recommended content
Create Relationships Between Tables on a Diagram - Visual Database Tools
Create Relationships Between Tables on a Diagram (Visual Database Tools)
School Sample Database - EF6
School Sample Database for Entity Framework 6
Add This Entry To Your CureZone Favorites! Print this page
Email this page
 Alert Webmaster
|
