12416

Does Entity Framework + System.Data.SQLite provide a Database changed from outside listener / event?

Question:

Is there a way to get notified, when the database is newer than the DbContext of EF?

In my case I develop an application that can be installed on several computers. They use the same Database. Since these applications are supposed to run the whole day, chances are high that one is updating data and the other instance of the application is still holding old data in its DbContext.

Now I could implement some checking for new data each minute or so. Or checking for new data each time the user does some I input or comes back to the application. But isn't there an event based solutions available?

if this is important: My Database is SQLite and the ADO.NET provider is System.Data.SQLite (from the SQLite developers)

Answer1:

AFAIK SQLite has no "push notifications" mechanism, so this question really has nothing to do with EF. But to answer your question directly: No. If you were using SQLServer there is some stuff you can do with the SqlCacheDependency which is similar to what you're asking, but even that is not supported by the Entity Framework.

It's your responsibility to manage concurrency and update the data as needed.

Recommend

  • What is the better pratice: duplicate code or use goto statement? [closed]
  • How to create a for loop in R? [duplicate]
  • System.Data.SQLite BadImageFormatException with NHibernate, works finewhen standalone
  • stop image from moving when reaching the border of a container
  • How to restrict number of concurrent processes?
  • Excel not inserting leading zero
  • Why does the first run of “XCTestCase -measureBlock:” takes so much time?
  • Update SQL MS Access 2010
  • MySql - get days remaining
  • Get rendered html code in Backing Component from Composite Component
  • Returning this from a constructor function in JS
  • Is it safe to drop the -webkit vendor prefix from the css3 border-radius yet?
  • Telegram bot API - Inline bot getting Error 400 while trying to answer inline query
  • Are there any side effects from calling SQLAlchemy flush() within code?
  • Watson Conversation - Why is the ANYTHING ELSE node not chosen
  • Local Development, Apache vs Developer - file permissions
  • What is the use of a session store?
  • How to get the date of next specified day of week
  • Thread safety of a fluent like class using clone() and non final fields
  • How can the INSERT … ON CONFLICT (id) DO UPDATE… syntax be used with a sequence ID?
  • d3 v4 drag and drop with TypeScript
  • JQuery Internet Explorer and ajaxstop
  • Exception “firebase.functions() takes … no argument …” when specifying a region for a Cloud Function
  • Highlight one bar in a series in highcharts?
  • Java Scanner input dilemma. Automatically inputs without allowing user to type
  • Opengl-es onTouchEvents problem or a draw problem? [closed]
  • what is the difference between the asp.net mvc application and asp.net web application
  • Calling of Constructors in a Java
  • Matrix multiplication with MKL
  • PHP: When would you need the self:: keyword?
  • embed rChart in Markdown
  • Linking SubReports Without LinkChild/LinkMaster
  • Authorize attributes not working in MVC 4
  • Busy indicator not showing up in wpf window [duplicate]
  • How to get NHibernate ISession to cache entity not retrieved by primary key
  • Binding checkboxes to object values in AngularJs
  • How can I use `wmic` in a Windows PE script?
  • Unable to use reactive element in my shiny app
  • Python/Django TangoWithDjango Models and Databases
  • Net Present Value in Excel for Grouped Recurring CF