static void Main(string[] args)
{
using (var customerModel = new CustomersDataContext())
{
var customer = customerModel.Customers.AsNoTracking().FirstOrDefault();
}
using (var orderModel = new OrdersDataContext())
{
var customer = orderModel.Customers.AsNoTracking().FirstOrDefault();
}
using (var shippingModel = new ShippingDataContext())
{
var customer = shippingModel.Customers.AsNoTracking().FirstOrDefault();
}
using (var customModel = new MyCustomDataContext())
{
var customer = customModel.Customers.AsNoTracking().FirstOrDefault();
}
//using (var customerOrdersModel = new CustomerDbEntities())
//{
// var customer = customerOrdersModel.Customers.AsNoTracking().FirstOrDefault();
//}
//using (var ordersDbModel = new OrdersDbEntities())
//{
// var customer = ordersDbModel.Customers.AsNoTracking().FirstOrDefault();
//}
}
public async Task ContextIsValid()
{
DbContextOptions <CustomersDataContext> options = new DbContextOptionsBuilder <CustomersDataContext>()
.UseSqlServer(@"Server=.;Database=Customers;Trusted_Connection=True")
.Options;
CustomersDataContext sut = new CustomersDataContext(options);
Customer customer = await sut.Customers.FirstOrDefaultAsync();
}
public static void DeleteCustomer(int CustID)
{
var dataContext = new CustomersDataContext();
var customer = from m in dataContext.Customers
where m.id == CustID
select m;
dataContext.Customers.DeleteAllOnSubmit(customer);
dataContext.SubmitChanges();
}
