一步一步学Linq to sql(四)：查询句法

var in操作 = from c in ctx.Customers
 
                    where new string[] { "Brandenburg", "Cowes", "Stavern" }.Contains(c.City)
 
                    select c;

select * from Customers where City in('Brandenburg', 'Cowes', 'Stavern')

var innerjoin = from p in ctx.Products 

                        join c in ctx.Categories 

                        on p.CategoryID equals c.CategoryID
 
                        select p.ProductName;

SELECT [t0].ProductName
 
FROM [dbo].[Products] AS [t0]
 
INNER JOIN [dbo].[Categories] AS [t1] ON [t0].[CategoryID] = ([t1].[CategoryID])

var 过滤相同项 = (from c in ctx.Customers orderby c.Country select c.Country).Distinct(); 

SELECT DISTINCT [t0].[Country]
 
FROM [dbo].[Customers] AS [t0]