using System.Data.SqlClient; public async Task GetDataAsync() { using(var connection = new SqlConnection("Data Source=(local);Integrated Security=True;Initial Catalog=MyDB")) { await connection.OpenAsync(); using(var command = new SqlCommand("SELECT * FROM Customers", connection)) { using(var reader = await command.ExecuteReaderAsync()) { while (await reader.ReadAsync()) { Console.WriteLine("{0}\t{1}\t{2}", reader.GetInt32(0), reader.GetString(1), reader.GetString(2)); } } } } }
using System.Data.SqlClient; public async Task InsertDataAsync(string firstName, string lastName) { using (var connection = new SqlConnection("Data Source=(local);Integrated Security=True;Initial Catalog=MyDB")) { await connection.OpenAsync(); using (var command = new SqlCommand("INSERT INTO Customers (FirstName, LastName) VALUES (@FirstName, @LastName)", connection)) { command.Parameters.AddWithValue("@FirstName", firstName); command.Parameters.AddWithValue("@LastName", lastName); await command.ExecuteNonQueryAsync(); } } }This code inserts data into a database using a parameterized SQL statement. The SqlConnection class is used to establish a connection to the database, and the ExecuteNonQueryAsync method is used to execute the INSERT statement asynchronously. The package library for these code examples is likely to be the Microsoft .NET Framework, as System.Data.SqlClient is a component of the .NET Framework.