Hello Yogesh, your kind words are more than 100K likes my friend!. And I feel happy when my content is helpful for the people like you. Keep checking the channel to learn more. Thank you, my friend!!
Error is coming in hub. "Object reference not set to the instant of the object" can you please provide the solution. In my table record inserted every 1,2 second durations
First of all, thank you very much for the video. Thanks to you, I applied SignalR and SqlDependency in my project. Everything was working properly but then I changed my query method on the Hub side. The change I made on the table side was to use a relationship. Then it gave an error. This is the error in the console, Error: Connection disconnected with error 'Error: Server returned an error on close: Connection closed with an error.'. and Error: Server returned an error on close: Connection closed with an error. function InvokeTaskList() { connection.invoke("SendTaskList").catch(function (error) { console.log(error); return console.error(error.toString()); }) } This is where he catches the error.
I apologize for the delay, could you please share the code with me at skynetechs@gmail.com? It helps me to dig into the code and see what's happening inside.
Hey, many thanks for your kind words and I need more support from you to keep it growing. Glad my tutorial is helpful for you 😊 Keep visiting, keep learning
Yes, you update the data using queries or update data directly on table itself or you update it using stored procedures it doesn't matter. SqlTableDependency triggers if there is a change in the table data.
This is the best! I also want to know how to apply it in the crud method. insert, update. delete, etc I'd appreciate it if you could at least give me a reference link. Your video is very helpful for studying! Thank you!
Hey, thanks for your words. In the video itself you can see the crud operations and it reflects in the UI. If you insert/update/delete data in database, you will see those changes are reflected in the UI. Please let me know if you need anything more.
i have a string variable in object but it has number behind, for example : public string price1; when i use it in bindtogrid function in DashBoard.js i cant use object.price1, object.price without number 1 is usable. is there any way to use object.price1.
thk ,the best! I have some problem. When running project. Why data in query table on some column is null. But! When stop project data in column back to normal is not null
Hello there, thanks for the comment. I definitely try to help you on your issue. Could you please share the code with skynetechs@gmail.com so that I can take a look and please clearly explain the problem, it helps me to get it quickly.
Brother I have an issue, so when I public my project on server it gives an error : failed to connect to the websocket/ Negotiations something like this
failed to complete negotiation with the server: error: : status code '404' either this is not a signalr endpoint or there is a proxy blocking the connection. failed to start the connection: error: websocket failed to connect. the connection could not be found on the server, either the endpoint may not be a signalr endpoint, the connection id is not present on the server, or there is a proxy blocking websockets. if you have multiple servers check that sticky sessions are enabled.
Hi every time i am running an sqltabledependency and signalr project i get this error: System.DllNotFoundException: 'Unable to load DLL 'sni.dll' or one of its dependencies: The specified module could not be found
Hey, you are always welcome to give suggestions, and i definitely try to make a video on that. But I've few in pipeline now, will definitely consider your suggestion for sure. I need more suggestions, please keep me posted, thank you - Skynet
I really liked this this is absolutely good tutorial i faced some difficulties but i will solve and complete it. Can you show us to add these codes to free dashboard templates ( bootstrap templates) For example AdminLTE 3.
Hey, thank you and I'm glad it helps someone out there! And sure I'll try to help you as per your requirement. Could you please drop an email to skynetechs@gmail.com
Isit possible for create CRUD function and table dependency for same table in same project? Because I have facing some issues.. when I trying to use CRUD function to change the data that have subscribe for table dependency the complier will shown me an error, say that table id have already be target by the other connection
Another question I have about signalR and Table Dependency is (I just started learning it today), if I have a web application where I want to have notifications or updates for a specific user who is logged into my system, how would I handle that? Because from the tutorials I've watched, it triggers the sql "notification" from any action that happens in that table. I still can't get my head around on how to deliver only the rows that are directed to a specific user.
Hey Fernando, this is an interesting question. And I'll definitely clear your question soon. Please keep on checking for my replies here. I'll prepare a tutorial for this. Thanks for questioning friend 😊
hello Fernando! I've another tutorial just released in the channel for your question (to get personal notifications using Signal R). I suggest you to go and watch it th-cam.com/video/-5LltuHw2q8/w-d-xo.html
Awesome video. A video without a voice can be such useful, I didn't think before. Refactoring the code makes your video complete. Great. Is it possible to wrap all the SubscribeSaleTableDependency , SubscribeCustomerTableDependency , SubscribeProducrTableDependency to one generic class ?
@@skynetfordotnet i also encounter an error in my sqltabledependency middleware. It took me 2days to resolve the problem. Im glad i found the problem and fixed it :D
Hello friend, I have an error in the following method: private void TableDependency_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs e) { if (e.ChangeType != TableDependency.SqlClient.Base.Enums.ChangeType.None) { dashboardHub.SendProducts(); } } (edited) It tells me that sqlclient does not exist in tabledependency but in the parameter its recognize it and in the condition no I would appreciate your help , thanks for the tutorial !!
hey @Jetveloper, thanks for writing your question. Did you add SqlTableDependency package from NuGet? If you still face the issue, can you share the code so that I can check it and let you know. Thank you
Hello and thanks for your mesmerizing video I have a question Will this operation be reversed? That is, we add the information inside the UI and store it in the database (I know it can probably be done, I just want to be sure, because I really need it) exactly with the same codes
Hello Parsa. First of all thanks for the comments! Secondly, storing information into database on changing the UI is very common and it is achievable. If you still feel your requirement is complicated than I assume, you can write to skynetechs@gmail.com
@@skynetfordotnet Thanks for the reply, right, I wanted to be sure because this is the first time I am using SignalR and I have no experience with it. Your video helped me a lot. Thank you, have a good day.
Hey Belal, thanks for your words. There is a tutorial for the same in Entity Framework here th-cam.com/video/-5LltuHw2q8/w-d-xo.html Please take a look, keep visiting the channel 😉
Al probar la conexión de mi proyecto no funciona.. Sera porque uso puerto no seguro? En su caso al momento de ejecutar su proyecto usa certificado valido! Como hizo eso?
Antes que nada, gracias por escribir. Lo siento, no pude entender la pregunta correctamente. La conexión no funciona, ¿significa que no puede conectarse a la base de datos? Si tienes más consultas puedes escribir a skynetechs@gmail.com
I have added a new table to databse, when i add or chnage that table data, those are not changing in screen, is there any thing to do in SQL databse or table
When using SignalR with sql Table Dependency hosting application. stop signalR connection after 5 or 10 minutes when minimize the browser or inactive. after 5 or 10 minutes later when refresh the browser then not work. How to solve this issue.
I'm new to repositories. I do all of my database queries in the controller and use entity framwork core. How would i pass an Id from the controller through the repository? Would i call the repository from the controller and pass the id parameter through the called method of the repository? for example, public IActionResult Customers(String id){ Repository rep = new Repository(); rep.GetCustomers(id); return View(); }
@@skynetfordotnet yea it’s what I thought lol. I’m the SignalR hub I’m pulling a new instance of my repository. So it doesn’t matter what I write in the controller. Do you know how to use the route id with SignalR. I have a where clause that only displays records with the matching id in the url
I'm sorry, I'm not sure about your question. Can you try to elaborate it please? If possible you can write to skynetechs@gmail.com in detail. Will discuss over there.
One of the best videos I have used. Thank you!
Thank you very much!
Thank you very much for this video impressed by the attention to detail and easy to follow. Please do more. Be glad to participate in the Patreon.
Thank you so much for your kind words. Thanks alot.
Thank you so much. A big question mark about my project has been eliminated. Perfect solution!...
Thank you!!
100k likes is still less than what you have teach us. Thanks for uploading. Keep sharing.
Hello Yogesh, your kind words are more than 100K likes my friend!. And I feel happy when my content is helpful for the people like you. Keep checking the channel to learn more.
Thank you, my friend!!
Error is coming in hub. "Object reference not set to the instant of the object" can you please provide the solution. In my table record inserted every 1,2 second durations
Hi Yogesh, can you please elaborate the issue? Or you can write briefly to skynetechs@gmail.com. I'll definitely try to help you out.
I was so confused about signalR how it works properly for real time updates. But i will do it now thanks let me watch and practice
I'm very happy to read your comments and I'm sure it will help you. Keep visiting!!
First of all, thank you very much for the video. Thanks to you, I applied SignalR and SqlDependency in my project. Everything was working properly but then I changed my query method on the Hub side. The change I made on the table side was to use a relationship. Then it gave an error. This is the error in the console,
Error: Connection disconnected with error 'Error: Server returned an error on close: Connection closed with an error.'.
and
Error: Server returned an error on close: Connection closed with an error.
function InvokeTaskList() {
connection.invoke("SendTaskList").catch(function (error) {
console.log(error);
return console.error(error.toString());
})
}
This is where he catches the error.
I apologize for the delay, could you please share the code with me at skynetechs@gmail.com? It helps me to dig into the code and see what's happening inside.
@@skynetfordotnet I sent mail. Thank you for your support.
Could you re-share the code please? The link you already shared has expired.
Hi, just to say that I cloned your code from Github and after setting up the necessary SQL Database I got this to work perfectly. Many thanks indeed.
Hey, many thanks for your kind words and I need more support from you to keep it growing. Glad my tutorial is helpful for you 😊
Keep visiting, keep learning
@@skynetfordotnet I suppose this same technique can be applied to queries and not just tables, right? That would be incredibly useful.
Yes, you update the data using queries or update data directly on table itself or you update it using stored procedures it doesn't matter. SqlTableDependency triggers if there is a change in the table data.
@@skynetfordotnet Fantastic, thanks for your help.
It gives me pleasure sir, keep checking Skynet 😉
This is impressive!! I'd like to learn more about this! Again Thank you so much
Hey Azim, thanks so much for your compliments!! Subscribe & keep checking the channel to learn more 😉
Hi. It is a nice vedeio, thanks for the sharing of the information.
Hey Steven, I'm happy to hear that it's helpful for you!! Thanks for writing
You are amazing my friend keep going MASHAALLAH 💘❤
Thank you very much brother for your kind wishes and I'm glad it's useful for you 😊👍
you are grate bro this is the second time that i watch it 💘
I feel happy that my tutorial was helping you and many thanks for your compliments brother 😊
Subscribed i wish u alos explain concepts by ur voice
Thank you very much for your suggestion. I will definitely plan for that.
What a beautiful work bro, you are the best!
hey, thanks man for your impressive words :-) , keep checking Skynet!!
Thanks for this amazing tutorial 🎉
Thanks for watching too 🙂
Excelente tutorial
Thanks my friend!! Check other tutorials too 😊
thanks for this tutorial
Thank you for your words!!
This is the best!
I also want to know how to apply it in the crud method.
insert, update. delete, etc
I'd appreciate it if you could at least give me a reference link.
Your video is very helpful for studying! Thank you!
Hey, thanks for your words. In the video itself you can see the crud operations and it reflects in the UI. If you insert/update/delete data in database, you will see those changes are reflected in the UI. Please let me know if you need anything more.
Love it
Muchas gracias....
Hola, me alegro que este tutorial te sea útil. Sigue visitando el canal para saber más
i have a string variable in object but it has number behind, for example : public string price1;
when i use it in bindtogrid function in DashBoard.js i cant use object.price1, object.price without number 1 is usable.
is there any way to use object.price1.
Hey there, yes we can use object.price1. I tested your scenario, we can use like that. If you still face issues, let me know.
thk ,the best!
I have some problem.
When running project. Why data in query table on some column is null. But! When stop project data in column back to normal is not null
Hello there, thanks for the comment. I definitely try to help you on your issue. Could you please share the code with skynetechs@gmail.com so that I can take a look and please clearly explain the problem, it helps me to get it quickly.
Thank.
Thanks brother ❤
You're most welcome 😊👍
Brother I have an issue, so when I public my project on server it gives an error : failed to connect to the websocket/ Negotiations something like this
failed to complete negotiation with the server: error: : status code '404' either this is not a signalr endpoint or there is a proxy blocking the connection.
failed to start the connection: error: websocket failed to connect. the connection could not be found on the server, either the endpoint may not be a signalr endpoint, the connection id is not present on the server, or there is a proxy blocking websockets. if you have multiple servers check that sticky sessions are enabled.
Your issue would be blocking the connection. Please check that your requests are allowed in the server. Your server might blocking the requests.
Hi every time i am running an sqltabledependency and signalr project i get this error: System.DllNotFoundException: 'Unable to load DLL 'sni.dll' or one of its dependencies: The specified module could not be found
Could I suggest for a future video:
.Net MAUI, Blazor, SignalR, API, Identity.
That would be truly awesome.
Hey, you are always welcome to give suggestions, and i definitely try to make a video on that. But I've few in pipeline now, will definitely consider your suggestion for sure.
I need more suggestions, please keep me posted, thank you
- Skynet
I really liked this this is absolutely good tutorial i faced some difficulties but i will solve and complete it. Can you show us to add these codes to free dashboard templates ( bootstrap templates) For example AdminLTE 3.
Hey, thank you and I'm glad it helps someone out there! And sure I'll try to help you as per your requirement. Could you please drop an email to skynetechs@gmail.com
Unfortunately, Sql Table Dependency has not been updated since 2020, so it can hardly be used now
cool man congrats
Hey thanks man for the words!!
Vielen Dank
Freut mich, suche weiter nach weiteren Inhalten!
Спасибо большое
эй, я рад, что урок полезен для вас, продолжайте проверять канал для получения дополнительной информации
Hi I followed the vid but my new table is not showing any data, please help
Sure, can you share the code to skynetechs@gmail.com?
can I track database table change in ef core by which i can send update grid?
I believe, yes. You can try that with ef core. If you face any difficulties, let me know. I'm open to discuss further on this.
Isit possible for create CRUD function and table dependency for same table in same project? Because I have facing some issues.. when I trying to use CRUD function to change the data that have subscribe for table dependency the complier will shown me an error, say that table id have already be target by the other connection
Yes, ofcourse we can do CRUD operations as well. Can you write to skynetechs@gmail.com with clear explanation on what you get?
@@skynetfordotnet OK!! Thank you so much!!!
Another question I have about signalR and Table Dependency is (I just started learning it today), if I have a web application where I want to have notifications or updates for a specific user who is logged into my system, how would I handle that? Because from the tutorials I've watched, it triggers the sql "notification" from any action that happens in that table. I still can't get my head around on how to deliver only the rows that are directed to a specific user.
Hey Fernando, this is an interesting question. And I'll definitely clear your question soon. Please keep on checking for my replies here. I'll prepare a tutorial for this. Thanks for questioning friend 😊
Thank you, appreciate your help!
hello Fernando! I've another tutorial just released in the channel for your question (to get personal notifications using Signal R). I suggest you to go and watch it th-cam.com/video/-5LltuHw2q8/w-d-xo.html
Awesome video. A video without a voice can be such useful, I didn't think before.
Refactoring the code makes your video complete. Great.
Is it possible to wrap all the SubscribeSaleTableDependency , SubscribeCustomerTableDependency , SubscribeProducrTableDependency to one generic class ?
Hey Ashan, really thanks for your appreciation and I'm much happy that it's helpful for you and many others!!
@@skynetfordotnet Can you please consider my question? Is it possible?
Good question, I'll try to refactor it and let you know, thanks for your suggestion friend!!
i got an error when adding my SignalR Hub and Table Dependency to Singleton. Ifollow all your steps. I dont know what i am missing :/
okay i get it now. I should not call directly my DB Context inside my Hub. it Solved by creating a repository
I'm glad the issue has been resolved.
@@skynetfordotnet i also encounter an error in my sqltabledependency middleware. It took me 2days to resolve the problem. Im glad i found the problem and fixed it :D
Thnak you very much,
I need to filter the products according to previous page selection, can you explain how to do this
Hey, thanks to you too. Could you elaborate your requirement in detail please? You can write to Skynetechs@gmail.com
Very cool content. Do you have Signalr+Blazor ?
Hey, thanks for your words. I'll make a tutorial on SignalR with Blazor. I'll update here, please keep checking
Hi when I update something in the table, data is not getting reflected
Probably you're missing something. Could you share the code with skynetechs@gmail.com, we will check and come back to you.
Increase Font size to min 130% on the editor please when recording
Sure, thanks for the suggestion 👍
Hello friend, I have an error in the following method:
private void TableDependency_OnChanged(object sender, TableDependency.SqlClient.Base.EventArgs.RecordChangedEventArgs e)
{
if (e.ChangeType != TableDependency.SqlClient.Base.Enums.ChangeType.None)
{
dashboardHub.SendProducts();
}
} (edited)
It tells me that sqlclient does not exist in tabledependency
but in the parameter its recognize it
and in the condition no
I would appreciate your help , thanks for the tutorial !!
hey @Jetveloper, thanks for writing your question.
Did you add SqlTableDependency package from NuGet?
If you still face the issue, can you share the code so that I can check it and let you know.
Thank you
Hello and thanks for your mesmerizing video
I have a question
Will this operation be reversed?
That is, we add the information inside the UI and store it in the database
(I know it can probably be done, I just want to be sure, because I really need it) exactly with the same codes
Hello Parsa. First of all thanks for the comments! Secondly, storing information into database on changing the UI is very common and it is achievable.
If you still feel your requirement is complicated than I assume, you can write to skynetechs@gmail.com
@@skynetfordotnet Thanks for the reply, right, I wanted to be sure because this is the first time I am using SignalR and I have no experience with it.
Your video helped me a lot. Thank you, have a good day.
thangs for viedo's > how i can used it in entity framwork
Hey Belal, thanks for your words.
There is a tutorial for the same in Entity Framework here th-cam.com/video/-5LltuHw2q8/w-d-xo.html
Please take a look, keep visiting the channel 😉
@@skynetfordotnet very thanks
@@skynetfordotnet
Thank you, sir, for your answer and your valuable time. I want the way with Windows applications and entity framwork c#
Thanks Belal, if you face any technical challenges feel free to reach Skynet. We will try to help you out, thank you!!
Al probar la conexión de mi proyecto no funciona.. Sera porque uso puerto no seguro?
En su caso al momento de ejecutar su proyecto usa certificado valido! Como hizo eso?
Antes que nada, gracias por escribir.
Lo siento, no pude entender la pregunta correctamente.
La conexión no funciona, ¿significa que no puede conectarse a la base de datos?
Si tienes más consultas puedes escribir a skynetechs@gmail.com
I have added a new table to databse, when i add or chnage that table data, those are not changing in screen, is there any thing to do in SQL databse or table
I need to check the code, could you share it with me (skynetechs@gmail.com) please?
When using SignalR with sql Table Dependency hosting application. stop signalR connection after 5 or 10 minutes when minimize the browser or inactive. after 5 or 10 minutes later when refresh the browser then not work.
How to solve this issue.
Hey Shabbir, thanks for bringing your question to us. We will definitely get back to you on this ASAP. Thank you.
I'm new to repositories. I do all of my database queries in the controller and use entity framwork core. How would i pass an Id from the controller through the repository? Would i call the repository from the controller and pass the id parameter through the called method of the repository? for example,
public IActionResult Customers(String id){
Repository rep = new Repository();
rep.GetCustomers(id);
return View();
}
Hi, basically it depends on your project architecture. Anyway, you can pass the parameters to repository from the controller.
@@skynetfordotnet I just tried it out, yea the way I’m thinking works. I just need to try it with SignalR, if it works then this video is too good😁
It should work for you 🙂 if it doesn't work please let me know, we will try together to make it work 😉
@@skynetfordotnet yea it’s what I thought lol. I’m the SignalR hub I’m pulling a new instance of my repository. So it doesn’t matter what I write in the controller. Do you know how to use the route id with SignalR. I have a where clause that only displays records with the matching id in the url
I'm sorry, I'm not sure about your question. Can you try to elaborate it please? If possible you can write to skynetechs@gmail.com in detail. Will discuss over there.
Any ideas how to use this with ef core? I can't find any tutorials on this.
Hey, I'll definitely find and let you know, thanks for your comments
I really appreciate it man!! Thanks for the quality content and being so helpful!
Hello, there is a tutorial in it's own channel Skynet on EF core with SQL Table Dependency
th-cam.com/video/-5LltuHw2q8/w-d-xo.html
Check this out
Thanks Raj, for adding information here!!
Hii,
Code & design is perfect working.
Give mi please C# Language code. 🙏
Hey thanks for writing, and the source code link is given in description. Please check.
Hello @@skynetfordotnet, I tried to find it but I couldn't find it. Please give me its link here. Thank You, Satyajeet.
Okay, here is the link
github.com/Skynet-Demos/SignalR-SqlTableDependency
Objetive include JQuery?
Yeah, jQuery is included in the project itself
sir please make advance chat application 1 to 1 private , 1 to many group chat please.
please please sir please please
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Yes, I have a plan to develop the chat application. Soon or later, I will build a chat application.
Hi I've sent you an email with my error. Hope you reply and help me out.
I'll check and respond ASAP, thanks for writing Skynet.
𝓅𝓇o𝓂o𝓈𝓂
Thanks man!
Hello i use sqltabledependency on my project same as u but i can’t use httpcontext.session method returned null to me. You know this error solution?
Hey, thanks for writing to Skynet.
Can you share your code snippet to skynetechs@gmail.com?