Use the tag Visual Studio when you are having issues using Visual Studio in combination with a database system.

In Visual Studio, you can create applications that connect to data in virtually any database product or service, in any format, anywhere — on a local machine, on a local area network, or in a public, private, or hybrid cloud.

For applications in JavaScript, Python, PHP, Ruby, or C++, you connect to data like you do anything else, by obtaining libraries and writing code. For .NET applications, Visual Studio provides tools that you can use to explore data sources, create object models to store and manipulate data in memory, and bind data to the user interface. Microsoft Azure provides SDKs for .NET, Java, Node.js, PHP, Python, Ruby, and mobile apps, and tools in Visual Studio for connecting to Azure Storage.

With Visual Studio (2017) you can connect to the following Database Systems:

Microsoft Azure

  • SQL Database
  • Document DB
  • SQL Data Warehouse
  • Storage (blobs, tables, queues, files)
  • SQL Server Strech Database
  • StoreSimple

SQL

  • SQL Server 2008 - 2017 (incl, Express and LocalDB)
  • Firebird
  • MariaDB
  • MySQL
  • Oracle
  • PostgreSQL
  • SQLite

NoSQL

  • Apache Casandra
  • CouchDB
  • MongoDB
  • NDatabase
  • OrientDB
  • RavenDB
  • VelocityDB

Many database vendors and third parties support Visual Studio integration by NuGet packages. You can explore the offerings on nuget.org or through the NuGet Package Manager in Visual Studio (Tools > NuGet Package Manager > Manage NuGet Packages for Solution). Other database products integrate with Visual Studio as an extension.

References / Further Reading

history | excerpt history