Add to one context and update another context

Question

In here I add some data to database using EF code.When i add using one context it's working.But I need to update another table(another context) using ProductId(productId avaialble in iOdr object.

Here is my code

public int AddorUpdateSalesOrder(ref InvoiceHD iOdr)
{
    try
    {
        if (iOdr.InvoiceId != null)
        {
           //context.Entry(iOdr).State = EntityState.Modified;
           context.InvoiceHDs.Add(iOdr);
           //Here I need to update Product context 
           //using ProductId(it's available in iOdr).
           //If ProductId is 1 then I need to 
           //update product tables ProductQuantity coloumn with new value
        }
        else
        {
            context.InvoiceHDs.Add(iOdr);
        }
    }
    catch (Exception ex)
    {
        string msg = ex.Message;
    }
    return context.SaveChanges();
}

I have no idea how to do second context.could you please someone give me help for this. thanks

Joey Green · Accepted Answer · 2014-10-27 17:36:45Z

1

If I am reading this correctly then you just need to create a new instance of your other context, get back the record you need to update, update that record and SaveChanges on that context.

answered Oct 27, 2014 at 17:36

Joey Green

3,1183 gold badges20 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add to one context and update another context

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related