A simple example that shows the principle of opening late and closing early.

DatabaseExample.cs

public void TheWrongWay()
{
  var connection = new SqlConnection(...);
	
	connection.Open();

	DoSomethingTimeConsumingThatDoesNotUseTheDatabase();

	// execute query

	connection.Close();
}

public void TheRightWay()
{
	var connection = new SqlConnection(...);
	
	DoSomethingTimeConsumingThatDoesNotUseTheDatabase();
	
	connection.Open();

	// execute query

	connection.Close();
}