QuickDBS.WebDB

WebDB example

WebDB uses the browsers LocalStorage to perform CRUD operations from client's Blazor WebAssembly project using similar methods as available in other QuickDBS ORM libraries such as SQLServer, MySQL or SQLite.

var db = new QuickDBS.WebDB("MyProject", InstanceOfJSRuntime);

We will use the following Person class example for demonstrating the use of WebDB.

public class Person
{
    public Int64 Id { get; set; }
    public string Name { get; set; }
    public double Income { get; set; }
    public DateTime DateOfBirth { get; set; }
}

Create a Person record in the Person collection. The result will be the last insert Id of the collection which will be unique.

var id = await db.Create<Person>(new Person {
  Name = "Rahul",
  Income = 5000,
  DateOfBirth = new DateTime(2000, 01, 01)
});

Get the person record having Id = 1 from the Person collection.

var person = await db.GetById<Person>(1);
person.Name = "Rahul Hadgal";
person.Income = 10000;

Update the income for person selected in the above example, from 5000 to 10000 and change name to Full Name.

var result = await db.UpdateById<Person>(person);

Get all records from Person collection

var people = await db.GetAll<Person>();

Delete a person by Id = 1 from the Person collection.

var result = await db.DeleteById<Person>(1);