xtrareports-403995-product-information-sample-northwind-database.md
The how-to guides and code examples in our documentation use the Northwind SQLite Database. It is the recommended database for sample applications.
This topic explains how to obtain this database and create a connection to it to follow our tutorials.
Install the following NuGet package to use the SQLite database:
The database ships with the DevExpress installation package. The default path is the following:
Right-click nwind.db, open its properties, and set Copy to Output Directory to Copy if newer.
Create or open the App.config file and add the following connection string to it:
For .NET projects, you can also obtain a data connection string from appsettings.json. For this, make sure you have Microsoft.Extensions.Configuration and Microsoft.Extensions.Configuration.Json installed.
Install the following NuGet package to use the SQLite database:
The database ships with the DevExpress installation package. The default path is the following:
Right-click nwind.db, open its properties, and set Copy to Output Directory to Copy if newer.
Create or open the App.config file and add the following connection string to it:
The Northwind Access 97 database is the legacy database used previously in the Reporting examples. You are encouraged to use the Northwind SQLite database instead.
If your project in Visual Studio 2022 has to connect to Microsoft Access databases, note that Visual Studio 2022 is a 64-bit process, and Microsoft OLE DB Provider for Jet and the Jet ODBC driver are only available in 32-bit versions. It is recommended that you use the 64-bit Microsoft Access Database Engine (Access Connectivity Engine, ACE), or use an earlier version of Visual Studio (VS 2019) that supports 32-bit database providers. For more information, review the following article: Connect to data in an Access database.
Connection String ExamplesMore information on connection strings.Bind Reports to DataThis section explains how to bind DevExpress reports to data sources, including SQL databases, JSON data sources, Excel files, and custom objects.