LimeBean

RedBeanPHP-inspired Hybrid-ORM for .NET.

Available on NuGet Gallery

PM> Install-Package LimeBean

Get started in 2 minutes:

// Make an ADO.Net connection and create a BeanAPI from it.
var connection = new DbConnection(connectionString);
connection.Open();
var api = new BeanApi(connection);

// Get a row from a known record ID
int bookId = 7;
Bean row = api.Load("books", bookId);
string bookTitle = row.Get<string>("title");
Console.WriteLine(bookTitle);

// Add a new row to the database
Bean newRow = api.Dispense("books");
newRow
    .Put("title", "Cloud Atlas")
    .Put("author", "David Mitchell");
var newBookId = api.Store(newRow);
Console.WriteLine("New book ID: " + newBookId.ToString());

Supported Frameworks and Databases

          | .NET | .NET Core 

--------------|------|----------- SQLite | + | + MySQL/MariaDB | + | + PostgreSQL | + | + SQL Server | + | +

Full Documentation

https://nick-lucas.github.io/LimeBean/