Menu
I have a stored procedure that changes lots of data in the database. This stored procedure is called from the application that at the same time uses EF for data operations.
So I click a button, stored procedure is run at the database, data is changed and EF shows old data to the user.
Is there a way to force the DbContext or ObjectContext to refresh data from database? ObjectContext.Refresh() may be the solution but I do not want to call this method for every single table that may be changed. I want all the tables to be refreshed in one move.
I am using Entity Framework 5, targeting .NET 4.0
EDIT: Added data is available but modification on existing data is not reflected by EF. I see the newly added records but I cannot see the changes I made to existing records.
327
Detect Changes works by detecting the differences between the current property values of the entity and the original property values that are stored in a snapshot when the entity was queried or attached. The techniques shown in this topic apply equally to models created with Code First and the EF Designer.
AutoDetectChangesEnabled to false should disable change tracking requiring one to call DbContext. DetectChanges in order to identify changes to be sent to the database.
First you create an instance of MyEDM , add the list myList to the table MyTable , then call SaveChanges() to persist the changes to the database. It works how you want, the records get committed, but your program cannot do anything else until the commit finishes.
Because an open connection to the database consumes a valuable resource, the Entity Framework opens and closes the database connection only as needed. You can also explicitly open the connection. For more information, see Managing Connections and Transactions. Once in each application domain.
Your DbContext should be short-lived. Create it, run your query, and dispose it.
using (var context = new MyProject.DbContext()) { // run your query here } Don't keep your context around. That way you won't have any issues with old data.
125
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
