Install-Package PetaPoco
var db = new Database("connectionStringName");
var results = db.Query("SELECT * FROM MyTable");
var newObj = new MyObject { Name = "John", Age = 25 }; db.Insert(newObj);
var existingObj = db.SingleOrDefault("WHERE Id = @0", 1); existingObj.Name = "Bob"; db.Update(existingObj);
db.DeleteIn conclusion, PetaPoco is a powerful and flexible database ORM that provides developers with a simple and easy-to-use interface for interacting with their databases. It is available as a nuget package library and supports a wide range of databases. The examples provided above demonstrate just a few of the ways in which PetaPoco can be used to simplify database programming.("WHERE Id = @0", 1);