An extremely easy to use Micro-ORM supporting Sql Server, MySQL, PostgreSQL, Oracle, Sqlite, SqlCE.


Keywords
database, micro-orm, mvc, orm, sql, c-sharp, npoco, petapoco
License
Apache-2.0
Install
Install-Package NPoco -Version 6.0.0-preview4

Documentation

NPoco

NuGet

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.