Last post Oct 01, 2015 06:17 PM by RDowdall
Sep 17, 2015 08:16 AM|RDowdall|LINK
Hello - I have an upcoming project where I have to display real-time numbers representing line and station productivity on a large screen TV. From reading and tutorials I've decided that SignalR would be perfect for this application. The problem I have run
into is that I have not found a tutorial that is comprehensive enough for me to get started.
If someone can point me to a well written example of a SQL based SignalR project I would appreciate it. The example project does not need any data entry capability, just the ability to push sql data derived from several tables to the client
I am in the process of learning MVC5 and am at the point where i have the basics down, an example project using MVC would be acceptable.
Thank-you in Advance.
Sep 17, 2015 10:15 PM|Fei Han - MSFT|LINK
Firstly, ASP.NET SignalR could make developing real-time web functionality easy, we could use it to implement real-time application.
Secondly, these SignalR tutorials will be helpful.
Sep 18, 2015 06:12 AM|Ruchira|LINK
Probably my below blog post will give you a jumpstart
Please 'Mark as Answer' if this post helps you
Sep 24, 2015 09:06 AM|RDowdall|LINK
I've got the begining stage of my project working. My next challange will be to display data using multiple queries. Can I use multiple queries in a single Hub or should I create a Hub for each query?
In the dependency_OnChange event it looks like different Hub Methods could be called if the database could tell you what changed. I can probably figure this out but I've had to set this project aside for a few days due to more urgent requests.
This is an interesting project.
My plan is SignalR--> SignalR in MVC5 -->SignalR in MVC5 Single Page Architecture. The goal is to display Real Time Data in a Slide Show Style on a Large Television.
Thanks for the response.
Oct 01, 2015 06:17 PM|RDowdall|LINK
In the notification hub I am having to pass multiple numbers to the client. 34 total. The source for these numbers will be 4 stored procedures. I've decided to use Linq to Sql to call the first stored procedure which returns 5 numbers. I've been searching
for information on how to handle the SqlDependency. In all the tutorials I have looked at the SqlDependecy relies on the SqlCommand Object, however in my case I am not using SqlCommand. Does anyone know of information, that would show me how to handle SqlDependency
in this case?
public void SendNotifications()
dbDataContext db = new dbDataContext();
var Line1 = db.sp_IndivBoxCount("1", "IBL");
var Line2 = db.sp_IndivBoxCount("2", "IBL");
var Line3 = db.sp_IndivBoxCount("3", "IBL");
var Line4 = db.sp_IndivBoxCount("4", "IBL");
var Line5 = db.sp_IndivBoxCount("5", "IBL");
SqlCommand command = null;
SqlDependency dependency = new SqlDependency(command);
OnChangeEventHandler dependency_OnChange = null;
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
IHubContext context = GlobalHost.ConnectionManager.GetHubContext<NotificationHub>();