Binding two App to the same database

Question

1.00/5 (1 vote)

See more:

I am new to WPF and data binding. I have a database table called Tag(id, name, value), I want to bind two application to this table, the first one has a (turn on/off) button which has binding to Tag.value, the second application has a lamp with two state (on and off) which again has binding to Tag.value. what is the best way and tools to do this task so when I click the turn on button on the first App it will directly change the lamp status at the second App. Thank in Advanced

Posted 7-Apr-14 6:12am

bshanwar

Updated 7-Apr-14 6:25am

Richard C Bishop

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 7-Apr-14 14:41pm

Not clear what is your concern. Sharing a database by few different applications (this way communicating through using some shared data) is just the commonplace.
—SA

bshanwar 7-Apr-14 14:52pm

The problem that any change in the database from one application should directly appear in the second one, so should I check the database every 100 ms or there is a solution using data binding.

Sergey Alexandrovich Kryukov 7-Apr-14 15:03pm

Yes, this is the pain: you have to poll a database in one application. By the way, can the two application be on different machines? If they are always on the same one (rare case, I understand), the problem is easy — mentioning that just in case.
—SA

bshanwar 7-Apr-14 15:06pm

usually one of them should run on a server, other applications are client (web, mobile, or PC)

Sergey Alexandrovich Kryukov 7-Apr-14 15:09pm

All right. I suggested one interesting schema for you. It's important feature is: it is safeguarded against difficult situations when you get another timer tick when your handler invoked in the previous tick is not yet complete... Please see Solution 1.
—SA

1 solution

Add a Solution

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

Sergey Alexandrovich Kryukov · Accepted Answer · 2014-04-07T10:04:00

Solution 1

Please see my comments to the question. This is one of the solutions: Polling Database with Timer[^].

—SA

Posted 7-Apr-14 10:04am

Sergey Alexandrovich Kryukov

Binding two App to the same database

1 solution

Solution 1

Add your solution here

Preview 0

Binding two App to the same database

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us