A software project should have a database. You can use SQL or no-SQL database. You choose SQL when you work with structured data that should have specific constraint and schema. You choose no-SQL if you prefer a simple and high-performance data access. Visual Studio officially support both databases. On this article, we discuss what database option that we have and how to choose the correct option.
SQL Database
You have a lot of options to deploy SQL-based database. We will focus on two main approaches in this post.
SQL database that can be embedded in the application.
If you build a desktop software that run on top of Windows. You can use Microsoft Access.
If you build a web that run on top of Windows based hosting. You can use SQL Compact Edition. You can install the extension on the visual studio marketplace
SQL Database that should deployed separately in the application.
If you build a web that build the database from the scratch or existing SQL script, you can use the SQL Database Project
If you build a web that use code-first design, you can use Code First to a New Database - EF6 | Microsoft Docs
You can deploy both database to Microsoft Azure and your on-premises environment. You can do the deployment process through SQL Server Management Studio or Visual Studio Server explorer or publish profile.
medianet_width = "600";
medianet_height = "250";
medianet_crid = "858385152";
medianet_versionId = "3111299";
No SQL Database
Unfortunately, there is no built-in support for No SQL Database. This is because the NO SQL database is simple enough to install and to implement by using NuGet package manager.
My first choice is to use Mongo DB. You can install the extension of Mongo DB Mongo DB Tools - Visual Studio Marketplace
If you want to deploy into the cloud you can use Cosmos DB. You can visit NuGet Gallery | Microsoft.Azure.DocumentDB 2.13.1
medianet_width = "600";
medianet_height = "250";
medianet_crid = "858385152";
medianet_versionId = "3111299";
Problem
If you are working with the Access Database for your desktop application. You might find the Access OLE DB is not working properly. You can't access the file through server explorer. However, you can still open the file through the Microsoft Access Application.
Possible Cause
This is because the Access OLE DB driver is not registered by Visual Studio and you should register it.
Solution
If you want to use Access for your desktop application, you can install the driver here
if you want to use Access for your web application, please don't do that just replace the Access with SQL Server or SQL Lire version
//