Create a multi user windows application

Question

1.00/5 (1 vote)

See more:

Hello guys,
First of all I would like to thank you all for helping each other, and specially helping me to get my answers.

I am going to develop a windows application that serves many users by sharing the database between users.
One of the application functions is to swipe items between two users, so the first user check (on the application installed on his pc) for specific item once he find it, he will order the item, a notification should appear on the owner Screen to tell him that someone need this item, then he can do accept ot reject.
The question is how to create such service that stay listening for requests as long as the PC ON.
I use C#, WPF application, sqlite for now ( i should use sql server in order to share data?).
Thanks

What I have tried:

I didn’t try anything for now, i am waiting for suggestions

Posted 12-Feb-18 6:08am

Member 13199484

Updated 12-Feb-18 8:52am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Maciej Los · Accepted Answer · 2018-02-12T06:21:00

Solution 1

Yes, you can use SQL server database to share data and detect data changes to push notification for specific user. See:
SqlDependency Class (System.Data.SqlClient)[^]
Detecting Changes with SqlDependency | Microsoft Docs[^]
Using SqlDependency for data change events[^]

Good luck!

Posted 12-Feb-18 6:21am

Maciej Los

RickZeeland · Accepted Answer · 2018-02-12T08:52:00

Solution 2

As SQL Server is not the easiest database to install and manage, I would recommend using PostgreSQL instead, here is an introduction: Using PostgreSQL in your C# (.NET) application (An introduction)[^]
Talking about notifications to other users, here is an CodeProject article (take note Maciej :)) about it with example code (sadly not WPF) A PostgreSQL Notification Example[^]

Posted 12-Feb-18 8:52am

RickZeeland

Updated 12-Feb-18 9:07am

v2

Comments

Maciej Los 12-Feb-18 15:02pm

True. SQL server is NOT pretty straightforward...
Note, that OP requirement is to notify user about changes in a database. I'd add this link: Notify events from PostgreSQL to external listeners to complete your answer. ;)

RickZeeland 12-Feb-18 15:09pm

Updated the answer, at your service :)

Maciej Los 12-Feb-18 15:15pm

Upvoted!

RickZeeland 12-Feb-18 15:29pm

Thanks, we Polish ? (sort of) people should support each other :)

Maciej Los 12-Feb-18 15:51pm

Yes, i'm a Pole. Are you? On a site of your profile i see: Netherlands.
My logic is: no matter of nationality we need to support each other. In other words: we are children of World ;)
[EDIT]
Check LinkedIn ;)

RickZeeland 12-Feb-18 16:10pm

No, just joking, but I have some Polish friends, and as you probably noticed the author of the PostgreSQL article, Adrian Pasik, is Polish too ...

Maciej Los 12-Feb-18 16:32pm

Really? Interesting...