mikebeaton

var db = new MightyOrm(connectionString);
using (var connection = db.OpenConnection())
{
  using (var trans = conn.BeginTransaction())
  {
    var customer = db.Insert(CustomerInfo, connection);
    OrderInfo.CustomerID = customer.CustomerID;
    db.Insert(OrderInfo, connection);
    trans.Commit();
  }

mikebeaton

var results = db.ExecuteWithParams("begin open :p_rc for select * from emp where deptno = 10; end;",
  outParams: new { p_rc = new Cursor() },
  // shared connection (Oracle) or transaction (PostgreSQL) required to share cursors
  connection: conn);
db.ExecuteAsProcedure("cursor_in_out.process_cursor",
  inParams: new { p_cursor = results.p_rc },
  connection: conn);

mikebeaton

var db = new MightyOrm(connectionString);
var now = DateTime.Now;
using (var multiple = db.ExecuteMultipleFromProcedure("PurchaseReport",
  inParams: new { StartDate = now.AddMonths(6), EndDate = now })
{
  multiple.NextResultSet();
  foreach (var summary in multiple.CurrentResultSet.ResultsAs<PurchaseReportSummary>())
  {
    Console.WriteLine($"Total Sales for Report Period: ${summary.Total}");
  }

mikebeaton

[DatabaseTable("films")]
public class Film
{
  [DatabaseColumn("film_id")]
  public int FilmID;
  
  [DatabaseColumn("film_title")]
  public int Title;
}

mikebeaton

var db = new MightyOrm<Film>(connectionString, primaryKeys: "FilmID");
var films = db.All();
foreach (Film film in films)
{
  Console.WriteLine($"{film.Title}: {film.Description}");
}

mikebeaton

var result = db.ExecuteProcedure("my_add_proc", inParams: new { a = 1, b = 2}, outParams: new { c = (int?)null });
Console.WriteLine(result.c); // 3

mikebeaton

var db = new MightyOrm(connectionString, "Film", "FilmID");

var film = db.Single(47);
film.Description = "This is a better description";
db.Save(film);

var films = db.All(new { Director = "Spielberg" });
foreach (var film in films) Console.WriteLine(film.Title);

mikebeaton

var films = new MightyOrm<Film>(connectionString);

var film = films.New(new {
    Title = "Star Wars",
    Description = "A long time ago..."
});

mikebeaton

db.Insert(new Film("Star Wars", "A long time ago…."));

mikebeaton

public class Film
{
    // the primary key
    public int Id;
    
    public string Title;
    
    public string Description;
    
    // DB column has default of the current date-time