Connecting to a SQL Database with ADO.NET

An application communicates with a SQL Database using the same tabular data stream (TDS) format used in communicating with Microsoft SQL Server. This simplifies the task of migrating from the Microsoft SQL Server to SQL Database, as an application need only change to the appropriate connection string.

Tip

Official documentation often talks about the simplicity to migrate an existing SQL Server database to a SQL Database one. However, there are some features that are not supported in Azure, as mentioned in the official documentation. The key point to understand is that if an existing feature relies on some server dependency, topology dependency, or filesystem dependency, it probably would not be supported. ...

Get Microsoft Azure Development Cookbook Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.