Connect to a local database c#

Question

What is the correct syntax of Sqlconnection to connect to a local database? I think it’s something like this!!

    SqlConnection liga = new SqlConnection(@"Data Source=(LocalDB)\v11.0;
                      AttachDbFilename=|DataDirectory|\BaseDeDados.mdf;
                      Integrated Security=True;
                      Connect Timeout=30");

Answer 1

Use this way, is the most recommended using keyword using.

var connectionString = @"Data Source=(LocalDB)\v11.0;
                      AttachDbFilename=|DataDirectory|\BaseDeDados.mdf;
                      Integrated Security=True;
                      Connect Timeout=30";

using (SqlConnection con = new SqlConnection(connectionString))
{
    con.Open();

    using (SqlCommand command = new SqlCommand("SELECT * FROM Table", con))
    using (SqlDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            // Leitura do seu Reader
        }
    }
}