您好，我正在嘗試按 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 過濾結(jié)果集？即使記錄存在，這也不會返回任何記錄。
3 回答
慕桂英3389331
TA貢獻2036條經(jīng)驗 獲得超8個贊
您需要 Select 子句嗎？如果你只需要檢索一個部門，你可以這樣做：
public void GetDeptId(int _DeptID){
var depts = dbContext.tblDepartments
.Where(d => d.DepartmentID == _DeptID);}或者，如果它只是一個，這將是有意義的：
public void GetDeptId(int _DeptID){
var dept = dbContext.tblDepartments
.First(d => d.DepartmentID == _DeptID);}
MYYA
TA貢獻1868條經(jīng)驗 獲得超4個贊
做這樣的事情：
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;
}
至尊寶的傳說
TA貢獻1789條經(jīng)驗 獲得超10個贊
請試試這個。
var dept = dbContext.tblDepartments.Where(d => d.DepartmentID == _DeptID)
.Select(d => new Department
{
DepartmentID = d.DepartmentID,
DepartmentName = d.DepartmentName
});
}
- 3 回答
- 0 關(guān)注
- 113 瀏覽
添加回答
舉報
0/150
提交
取消