public static async void TestEFC()
{
using (SqliteDB db = new SqliteDB()) {
var loggerFactory = db.GetService <ILoggerFactory> ();
loggerFactory.AddProvider(new ConsoleLoggerProvider());
Console.WriteLine("Inserting a new Customer");
Console.WriteLine("Create new Customer");
Customer newCustomer = new Customer(
"sem fax",
"Carlos",
"Boss",
new Address("Qualquer parte da casa", "1234567", "Lisboa"),
"sem telefone"
);
db.Add(newCustomer);
db.SaveChanges();
Console.WriteLine("Show Customers");
List <Customer> customers = await db.Customers.ToListAsync();
foreach (Customer customer in customers)
{
Console.WriteLine(customer);
}
Console.WriteLine("Show Customers Ze Carlos");
List <Customer> qc = await db.Customers.Where(customer => customer.Name == "Ze Carlos").ToListAsync();
foreach (Customer customer in qc)
{
Console.WriteLine(customer);
}
}
}
public static void TestEFC()
{
using (SqliteDB db = new SqliteDB()) {
var customers = db.Customers;
foreach (Customer customer in customers)
{
Console.WriteLine(customer);
}
}
}