C# 3.0 入門系列（十一）：Like 基礎——Contains/StartsWith/EndsWith 與 SqlMethods.Like 對應關係

三大字串方法對應 LIKE 模式

LINQ to SQL 將字串實例方法轉譯為 LIKE：

程式碼範例與轉譯 SQL

Contains

var q = (from c in db.Customers
         where c.CustomerID.Contains("ROUT")
         select c).ToList();

WHERE [t0].[CustomerID] LIKE @p0  -- @p0 = '%ROUT%'

EndsWith

var q = (from c in db.Customers
         where c.CustomerID.EndsWith("ISSA")
         select c).ToList();

WHERE [t0].[CustomerID] LIKE @p0  -- @p0 = '%ISSA'

StartsWith

var q = (from c in db.Customers
         where c.CustomerID.StartsWith("ARO")
         select c).ToList();

WHERE [t0].[CustomerID] LIKE @p0  -- @p0 = 'ARO%'

SqlMethods.Like 手動指定模式

當需求超出三大方法（如中間通配、多段通配）時，改用 SqlMethods.Like：

var q = (from c in db.Customers
         where SqlMethods.Like(c.CustomerID, "%ROUT%")
         select c).ToList();

var q = (from c in db.Customers
         where SqlMethods.Like(c.CustomerID, "%ISSA")
         select c).ToList();

此時由開發者自行撰寫完整 LIKE 模式字串，彈性最大。