NBean 2.1.0-beta-3

NBean is a fork of LimeBean with a couple of additional features, exclusively targeting NetStandard 2.0. It is a highly RedBeanPHP-inspired ORM for .NET which provides a simple and concise API for accessing ADO.NET data sources. It's an Hybrid-ORM ... halfway between a micro-ORM and plain old SQL.

Supported databases include:

• SQLite
• MySQL/MariaDB
• PostgreSQL
• SQL Server

Getting Started: Basic CRUD (Create/Read/Update/Delete)

For basic usage, NBean requires no configuration or table classes!

Take a look at some basic CRUD scenarios:

Create

// Create a Bean. 
// "Bean" means row, and "Dispense" makes an empty Bean for a table.
var bean = api.Dispense("book");

// Each bean has a "Kind". Kind is a synonym for "table name"
// You give a Bean its Kind when you Dispense it, or query the database
var kind = bean.GetKind();
Console.WriteLine(kind);

// Fill the new Bean with some data
bean["title"] = "Three Comrades";
bean["rating"] = 10;

// Store it
// Store() will Create or Update a record intelligently
var id = api.Store(bean);

// You can also use this shortcut and chain .Put() and .Store() to do this
var id2 = api.Dispense("book")
    .Put("title", "The Art Of War")
    .Put("rating", 10)
    .Store();

// Store also returns the Primary Key for the saved Bean, even for multi-column/compound keys
Console.WriteLine(id);
Console.WriteLine(id2);

Read and Update

// Load a Bean with a known ID
bean = api.Load("book", id);

// Make some edits
bean["release_date"] = new DateTime(2015, 7, 30);
bean["rating"] = 5;

// Update database
api.Store(bean);

Short version:

api.Load("book", id)                                  // <-- Load a Bean with a known ID
    .Put("release_date", new DateTime(2015, 7, 30))   // <-- make some edits
    .Put("rating", 5)
    .Store();                                         // <-- update database

Note: This version doesn't check for not found Book Bean

Delete

api.Trash(bean);

// or

api.Load("book", id).Trash();