how to create new table with CRUD for blazor?

[TheDevTwister]

i am learning and saw sample but can you please help me how to create new table in db for blazor like booking? and also how to make CRUD pages and methods?

[mythz]

Here's the source code for the blazor-wasm template.

It uses OrmLite (https://docs.servicestack.net/ormlite/) to create the tables which it does in: MyApp/Configure.Db.cs

if (db.CreateTableIfNotExists<Booking>())
{
    db.CreateBooking("First Booking!", RoomType.Queen, 10, 100, "[email protected]");
    db.CreateBooking("Booking 2", RoomType.Double, 12, 120, "[email protected]");
    db.CreateBooking("Booking the 3rd", RoomType.Suite, 13, 130, "[email protected]");
}

The Create/Edit Bookings pages are located at: MyApp.Client/Pages/BookingsCrud

They create/edit Bookings using only the AutoQuery CRUD APIs defined in: MyApp.ServiceModel/Bookings.cs

AutoQuery and AutoQuery CRUD is ServiceStack's solution for creating CRUD APIs with just the Request DTO definition, all defined in Bookings.cs

TalentBlazor is a new App (deployed to https://talent.locode.dev) which exclusively uses AutoQuery for its CRUD APIs whose source code is located at:

https://github.com/NetCoreApps/TalentBlazor