Mega Code Archive

 

Categories / C# Tutorial / LINQ

 

Linq To Sql

using System; using System.Linq; using System.Data.Linq; using System.Data.Linq.Mapping;     [Table]     public class Customers     {         [Column]         public string customerId;         [Column]         public string companyName;         [Column]         public string city;         [Column]         public string country;     }     class LinqToSql     {         static void Main(string[] args)         {             string connString = @"server = .\sqlexpress;integrated security = true;database = northwind";             DataContext db = new DataContext(connString);             Table<Customers> customers = db.GetTable<Customers>();             var custs = from c in customers where c.country == "USA" orderby c.city select c;             foreach (var c in custs)                 Console.WriteLine(                    "{0}, {1}, {2}, {3}",                    c.customerId,                    c.companyName,                    c.city,                    c.country                 );         }     }