var user = db.t_ST_User
.Where(_user => string.Compare(domain, _user.domainName, StringComparison.OrdinalIgnoreCase) == 0)
.Where(_user => string.Compare(samAccountName, _user.samAccountName, StringComparison.OrdinalIgnoreCase) == 0)
.Where(_user => _user.deleted == false)
.FirstOrDefault();上面的代碼給我以下錯誤:LINQ to Entities 不支持指定的類型成員“domainName”。僅支持初始值設定項、實體成員和實體導航屬性。但domainName實體是 的成員t_ST_User,不是嗎?代碼在遷移到新計算機之前可以正常工作,不確定是否相關。public static int GetUserId(string domainName){ int nonExistingUserId = 0; try { string message = ""; using (var db = new SurfaceTreatment.SurfaceTreatmentEntities()) { string domain = domainName.Split('\\')[0].Trim(); string samAccountName = domainName.Split('\\')[1].Trim(); var user = db.t_ST_User .Where(_user => string.Compare(domain, _user.domainName, StringComparison.OrdinalIgnoreCase) == 0) .Where(_user => string.Compare(samAccountName, _user.samAccountName, StringComparison.OrdinalIgnoreCase) == 0) .Where(_user => _user.deleted == false) .FirstOrDefault(); if (user == null) { message = "Failed to get user by domain name: " + domainName; LogHandler.LogDebug(logger, message); return nonExistingUserId; } else { return user.userId; } } } catch (Exception ex) { LogHandler.LogError(logger, ex); return nonExistingUserId; }}public partial class t_ST_User{ public int userId { get; set; } public string badgeNumber { get; set; } public string domainName { get; set; } public string samAccountName { get; set; } public string userName { get; set; } public string userRemark { get; set; } public System.DateTime createDate { get; set; } public int createBy { get; set; }}
- 1 回答
- 0 關注
- 163 瀏覽
添加回答
舉報
0/150
提交
取消