Home

Welcome to the NPoco wiki! NPoco is a fork of PetaPoco with a handful of extra features.

Getting Started: Your first query

public class User 
{
    public int UserId { get;set; }
    public string Email { get;set; }
}

IDatabase db = new Database("connStringName");
List<User> users = db.Fetch<User>("select userId, email from users");

This works by mapping the column names to the property names on the User object. This is a case-insensitive match.
There is no mapping setup needed for this (query only) scenario.

Standard Features

1. Mapping
2. Query Single Object
3. Create Read Update Delete
4. Query List
5. Paging

Extras

1. Query onto an existing object
2. One-to-Many query helpers
3. Mapping to Nested Objects query helpers
4. Dictionary<string, object> and object[] queries for dynamic results
5. Change tracking for updates
6. Composite Primary Key support
7. Queries that returns Multiple Result Sets
8. [Fluent Mappings including Conventional based mappings](https://github.com/schotime/NPoco/wiki/Fluent Mappings including Conventional based)
9. Version column support
10. IDatabase interface
11. Sql Templating

Each of these features will be explained in their own page.