Sample Scheduler CRUD SQL Server Data Source

[Julie]

Hello,

Does anyone have a link to a good sample of Blazor Scheduler CRUD with SQL Server as the data source. I don't care if it uses Entity Framework, Dapper, or anything else. I just want to find a good working example.

Thank you.

[Nevitha Ravi]

Hi Julie, 

Greetings from Syncfusion Support. 

You can refer the below UG and sample to perform CRUD actions in Blazor scheduler. 

https://blazor.syncfusion.com/documentation/scheduler/data-binding#performing-crud-using-entity-framework 

https://github.com/SyncfusionExamples/blazor-scheduler-crud  

Note: You need to change the path for accessing the database in the below link with the directory of your database. 

https://github.com/SyncfusionExamples/blazor-scheduler-crud/blob/master/Restful_Services/Models/ScheduleDataContext.cs#L24 

 

Please try the above sample and let us know if you need any further assistance. 

 

Regards, 

Nevitha 

[Julie]

Thank you. I have done all of this. My connection keeps closing so it can't load the data from my sql instance. Your documentation says nothing about this error.

[Nevitha Ravi]

Hi Julie, 

Thanks for your update. 

We suspect that you connection might be closed to due improper network, can you please check the below for this problem? 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2b4b7e27-5181-4cb7-b1d1-7e32c23c32e2/sql-server-connections-getting-closed?forum=sqldatabaseengine 

If you still face the problem, could you please share your scheduler related code snippets, image reference of the issue or replicate the issue in a sample if possible. 

Regards, 

Nevitha