linq里面有没有类似sql 的in()的功能

linq语句怎么实现类似sql语句的in功能,什么格式
2025-04-29 06:37:27
推荐回答(1个)
回答1:

例子: -- SQL --DECLARE @p1 NVarChar(8);
DECLARE @p0 NVarChar(7);

Select @p1 = 'Johnson';
Select @p0 = 'Anderson';

-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.21022.8
SELECT [t0].[Id], [t0].[FirstName], [t0].[LastName]
FROM [dbo].[Person] AS [t0]
WHERE [t0].[LastName] IN (@p0, @p1) -- LINQ -- using (DataContext dc = new DataContext("connectionstring"))
{
List names = new List();
names.Add("Anderson");
names.Add("Johnson");
List list = (from p in dc.GetTable() where names.Contains(p.LastName) select p).ToList();
}