解決“ObjectContext實(shí)例已被釋放,不能再用于需要連接的操作我正在嘗試植入一個(gè)GridView使用EntityFrameworkm,但每次收到以下錯(cuò)誤時(shí):“對(duì)象‘Cosis_DAL.MemberLoan’上的屬性訪問(wèn)器‘LoanProduct’拋出了以下異常:ObjectContext實(shí)例已被釋放,不能再用于需要連接的操作?!蔽业拇a是:public List<MemberLoan> GetAllMembersForLoan(string keyword){
using (CosisEntities db = new CosisEntities())
{
IQueryable<MemberLoan> query = db.MemberLoans.OrderByDescending(m => m.LoanDate);
if (!string.IsNullOrEmpty(keyword))
{
keyword = keyword.ToLower();
query = query.Where(m =>
m.LoanProviderCode.Contains(keyword)
|| m.MemNo.Contains(keyword)
|| (!string.IsNullOrEmpty(m.LoanProduct.LoanProductName) && m.LoanProduct.LoanProductName.ToLower().Contains(keyword))
|| m.Membership.MemName.Contains(keyword)
|| m.GeneralMasterInformation.Description.Contains(keyword)
);
}
return query.ToList();
}}protected void btnSearch_Click(object sender, ImageClickEventArgs e){
string keyword = txtKeyword.Text.ToLower();
LoanController c = new LoanController();
List<COSIS_DAL.MemberLoan> list = new List<COSIS_DAL.MemberLoan>();
list = c.GetAllMembersForLoan(keyword);
if (list.Count <= 0)
{
lblMsg.Text = "No Records Found";
GridView1.DataSourceID = null;
GridView1.DataSource = null;
GridView1.DataBind();
}
else
{
lblMsg.Text = "";
GridView1.DataSourceID = null;
GridView1.DataSource = list;
GridView1.DataBind();
}}錯(cuò)誤是提到了LoanProductName列的Gridview..提到:我正在使用C#,ASP.NET,SQLServer 2008作為后端DB。我對(duì)實(shí)體框架非常陌生。我不明白我為什么要犯這個(gè)錯(cuò)誤。有人能幫我嗎?
- 3 回答
- 0 關(guān)注
- 2043 瀏覽
添加回答
舉報(bào)
0/150
提交
取消