static void Main() { // Prepare var examples = new Examples(); examples.CreateTable(); // Create int id; if (Bill.GetCount() < 1) { id = examples.Create(); Console.WriteLine("Bill created with Id: {0}", id); } else { id = Bill.GetAll().First().Id; Console.WriteLine("Bill already exists with Id: {0}", id); } // Retrieve var bills = examples.Retrieve().ToList(); Console.WriteLine("Bills in table:"); bills.ForEach(x => Console.WriteLine("{0}\t{1}\t{2}", x.Id, x.Name, x.Date.ToShortDateString())); // Update examples.Update(id, "Bill new name"); // Retrieve by Id var bill = examples.Retrieve(id); Console.WriteLine("Bill name is: {0}", bill.Name); // Delete examples.Delete(id); // Migrate examples.MigrateToLast(); // Drop table new SQLiteDatabase().ExecuteQuery(string.Concat("DROP TABLE ", Bill.TableName)); // Wait Console.ReadKey(); }
static void Main() { // Prepare var examples = new Examples(); examples.CreateTable(); // Create int id; if (Bill.GetCount() < 1) { id = examples.Create(); Console.WriteLine("Bill created with Id: {0}", id); } else { id = Bill.GetAll().First().Id; Console.WriteLine("Bill already exists with Id: {0}", id); } // Retrieve var bills = examples.Retrieve().ToList(); Console.WriteLine("Bills in table:"); bills.ForEach(x => Console.WriteLine("{0}\t{1}\t{2}", x.Id, x.Name, x.Date.ToShortDateString())); // Update examples.Update(id, "Bill new name"); // Retrieve by Id var bill = examples.Retrieve(id); Console.WriteLine("Bill name is: {0}", bill.Name); // Delete examples.Delete(id); // Migrate examples.MigrateToLast(); // Drop table new SQLiteDatabase().ExecuteQuery(string.Concat("DROP TABLE ", Bill.TableName)); // Wait Console.ReadKey(); }