Ò»²½Ò»²½Ñ§Linq to sql£¨ËÄ£©£º²éѯ¾ä·¨

select
 
ÃèÊö£º²éѯ¹Ë¿ÍµÄ¹«Ë¾Ãû¡¢µØÖ·ÐÅÏ¢
²éѯ¾ä·¨£º
var ¹¹½¨ÄäÃûÀàÐÍ1 = from c in ctx.Customers
                      select new
                      {
                          ¹«Ë¾Ãû = c.CompanyName,
                          µØÖ· = c.Address
                      };
¶ÔÓ¦SQL£º
SELECT [t0].[CompanyName], [t0].[Address]
from [dbo].[Customers] AS [t0]      
 
ÃèÊö£º²éѯְԱµÄÐÕÃûºÍ¹ÍÓÃÄê·Ý
²éѯ¾ä·¨£º
var ¹¹½¨ÄäÃûÀàÐÍ2 = from emp in ctx.Employees
                      select new
                      {
                          ÐÕÃû = emp.LastName + emp.FirstName,
                          ¹ÍÓÃÄê = emp.HireDate.Value.Year
                      };
¶ÔÓ¦SQL£º
SELECT [t0