var db = new PetaPoco.Database("connectionString"); var employee = db.Single("SELECT * FROM Employees WHERE EmployeeId = @0", 123);
var db = new PetaPoco.Database("connectionString"); var employee = db.SingleIn this example, we again create a new PetaPoco Database object with the connection string. We then call the Single method to retrieve a single Employee object from the Employees table where the EmployeeId column equals 123. The second parameter specifies the name of the table to retrieve the row from. The PetaPoco.Database.Single method is part of the PetaPoco package library, which can be installed via NuGet in Visual Studio or downloaded from the PetaPoco GitHub repository.("Employees", "EmployeeId = @0", 123);