Skip to Content
Migrating Applications to the Cloud with Azure
book

Migrating Applications to the Cloud with Azure

by Sjoukje Zaal, Amit Malik, Sander Rossel, Jason Marston, Mohamed Waly, Stefano Demiliani
December 2019
Intermediate to advanced content levelIntermediate to advanced
494 pages
11h 41m
English
Packt Publishing
Content preview from Migrating Applications to the Cloud with Azure

Connecting using ADO.NET

Let's make a connection and print our data using ADO.NET. Create a new .NET Core console application using Visual Studio 2017. In .NET Core, it's necessary to install the System.Data.SqlClient package using NuGet. This package contains the necessary classes, such as SqlConnection and SqlCommand, which have been around since the very first version of .NET:

using System;using System.Data;using System.Data.SqlClient;namespace AzureSqlConnectionConsole{    internal class Program    {        private static void Main(string[] args)        {            using (SqlConnection connection = new SqlConnection("Server=tcp:[your server].database.windows.net,1433;" +                "Initial Catalog=migrationdb;Persist Security Info=False;" + "User ID=[your username];Password=[your ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Migrating Applications to the Cloud

Migrating Applications to the Cloud

Steve Swoyer
Microsoft Azure: Planning, Deploying, and Managing the Cloud

Microsoft Azure: Planning, Deploying, and Managing the Cloud

Julian Soh, Marshall Copeland, Anthony Puca, Micheleen Harris

Publisher Resources

ISBN: 9781839217470Supplemental Content