ADO.NET Entity Framework: ObjectContext.customers does not get the newly add new xustomer if not call SaveChanges

Question

We use ADO.NET Entity Framework4 and SQL server compact edition.

we notice after we add a new customer by using

ObjectContext.AddToCustomer(newCustomer);

if we do not call ObjectContext.SaveChanges() and call

ObjectContext.Customers will not get the newly added customer.

Since in our application, sometime we need to block ObjectContext.SaveChanges() during database backup,

we need find a way to allow ObjectContext.Customers to get the collection to include newly added customer even though we do not call Savechanges method.

Is there way to can achieve this? thx!

---

JaneC

Answer 1

Hi Jane,

You can use the ObjectStateManager to find the added customers:

ObjectContext.ObjectStateManager.GetObjectStateEntries(System.Data.EntityState.Added).Select(ose => ose.Entity).OfType<Customer>();

~Rowan

Answer 2

Hello Jane,

 I hope this might provide you some insight towards your solution

public void InsertCustomer(Customer customer)
{
  if (customer.Person == String.Empty)
  {
    customer.Person = RetrieveSalesPersonForCompany(customer.Name);
  }

  if ((customer.EntityState != EntityState.Detached))
  {
    this.ObjectContext.ObjectStateManager.ChangeObjectState(customer, EntityState.Added);
  }
  else
  {
    this.ObjectContext.Customers.AddObject(customer);
  }
}

Answer 3

Hi Pavan,

thanks for replying our question.

Does anyone know what is difference between ObjectContext.Customers.AddObject(customer) and ObjectContext.AddToCustomer(customer)?

thx!

 

 

 

---

JaneC

Answer 4

Hello Jane,

    Both are same  but

 

AddToCustomer(customer) is a strongly typed wrapper around Customers.AddObject(customer)

I would use AddToCustomer(customer) method , as it is strongly typed and gives you compile time type checking.

 

Hope this helps

 

 

Thanks

Pavan