LinqToSql Tutorial SQL Server Provider

string connectionString = "your connection string";

using (var db = new CustomerDbDataContext(connectionString))
{
    var customers = db.Customers.ToList();

    foreach (var customer in customers)
    {
        Console.WriteLine(customer.FirstName + ", " + customer.LastName);
    }
}