Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Microsoft Azure Development Cookbook Second Edition

You're reading from   Microsoft Azure Development Cookbook Second Edition Over 70 advanced recipes for developing scalable services with the Microsoft Azure platform

Arrow left icon
Product type Paperback
Published in Sep 2014
Publisher
ISBN-13 9781782170327
Length 422 pages
Edition 1st Edition
Tools
Concepts
Arrow right icon
Toc

Table of Contents (10) Chapters Close

Preface 1. Developing Cloud Services for Microsoft Azure FREE CHAPTER 2. Deploying Quickly with Azure Websites 3. Getting Storage with Blobs in Azure 4. Going Relational with the Azure SQL Database 5. Going NoSQL with Azure Tables 6. Messaging and Queues with the Storage and Service Bus 7. Managing Azure Resources with the Azure Management Libraries 8. Going In-memory with Azure Cache Index

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.

When a SQL Database server is provisioned, it is assigned a fully qualified DNS name of the SERVER_NAME.database.windows.net form. A database name must be provided when the SQL Database is created. SQL Database logins are created in precisely the same...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime