You can crate a Plain Old CLR Object to map the underlining database table w\/o the help of the LINQ-to-SQL designer. To represent a customer class, you need the following code. <\/p>\n
\nusing System;\nusing System.Collections.Generic;\nusing System.Linq;\nusing System.Data.Linq;\nusing System.Data.Linq.Mapping;\nusing System.Text;\n\nnamespace LinqToSql\n{\n [Table(Name=\"Customers\")]\n public class Customer\n {\n [Column]\n public string customerId {get; set;}\n [Column]\n public string companyName {get; set;}\n [Column]\n public string city {get; set;}\n [Column]\n public string country {get; set;}\n }\n\n class LinqToSql\n {\n static void Main(string[] args)\n {\n string connString = @\"Server=.SQLEXPRESS; \n Database=Northwind; Trusted_Connection=Yes\";\n DataContext db = new DataContext(connString);\n \n \/\/ crate typed table\n Table customers = db.GetTable(); \n \/\/query database\n var custs = from c in customers\n where c.country ==\"USA\"\n select c;\n \/\/display customers\n foreach (var cust in custs)\n {\n Console.WriteLine(\n \"{0} {1} {2} {3}\", \n cust.customerId, cust.companyName, cust.city, cust.country\n );\n }\n db = null;\n }\n }\n}\n\n<\/pre>\n","protected":false},"excerpt":{"rendered":"You can crate a Plain Old CLR Object to map the underlining database table w\/o the help of the LINQ-to-SQL designer. To represent a customer class, you need the following code. using System; using System.Collections.Generic; using System.Linq; using System.Data.Linq; using … Continue reading