EF中使用Contains方法

第一种情况

var db=new ECEntities();	
var list=new []{"8","9"};	
var result=from a in db.Products where list.Contains(a.SKU) select a;	
result.Dump();

生成的sql:

SELECT     
[Extent1].[LastModifiedTerminal] AS [LastModifiedTerminal], 
[Extent1].[LianCoinFullUse] AS [LianCoinFullUse]
FROM [dbo].[Products] AS [Extent1]
WHERE [Extent1].[SKU] IN (N'8', N'9')

第二种情况

var db=new ECEntities();
var result=from a in db.Products where a.SKU.Contains("8") select a;
result.Dump();		

生成的sql:

SELECT    
[Extent1].[LianCoinFullUse] AS [LianCoinFullUse]
FROM [dbo].[Products] AS [Extent1]
WHERE [Extent1].[SKU] LIKE N'%8%'