Managing Relational Data Using SQL Server

This chapter is about managing relational data stored in SQL Server, Azure SQL Database, or Azure SQL Edge. First, you will learn how to manage the data using native Transact-SQL statements. Next, you will learn how to manage data at a low level using ADO.NET libraries (Microsoft.Data.SqlClient). Finally, you will use Dapper to make it easier to work with entity models.

This chapter will cover the following topics:

• Understanding modern databases
• Managing data with Transact-SQL
• Managing SQL Server data with low-level APIs
• Managing SQL Server data with Dapper
• Cleaning up data resources