RedBeanPHP-inspired Hybrid-ORM for .NET.
PM> Install-Package LimeBean
// 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());| Database | .NET | .NET Core |
|---|---|---|
| SQLite | + | + |
| MySQL/MariaDB | + | + |
| PostgreSQL | + | + |
| SQL Server | + | + |