.NETѧϰÊÖ¼ÇÖ®£ºlinq to SQL(¶þ)

ÔÚVisual Studio 2008 ÖÐʹÓÃO/RÉè¼ÆÆ÷£º
µãÌí¼ÓÏîÄ¿£¬Ñ¡Ôñ´´½¨Linq to SQLÏîÄ¿£¬Ê¹Ó÷þÎñÆ÷×ÊÔ´¹ÜÀíÆ÷Á¬½ÓNorthwindÊý¾Ý¿â£¬½«CustomersºÍOrdersÁ½¸ö±íÍϵ½Éè¼Æ½çÃæÉÏ£¬ÏµÍ³»á×Ô¶¯´´½¨app.configºÍNorthwid.designer.cs,Ç°ÕßÊÇÅäÖÃÁ¬½ÓÊý¾Ý¿âµÄÁ¬½Ó×Ö´®£»ºóÕß»áÉú³ÉÒ»¸ö¼Ì³Ð×ÔDataContextµÄÀࣺNorthwindDataContext¡£
ʹÓÃlinqµ÷³öÊý¾Ý£º
static void Main(string[] args)
{
   NorthwindDataContext dc= new NorthwindDataContext();
   dc.Log=Console.Out;
   var query=from c in dc.Customers
             join o in dc.Orders on c.CustomerID equals o.CustomerID
             orderby c.CustomerID
             select new {
             c.CustomeriD,c.CompanyName,c.Country,o.OrderID,o.OrderDate};
   foreach(var item in query)
   {
        Console.WriteLine(item.CustomerID+"|"+item.CompanyName
           +"|"+item.Country+"|"+item.OrderID
           +"|"+item.OrderDate);
   }
}
ʹÓô洢¹ý³Ì£º
½«´æ´¢¹ý³ÌÍϵ½O/RÉè¼ÆÆ÷µÄÓÒ²àÇøÓò¡£
static void Main(string[] args)
{
   NorthwindDataContext dc= new NorthwindDataContext();
   ISingleResult<Ten_Most_Expensive_ProductsResult> result=
      dc.Ten_Most_Expensive_Products();
   foreach(Ten_Most_Expensive_ProductsResult item in result)
   {
        Console.WriteLine(item.TenMostExpensiveProducts+"|"+
           item.UnitPrice);
   }
}