This fork is based on NPoco 3.9.1(https://github.com/schotime/NPoco) and supports OleDb such as Excel,Access and so on.Online Nuget package name is Joeries.NPoco.

NPoco

Welcome to the NPoco! NPoco is a fork of PetaPoco based on Schotime's branch 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.

Checkout the Wiki for more documentation.