LINQ 로 Like 검색하기

StartsWith

View.Customers = from c in db.Customers
                            where c.ContactName.StartsWith("c")
                             orderby c.CompanyName
                            select c;

실제 찍히는 쿼리는?

exec sp_executesql N'SELECT [t0].[CustomerID],...
FROM [dbo].[Customers] AS [t0]
WHERE [t0].[ContactName] LIKE @p0  ORDER BY [t0].[CompanyName]', 'N'@p0 nvarchar(2)',@p0=N'c%'