Microsoft Azure Essentials Fundamentals of Azure Second Edition e-optimized 5x11 pdf

ADO.NET Database connection string 
Server=tcp:{your_db_server_name_here}.database.windows.net,1433;Database={your_db_name_here};User 
ID={your_username_here}@{your_db_server_name_here};Password={your_password_here};Encrypt=True;Tru
stServerCertificate=False;Connection Timeout=30; 
Note that the connection string sets the TrustServerCertificate property to False and the Encrypt 
property to True. This is to provide additional protection while accessing SQL Database over the 
Internet. Doing so helps thwart potential man-in the-middle attacks. SQL Database will force the 
connection to be encrypted regardless of the setting. 
When writing code against SQL Database, it is important to defend your code against transient errors. 
Transient errors are errors that are intermittent and likely will be resolved if the command is retried. 
These errors are more common with SQL Database than with databases accessed via a local area 
network (LAN). This is due to the inherently unreliable network that is the Internet and the fact that as 
a managed service, SQL Database might periodically undergo maintenance activities that could cause 
connections to drop temporarily. Applications should plan for and defend against transient errors by 
incorporating retry logic when creating connections or executing commands against SQL Database. 
Be sure to choose a retry strategy that provides sufficient time for the platform to attempt to recover 
from whatever caused the initial failure, does not saturate the platform with a rapid succession of retry 
attempts, and has a maximum number of retry attempts and/or retry duration. For example, an 
exponential back-off approach with a preset maximum number of attempts is often suitable—be sure 
to validate for your application scenario. 
For .NET applications using Entity Framework, Entity Framework 6 contains connection resiliency/retry 
logic that will detect transient errors from SQL Database and retry the command. For other .NET 
applications, Enterprise Library 5 and 6 (see 
http://msdn.microsoft.com/library/ff648951.aspx
) from 
Microsoft Patterns & Practices contain an application block called the Transient Fault Handling 
Application Block. This library can also be used to detect transient errors and retry commands. 
 
 

---

173 
CHAPTER 6  |    Databases