处理LINQPad datacontext

foreach() using() 在我的 foreach() ,所以每次循环时它都会创建一个新的表引用(我猜是dispose)。然而,我忘记了正确的方法,我似乎找不到任何有帮助的谷歌。

客户 桌子,所以我的 foreach() 通常是这样的:

foreach(var customer in listOfCustomerIds) {
    var sum = Customer
        .FirstOrDefault(x => x.Id == customer)
        .Jobs
        .Where(x => x.Deleted == null)
        .Where(x => x.CustomerJobRelations.Any())
        .Sum(x => x.CustomerJobRelations.Count());
}

foreach(var customer in listOfCustomerIds) {
    using(var customerTable = new TypedDataContext<Customer>()) {
        var sum = customerTable
            .FirstOrDefault(x => x.Id == customer)
            .Jobs
            .Where(x => x.Deleted == null)
            .Where(x => x.CustomerJobRelations.Any())
            .Sum(x => x.CustomerJobRelations.Count());
    }
}

语法是错误的,但我百分之百肯定他用的是TypedDataContext。然而,他是如何设置的,却被完全遗忘了。有人知道怎么做吗?