Insert Statements

Inserting data is very simple and straightforward

await conn.InsertAsync(new Dog{
    Name="Popol", 
    BirthDate = new DateTime(1918,09,13), 
    Weight=2
});

Update Statements

Update a single row (based on PrimaryKey)

To update a record based on the specified Primary Key attribute. Note that Composite primary keys are supported.

// Update Dogs SET Breed = dog.Breed, Name = dog.Name ...  WHERE Id  = dog.Id
await conn.UpdateAsync(dog);

It is also possible to update only some columns

// Update Dogs Set Breed = dog.Breed, Name = dog.Name WHERE Id = dog.Id
await conn.UpdateAsync(dog, x => new {x.Breed, x.Name} );

Update multiple rows

// UPDATE Dogs SET Breed = null
await conn.UpdateAllAsync<Dog>(new {Breed = null});

// UPDATE Dogs SET Breed = 'A' WHERE Name = "Popol'
await conn.UpdateAllAsync<Dog>(new {Breed = 'A'}, x => x.Name = 'Popol');

// Update Dogs SET Breed = dog.Breed, Name = dog.Name WHERE Weight > 3
await conn.UpdateAllAsync<Dog>(dog, x => x.Weight > 3, x => new {x.Breed, x.Name} );

Delete Statements

Delete a single row (based on PrimaryKey)

To delete a record based on the specified Primary Key attribute. Note that Composite primary keys are supported.

// DELETE FROM DOGS WHERE Id = dog.Id
await conn.DeleteAsync(dog);

Delete multiple rows

// DELETE FROM DOGS WHERE Weight >= 2
await conn.DeleteAllAsync(x => x.Weight >= 2);

SimpleStack - Querying Data