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; }
}

using (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.

Also checkout the JabbR room if you have a question. Here is the revision history.

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
9. Simple LINQ Queries v2+
10. Version column support
11. IDatabase interface
12. Sql Templating

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