Skip to content

Latest commit

 

History

History
60 lines (47 loc) · 2.38 KB

sql-database-design-first-database-csharp.md

File metadata and controls

60 lines (47 loc) · 2.38 KB
title description services ms.service ms.subservice ms.custom ms.devlang ms.topic author ms.author ms.reviewer manager ms.date
Design your first Azure SQL database - C# | Microsoft Docs
Learn to design your first Azure SQL database and connect to it with a C# program using ADO.NET.
sql-database
sql-database
development
tutorial
MightyPen
genemi
carlrab
craigg-msft
11/01/2018

Tutorial: Design an Azure SQL database and connect with C# and ADO.NET

Azure SQL Database is a relational database-as-a service (DBaaS) in the Microsoft Cloud (Azure). In this tutorial, you learn how to use the Azure portal and ADO.NET with Visual Studio to:

[!div class="checklist"]

  • Create a database in the Azure portal
  • Set up a server-level firewall rule in the Azure portal
  • Connect to the database with ADO.NET and Visual Studio
  • Create tables with ADO.NET
  • Insert, update, and delete data with ADO.NET
  • Query data ADO.NET

If you don't have an Azure subscription, create a free account before you begin.

Prerequisites

An installation of Visual Studio Community 2017, Visual Studio Professional 2017, or Visual Studio Enterprise 2017.

[!INCLUDE sql-database-tutorial-portal-create-firewall-connection-1]

[!INCLUDE sql-database-csharp-adonet-create-query-2]

Next steps

In this tutorial, you learned basic database tasks such as create a database and tables, load and query data, and restore the database to a previous point in time. You learned how to:

[!div class="checklist"]

  • Create a database
  • Set up a firewall rule
  • Connect to the database with Visual Studio and C#
  • Create tables
  • Insert, update, and delete data
  • Query data

Advance to the next tutorial to learn about migrating your data.

[!div class="nextstepaction"] Migrate your SQL Server database to Azure SQL Database