Example of connecting to Sql Server using async, await and tasks

async_database.cs

async void Main()
{
	var cnn = new SqlConnection("Data Source=ERPDBUAT;Initial Catalog=Enterprise_Misc; Integrated Security=true");
	cnn.Open();
	
	var cmd = new SqlCommand("SELECT * FROM ShopService.DivisionRules WHERE DivCode = 'MHL001'", cnn);
	await cmd.ExecuteReaderAsync().ContinueWith(async rdr => {
		await rdr.Result.ReadAsync().ContinueWith(ok => {
			rdr.Result.GetBoolean(rdr.Result.GetOrdinal("IsMobileEnabled")).Dump();
			rdr.Result.GetBoolean(rdr.Result.GetOrdinal("IsWebEnabled")).Dump();
			rdr.Result.GetBoolean(rdr.Result.GetOrdinal("IsManualAddressEnabled")).Dump();
			rdr.Result.GetBoolean(rdr.Result.GetOrdinal("ShouldValidateCompanyNameField")).Dump();
		});	
	});

	"hello world".Dump(); //linqpad
}