Get changes to entity after update in database

Question

I do this to save new invoince in my Invoices database table:

                // insert invoice into EDM
                edmx.AddToInvoices(newinvoice);
                // save EDM changes to datastore
                edmx.SaveChanges();

I have a trigger on one of the columns that gets computed dynamically by the database. What is the 1) easiest way to get that value out of the database immediatelly after it changes, 2) What is the fastest way?

Thanks

Answer 1

Since the Entity Framework can't know anything about the trigger, you'd have to reload the entity with a new query. I strongly recommend finding a different solution, if possible. Triggers can be evil.

Answer 2

You can either call Refresh:

MyEntities.Refresh(RefreshMode.StoreWins, someEntity);

...or configure the column in SSDL as store-generated if you never set it on the client.