VKinfotek Inc.
  • Us
    About Us
    Contact Us
  • FAQs
  • Ready Software
    Ready ERP ASP Core Software for Azure Cloud
    Ready Web ERP Software
    Ready ASP.Net Azure Software
    Ready C# SQL Server Accounting Software
    Ready ASP.Net MVC and EF Software
First slide
Earn $100/hour in USA! Click Here

Q95. How to access data in Azure SQL Database?

Data access in SQL Database is similar to how you access data in SQL Server. It is based on the Tabular Data Stream (TDS) over secure socket layer (SSL). There are many ways to access data in the SQL Database from your application. You can use client libraries such as ADO.Net or ODBC.

In a typical on-premise scenario, the application and the database reside in the same data center. In a typical Cloud scenario, both application and SQL Database reside in the cloud. A variation is when the application is residing in on-premise and the database is in the cloud. Data transfer in all the cases happen based on the TDS protocol. Let us consider the two scenarios in greater detail.

azure sql database data access

In the first scenario, the application resides on-premise and the database resides in Windows Azure SQL Database. As shown in Fig:-5.6, Application uses client libraries such as ADO.Net or ODBC to access the database in Azure SQL Database. This option is useful when you want to leverage high availability and scaling, SQL Database offers. When you move your database to the Cloud, the functionality of the SQL Server database will not change except for some changes in Transact-SQL and login management. It is important to consider the network latency which you may experience between SQL Database and the application which is running on-premise.

In the second scenario, application is hosted in Azure and database also resides in Azure SQL Database. As shown in Figure, Application uses the same client libraries (as in the first scenario) to access the database in Azure SQL Database. Hosting your application in Azure boosts the performance of the application because network latency is minimized.
  • Prev Question
  • Next Question

See More Questions and Answers on - Azure SQL Server

  • Two models of using SQL Server in the cloud
  • Choose between SQL Server in vm and sql database
  • Create and configure SQL database server in the cloud
  • How to configure the SQL database firewall
  • How to connect SQL database instance with SQL Server management studio
  • How to connect to a SQL database with ado.net
  • Build a Azure application that works with SQL database
  • Connect to Azure sql database using the ado.net entity framework

Back to Master List of 100+ Questions and Answers

People also viewed: cover image of book develop erp software using asp core and deploy to Azure Create your own ERP Software using ASP Core>>
cover image of azure cloud book Create your own Azure SOM Software>>
cover image of asp.net book Create your own ERP Software using ASP .Net and SQL>>
cover image of foundation database programming book Create your own Accounting Software using C# >>
cover image of entity framework book Create your own SOM using Entity Framework MVC >>

  • SITEMAP
  • Terms of use
  • Testimonials

Back to top

Copyright © 2018 - All Rights Reserved - VKInfotek.com