# NPoco

**Repository Path**: yangdejiu/NPoco

## Basic Information

- **Project Name**: NPoco
- **Description**: Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco.This Fork adds OleDb support such as Excel,Access and so on.
- **Primary Language**: C#
- **License**: GPL-3.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2021-10-19
- **Last Updated**: 2022-05-21

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

This fork is based on NPoco 3.9.1([https://github.com/schotime/NPoco](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

```csharp
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](https://github.com/schotime/NPoco/wiki/Home) for more documentation.