EASY Custom database SETUP with Umbraco 12+

[@KevinMullarkey]

Need a 'Database First' tutorial. I would have thought a lot of people using Umbraco for the first time would already have their own company production db that they would want to hook into in addition to the cms db?

[@AndyBoot]

Thanks for another great video Jon! Been looking for ways to streamline the creation and modification of tables for use within Konstrukt. Thx to the native EF support within v12 this should make the process a heck of a lot easier. #H5YR!

[@DiegoPetra]

Hello, great video! I would like to know why in HttpPost (api controller), when doing “SaveChangesAsync()” i have this errorr: “Sqlite error 6: the database table is locked “. How can i resolve this problem? Thanks

[@jondjones]

SQL lite is a file on a file server, you can still bump into locking issues like this. Use SQL server instead

[@LiamDilley]

Jon, Kentico has a tables builder UI in the admin so you can build custom tables (Which build the SQL) then provide and easy API to write and read to those. With this do you think a Package for Umbraco to do the same thing is doable?

[@jondjones]

Yes, possible but you would need to think about your database architecture. you need to create a table that would allow dynamic tables and rows to be created.

[@hunabku5349]

Umbraco ft blazor?

[@angelsv]

Hello, maybe an out topic question but the video to participate in the Umbraco training prize has been taking down, is that no longer happening?

[@jondjones]

The winner is being picked now and should get an email soon