華閱文章網linq 里面怎么用in比如有這個sql語句寫成linq怎么寫 如果以及not in怎么
select TOP 4*from Examine where ExamineLevel not in(select LinkLevel from Link where LinkClubId==3) --not in 把where條件改成不等于3就好啦and ExamineTypeId not in(select LinkExamineTypeId from Link where LinkClubId==3 ) --not in 把where條件改成不等于3就好啦and ExamineId not in( SELECT TOP (4*0) ExamineId FROM Examine )。
linq里面有沒有類似sql 的in（)的功能
例子：
-- 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<string> names = new List<string>();
*("Anderson");
*("Johnson");
List<Person> list = (from p in *le<Person>() where *ns(*me) select p).ToList();
}
*中用linq語句的寫登錄語句
Linq 怎么些 in 和 not in 呢
SQL語句：select * fron tablea where type in ('A','B')
Linq:
string name = "type";
string[] customerID_Set =
new string[] { "A","B" };
model = *(n=>customerID_*ns(name));
實際執行時， N'@p__linq__0 nvarchar(max) ',@p__linq__0=N'type',
@p__linq__0 IN (N''001'',N''002''),
@p__linq__0 ='type',
這樣是查詢不了的。需要變成
type IN (N''001'',N''002'')
