Click here to Skip to main content
15,893,564 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
How to get the BindingSource to get the most current data in Entity framwork.
Posted

1 solution

The only way you can get that done automaticly is by creating a trigger which then calls some code you put together, which in turn tells your applications that a row were inserted/updated/deleted. But that's extremely messy and doesn't scale well.

What I personally like to dom in cases when I have a list that is often used and updated from different sources, is to place a refresh button so the user can force a refresh of the data. And I update the list when the user navigates to the view with the list, with some throttling, so the list is not refreshed 5 times in 10 seconds because the user works fast.

So in your case I suggest you query the database when the user clicks refresh or navigate to your view.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900