Has anyone been able to use the kendo grid that will automatically update when something is changed in the database using signalr and Entity framework?
I have seen people using sqlDependency to do this but this doesn't work with entity framework?
I have seen people using sqlDependency to do this but this doesn't work with entity framework?
3 Answers, 1 is accepted
0
Hello Martin,
You can check the SignalR example project, which illustrates how similar behavior could be achieved.
Regards,
Alexander Popov
Telerik
You can check the SignalR example project, which illustrates how similar behavior could be achieved.
Regards,
Alexander Popov
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0
Pham
Top achievements
Rank 1
Rank 1
answered on 03 Jul 2019, 10:41 AM
Hi Martin,
I have sample problem. Have you any idea ?
(I need insert from other application, and I want change automatic, and I don't want sqlDependency because database is large).
Thanks.
0
Hi Pham,
The Kendo UI Grid can be bound to a SignalR data source. We have created a live demo which demonstrates how this could be achieved. It uses Hubs which transfer the data. More information could be found here:
https://demos.telerik.com/kendo-ui/grid/signalr
The implementation of the Hubs that this grid is using are public. The full implementation of the service could be found here:
https://github.com/telerik/kendo-ui-demos-service/blob/master/signalr-hubs/signalr-for-aspnet-core/Hubs/ProductHub.cs#L24-L46
In the current scenario the Hubs work with IEnumerable collections. In the current case those collections are derived from an SQL DataTable. However, according to your preference, you can obtain the collection without SQL. Therefore, you would not have any dependencies for the SQL.
Let me know in case additional questions arise.
Kind regards,
Tsvetomir
Progress Telerik
The Kendo UI Grid can be bound to a SignalR data source. We have created a live demo which demonstrates how this could be achieved. It uses Hubs which transfer the data. More information could be found here:
https://demos.telerik.com/kendo-ui/grid/signalr
The implementation of the Hubs that this grid is using are public. The full implementation of the service could be found here:
https://github.com/telerik/kendo-ui-demos-service/blob/master/signalr-hubs/signalr-for-aspnet-core/Hubs/ProductHub.cs#L24-L46
In the current scenario the Hubs work with IEnumerable collections. In the current case those collections are derived from an SQL DataTable. However, according to your preference, you can obtain the collection without SQL. Therefore, you would not have any dependencies for the SQL.
Let me know in case additional questions arise.
Kind regards,
Tsvetomir
Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.