What is the best way to publish real time data to the client website from database?

Question

0.00/5 (No votes)

See more:

, +

I have difficulty to pushing data in realtime to the client web from SQL server 2008!
perhaps if someone have experiance with this and can give me some tips what way is better and if there is an example of that will be appreciated!
I tried sveral way such as signalR! but I am not so expert in that!
so what I have is a table in database (SQL server 2008) and ASP.NET Web Application
I need to publish data in realtime to WEBForm in realtime
for example if the database get new record it Shows in the webform strat awayز

thanks you so much!

Posted 1-Jun-13 4:25am

Mo Kash

Add a Solution

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

Christian Graus · Accepted Answer · 2013-06-01T12:30:00

Solution 1

Websites are not realtime. The best you can do, is an AJAX call on a timer and refresh data regularly. The more often you make that call, the more work your DB has to do, regardless of if the data changes.

Posted 1-Jun-13 12:30pm

Christian Graus

Comments

Mo Kash 3-Jun-13 9:44am

Thanks Christian,
that is really helpfull, I was not sure to use signalR or ajax.
but I really appreciate if there is any example for dynamic form with ajax and asp.net 4.5

thanks

Dylan Morley 3-Jun-13 10:08am

With libraries such as Node JS and Signal R, not sure if I agree with that Christian. I guess you can say we can't do it consistently across all browsers yet (Signal R will have to fallback to polling if sockets not supported, nice article from Hanselman here http://www.hanselman.com/blog/YourUsersDontCareIfYouUseWebSockets.aspx)

Dylan Morley · Accepted Answer · 2013-06-03T03:58:00

You could achieve this with an SQL Dependency and Signal R. Whenever a new record is entered into the table, the dependency would trigger an event that you could catch and then forward on to your Signal R hub.

Have a go of Signal R, it's possibly the simpliest thing I've ever worked with to get up and running quickly!

Have a look at the documentation (you'll be able to get something running if you follow this)
https://github.com/SignalR/SignalR/wiki/QuickStart-Hubs[^]

...and an article from Scott
http://www.hanselman.com/blog/AsynchronousScalableWebApplicationsWithRealtimePersistentLongrunningConnectionsWithSignalR.aspx[^]

If you control all of the code (e.g. the code that is putting data into your SQL table) then you can intercept at this point and just send a message to your Hub and you wouldn't need an SQL Dependency.

Mo Kash · Accepted Answer · 2013-06-04T03:05:00

I solve the problem It is working now with signalR, thanks for all of you guys!
the problem was I didn't refer to the script library in the right way.

Thanks for all, and I would like to have example how I can do that with ajax only using timer, since I am not sure how much efficient signalR with lot's of clients and data! if anyone have more information about that plz send me a link!
/Mo

What is the best way to publish real time data to the client website from database?

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0