One - Many

Micron generates relationship methods for related models based on their foreign keys.

Customer - orders one to many example:

 MicronDbContext micron = new MicronDbContext();

 var customer = micron.GetRecord<Customer>(1);

  var orders = customer.GetOrders(); //gets orders for customer 1

  //loop all items
   foreach (var order in orders)
    {
      Console.WriteLine(order.OrderID);
    }

Filtering the collection using SQL

 MicronDbContext micron = new MicronDbContext();

 var customer = micron.GetRecord<Customer>(1);

 var orders = customer.GetOrders("OrderDate = '1996-07-04'"); //gets orders for customer 1 for date 1996-07-04

 //loop all items
 foreach (var order in orders)
 {
   Console.WriteLine(order.OrderID);
 }

Checking if customer has orders.

MicronDbContext micron = new MicronDbContext();

 var customer = micron.GetRecord<Customer>(1);

 //check if has orders
 if (customer.HasOrders())
 {
    Console.WriteLine("Cusstomer has orders");
 }
 else
 {
    Console.WriteLine("Cusstomer has no orders");
 }

Using For method:

  MicronDbContext micron = new MicronDbContext();

  var customer = micron.GetRecord<Customer>(1);
  
  var orders = micron.GetRecords<Order>().For(customer); ////gets orders for customer 1

  //loop all items
  foreach (var order in orders)
  {
     Console.WriteLine(order.OrderID);
  }