This chapter contains these samples:

• ConnectionSamples (opening and closing connections, connection information, transactions)
• CommandSamples (ExecuteNonQuery, ExecuteScalar, ExecuteReader, call stored procedure)
• AsyncSamples (use async ADO.NET methods)
• TransactionSamples (execute commands within an explicit transaction)
• SystemTransactionssamples (using System.Transactions, requires .NET Core 2.1)

The database that is used with these samples is Books. This database is available as a SQL Server backup file, and as a SQL script. Check the CreateDatabase folder for these files.

To build and run the .NET Core samples, please install one of these tools:

• Visual Studio 2017 Update 7 with the .NET Core workload
• Visual Studio for Mac
• Visual Studio Code

Please download and install the tools from .NET Core downloads.

Please download a preview of the .NET Core 2.1 SDK here: .NET Core CLI.

For code comments and issues please check Professional C#'s GitHub Repository

Please check my blog csharp.christiannagel.com for additional information for topics covered in the book.

Thank you!