您好，我正在嘗試按 ID 檢索特定部門。這是我的代碼public void GetDeptId(int _DeptID){var dept = dbContext.tblDepartments .Select(d => new Department { DepartmentID = d.DepartmentID, DepartmentName = d.DepartmentName }).Where(d => d.DepartmentID == _DeptID);}如何根據(jù) _DeptID 過(guò)濾結(jié)果集？即使記錄存在，這也不會(huì)返回任何記錄。
3 回答
慕桂英3389331
TA貢獻(xiàn)2036條經(jīng)驗(yàn) 獲得超8個(gè)贊
您需要 Select 子句嗎？如果你只需要檢索一個(gè)部門，你可以這樣做：
public void GetDeptId(int _DeptID){
var depts = dbContext.tblDepartments
.Where(d => d.DepartmentID == _DeptID);}或者，如果它只是一個(gè)，這將是有意義的：
public void GetDeptId(int _DeptID){
var dept = dbContext.tblDepartments
.First(d => d.DepartmentID == _DeptID);}
MYYA
TA貢獻(xiàn)1868條經(jīng)驗(yàn) 獲得超4個(gè)贊
做這樣的事情：
public ICollection<Department> GetDeptId(int _DeptID)
{
var dept = dbContext.tblDepartments
.Select(d => new Department
{
DepartmentID = e.DepartmentID,
DepartmentName = e.DepartmentName
}).Where(c => c.DepartmentID == _DeptID).ToList();
return dept;
}
至尊寶的傳說(shuō)
TA貢獻(xiàn)1789條經(jīng)驗(yàn) 獲得超10個(gè)贊
請(qǐng)?jiān)囋囘@個(gè)。
var dept = dbContext.tblDepartments.Where(d => d.DepartmentID == _DeptID)
.Select(d => new Department
{
DepartmentID = d.DepartmentID,
DepartmentName = d.DepartmentName
});
}
- 3 回答
- 0 關(guān)注
- 120 瀏覽
添加回答
舉報(bào)
0/150
提交
取消