Question

Hi could you help me with this error?
Cannot access a disposed object. Object name: DataContext accessed after Dispose. .

页: 1

 private void InitializePage()
    {
        cbCategory.DataSource = stock.StockCategory.Get();

    }

缩略语

 public IEnumerable<StockCategory> Get()
    {
        using (leDataContext db = new leDataContext())
        {
            try
            {
                var r = from s in db.StockCategories
                        select s;
                return r;
            }
            catch (Exception ex)
            {
                Logger.Error(typeof(StockCategory), ex.ToString());
                throw;
            }

        }

    }

Answer 1

您重新编辑<代码>DataContext,但退回仍然取决于该编码的内容。

备选办法:

Don t dispose the DataContext. I know this sounds weird, but guidance from the LINQ to SQL team (well, Matt Warren) has indicated that in most cases (i.e. if you re not doing anything out of the ordinary) disposal is not required
Call ToList() inside the Get() method s using block.

请注意,仅用先质质的质询来表示疑问,是不合理的。 (如果这属于你自己的法典,那么即使隐含的<代码>Select(s => s)实际上也是有益的。)

我建议改变你的方法,以便:

public IList<StockCategory> GetAllStockCategories()
{
    using (leDataContext db = new leDataContext())
    {
        return db.StockCategories.ToList();
    }
}

Answer 2

由于电荷载到这里,在林克声明线上确实没有执行过盘问。当你接手时,或者在此时,当你对List说话时,就处决了。

如果执行,则必须在数据范围内......这里的情况并非如此。你们要么从Get方法中返回名单,要么加入造物。数据输入<代码>使用(leDataContext...)的范围。

友情链接