Notify when database is changed

Question

0.00/5 (No votes)

See more:

, +

Hi every body,

I need to find a way to do something like what SqlDependency doing in my winform application.
I mean that i want to notified when the specified table is changed, so i can refresh my presentation layer with updated data.

I can not use sqldependency because of it's long list of limitations.

please help me...

Posted 15-Sep-13 22:35pm

M_Mogharrabi

Add a Solution

Comments

Maciej Los 16-Sep-13 5:03am

What kind of limitations?

M_Mogharrabi 16-Sep-13 5:18am

The main problem is with it's limitation on OUTER JOIN command.I have to use this command in a lot of my queries.

leonidasvijay 16-Sep-13 6:00am

why don't you use timer_tick event?

M_Mogharrabi 16-Sep-13 6:29am

Because i want to refresh my forms immediatly after the table is updated however Timer maybe has a delay.also my application should work on a local network with maybe many clients so Timer can busy the network!

4 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)

Rajesh Gelli · Answer 1 · 2013-09-16T01:59:00

Solution 2

You can use Timer to check for every frequent time...Place your table in session and get the latest...Compare the two and finalize your Presenatation layer

Posted 16-Sep-13 1:59am

Rajesh Gelli

Comments

M_Mogharrabi 17-Sep-13 1:53am

Hi Rajesh Gelli and Thanks.
See i have about 50 tables in my application that can update in run time and i want to notify immediatly when each of them is updated.
So do you think placing these 50 tables in session is correct?
Again do you think that comparing a table with it's previous session in every 1seconds(Timer interval) does not decrease the speed of application?

coded007 · Answer 2 · 2013-09-16T01:33:00

Solution 1

we can do through service brokers and with snap shots isolation. Please check below links for information

http://stackoverflow.com/questions/5288434/how-to-monitor-sql-server-table-changes-by-using-c[^]
http://msdn.microsoft.com/en-us/library/cc305322.aspx[^]

Posted 16-Sep-13 1:33am

coded007

Comments

Rajesh Gelli 16-Sep-13 7:59am

You can use Timer to check for every frequent time...Place your table in session and get the latest...Compare the two and finalize your Presenatation layer

Balamurugan1989 · Answer 3 · 2013-09-16T02:06:00

Solution 3

SqlCommand cmd = xxx
cmd.Notification = null;
SqlDependency dependency = new SqlDependency(cmd);
dependency.OnChange += OnChange;

Posted 16-Sep-13 2:06am

Balamurugan1989

Comments

M_Mogharrabi 17-Sep-13 1:31am

Thanks Balamurugan, but i think you did not read my question completely,I said in my question that "I can not use sqldependency because of it's long list of limitations"! I have used OUTER JOIN command in a lot of my queries while it is one of the Constraints of sqldependency.

Rakesh Meel · Answer 4 · 2013-09-16T02:10:00

Solution 4

visit here .....

http://www.dreamincode.net/forums/topic/156991-using-sqldependency-to-monitor-sql-database-changes/[^]

Posted 16-Sep-13 2:10am

Rakesh Meel

Comments

M_Mogharrabi 17-Sep-13 1:32am

Thanks Rakesh Meel, but i think you did not read my question completely,I said in my question that "I can not use sqldependency because of it's long list of limitations"! I have used OUTER JOIN command in a lot of my queries while it is one of the Constraints of sqldependency.