best ways to communicate with SQL server in dotnet wih code snippets

here are some code snippets demonstrating best practices for communicating with SQL Server in .NET: Establishing a connection to SQL Server using ADO.NET: using System.Data.SqlClient; // Connection string for SQL Server string connectionString = "...