private static void WithLinqSqlClassesConvertToXml() { var db = new DataClassesConceptTestDataContext(); var xml = new XElement("CustomerClasss", from x in db.Customers select new XElement("CustomerClass", new XAttribute("CustomerId", x.CustomerId), new XAttribute("CustomerName", x.CustomerName), new XAttribute("City", x.City))); Console.WriteLine(xml); Console.ReadLine(); }
private static void WithLinqSqlClasses() { var db = new DataClassesConceptTestDataContext(); var results = from c in db.Customers where c.City.StartsWith("M") group c by c.City into g select new Result() { City = g.Key, Count = g.Count() }; db.Log = Console.Out; ObjectDumper.Write(results); }