Installing database systems, tools, and samples
Visual Studio itself does not include any database systems other than those it uses internally. In order to develop a data-connected application in Visual Studio, you typically install the database system on your local development machine, and then deploy the application and database to a production environment when they are ready. The database system must have an ADO.NET data provider in order for it to be accessible from .NET applications, and to be visible in Visual Studio data tool windows. A provider must specifically support the Entity Framework if you plan to use Entity data models in your .NET application. Many providers are offered through the NuGet Package Manager or through the Visual Studio Gallery.
For SQL development, ensure that you have SQL Server Data Tools installed in Visual Studio. Click on the View menu. If you don't see SQL Server Object Explorer then go to control panel, and change Visual Studio. In the installer, check Microsoft SQL Server Data Tools.
If you are using Azure Storage APIs, install the Azure storage emulators on your local machine during development in order to avoid charges until you are ready to deploy to production. For more information, see Use the Azure Storage Emulator for Development and Testing.
The following list includes some of the more popular database systems that can be used in Visual Studio projects. The list is not exhaustive. For list of third-party vendors that offer ADO.NET data providers that enable deep integration with Visual Studio tooling, see ADO.NET Data Providers.
SQL Server is Microsoft's flagship database offering. SQL Server 2016 delivers breakthrough performance, advanced security, and rich, integrated reporting and analytics. It ships in various editions which are designed for different uses from highly-scalable, high-performance business analytics, to use on a single computer. SQLExpress is a full-featured edition of SQL Server that is tailored for redistribution and embedding. LocalDB is a simplified edition of SQLExpress that requires no configuration and runs in your application's process. You can download either or both products from the SQLExpress download page. Many of the SQL examples in this section use SQL Server LocalDB. SQL Server Management Studio (SSMS) is a standalone database management application that has more functionality than what is provided in Visual Studio SQL Server Object Explorer. You can get SSMS from the same link above.
You can download a paid or free edition of the Oracle database from the Oracle Technology Network page. For design time support for Entity Framework and Table Adapters, you will need the Oracle Developer Tools for Visual Studio. Other official Oracle products including the Oracle Instant Client are available through the NuGet Package Manager. You can download Oracle sample schemas by following the instructions in the Oracle Online Documentation
MySQL is a popular open-source database system that is widely used in enterprises and websites. Downloads for MySQL, MySQL for Visual Studio, and related products, are at MySQL on Windows. Third parties offer various Visual Studio extensions and standalone management applications for MySQL. You can browse the offerings in the NuGet Package Manager (Tools | NuGet Package Manager | Manage NuGet Packages for Solution).
PostgreSQL is a free open-source object relational database system. The download page for installing on Windows is here.http://www.postgresql.org/download/windows/. You can also build PostgresSQL from the source code. The PostgreSQL core system includes a C language interface. Many third parties provide NuGet packages for using PostgreSQL from .NET applications. You can browse the offerings in the NuGet Package Manager (Tools | NuGet Package Manager | Manage NuGet Packages for Solution). Perhaps the most popular package is provided by npgsql.org.
SQLite is an embedded SQL database engine that runs in the application's own process. You can download it from the SQLLite Download Page. Many third-party NuGet packages for SQLLite are also available. You can browse the offerings in the NuGet Package Manager (Tools | NuGet Package Manager | Manage NuGet Packages for Solution).