Find / Search Records

Find customers from Nairobi city

Find using filters

 IEnumerable<Customer> customers = micron.GetRecords<Customer>("City='Nairobi'");
 foreach (var customer in customers)
 {
   Console.WriteLine(customer.CustomerName);
 }

Find using full SQL Query

 IEnumerable<Customer> customers = micron.GetRecords<Customer>("SELECT * FROM CUSTOMERS");
  foreach (var customer in customers)
  {
    Console.WriteLine(customer.CustomerName);
  }

Find using micron model object

 MicronDbContext micron = new MicronDbContext();
//gets all customers from Nairobi city
 var customers = micron.GetRecords<Customer>(
                      new Customer()
                      {
                        City = "Nairobi"
                       }
                     );

  foreach (var customer in customers)
   {
     Console.WriteLine(customer.CustomerName);
   }