using System.Data.SqlClient; var connectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"; var connection = new SqlConnection(connectionString); connection.Open(); // Do some database operations here connection.Close();
using System.Data.SqlClient; var connectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;"; using var connection = new SqlConnection(connectionString); connection.Open(); // Do some database operations here // Connection will automatically close when out of using scopeThis example is similar to Example 1, but includes the use of a 'using' statement, which automatically disposes of the connection when it goes out of scope. Package library: System.Data.SqlClient