Data access in Visual Studio
Using Visual Studio, you can create applications that connect to any kind of data, covering practically any database product or service in any format and anywhere: either from a local machine, LAN server, or located in the cloud.
The IDE enables you to explore data sources or create object models to store and manipulate data in the memory, and—of course—establish data-binding techniques in the user interface, no matter what type of UI you want: Console, Windows Forms, Windows Presentation Foundation, websites created with ASP.NET, and so on.
Besides, Microsoft Azure provides SDKs for .NET, Java, Node.js, PHP, Python, Ruby, mobile apps, and tools in Visual Studio in order to connect to Azure Storage.
The following table shows you the variety of database connections available in recent versions of the IDE:
|
Microsoft Azure (SQL and NoSQL) | ||
|---|---|---|
|
SQL Database (Azure) |
Azure Storage (Blobs, Tables, Queues, Files) |
SQL Data Warehouse (Azure) |
|
SQL Server Stretch Database (Azure... | ||
