using System.Data.Linq; using System.Configuration; using MyProject.Models; DataContext db = new DataContext(ConfigurationManager.ConnectionStrings["MyDbConnString"].ConnectionString); Tablecustomers = db.GetTable ();
using System.Linq; using MyProject.Models; var query = from c in db.Customers where c.City == "New York" select c; foreach (var c in query) { Console.WriteLine(c.Name); }Here, we define a LINQ query to retrieve all customers from the Customers table whose city is "New York". Then, we iterate through the result set and print out each customer's name. Package Library: System.Data.Linq (namespace) from System.Data.Linq.dll (assembly) is used for DataContext in C#.