static async Task TestRepo() { var repo = new ArticlesRepository("Articles"); // Example with Print Baked into the Object itself List <Articles> articles = new List <Articles>(); articles = (await repo.GetAllAsync()).ToList(); TestTool.PrintSuccess("Got {0} row from Articles\n", articles.Count()); articles.First().PrintKeys(); articles.ForEach(article => article.Print()); // var repoEmployees = new EmployeesRepository("Employees"); List <Employees> employees = (await repoEmployees.GetAllAsync()).ToList(); TestTool.PrintSuccess("Got {0} row from Employees\n", employees.Count()); Console.Write("{0}\t{1}\t{2}\t{3}\t{4}\n", "ID", "Name", "LastName", "Email", "Password"); employees.ForEach(employee => Console.Write("{0}\t{1}\t{2}\t{3}\t{4}\n", employee.ID, employee.Name, employee.LastName, employee.Email, new string('*', employee.Password.Length))); // var repoIngredients = new IngredientsRepository("Ingredients"); var ingredients = (await repoIngredients.GetAllAsync()).ToList(); TestTool.PrintSuccess("Got {0} row from Ingredients\n", employees.Count()); Console.Write("{0}\t{1}\t{2}\n", "ID", "Name", "Price"); ingredients.ForEach(ingredient => Console.Write("{0}\t{1}\t{2}\n", ingredient.ID, ingredient.Name, ingredient.Price)); // var repoOrders = new OrdersRepository("Orders"); List <Orders> orders = (await repoOrders.GetAllAsync()).ToList(); TestTool.PrintSuccess("Got {0} row from Orders\n", orders.Count()); Console.Write("{0}\t{1}\t{2}\t{3}\t{4}\n", "ID", "TimeCreated", "Orderstatus", "Price", "CustomerID"); orders.ForEach(order => Console.Write("{0}\t{1}\t{2}\t{3}\t{4}\n", order.ID, order.TimeCreated, order.Orderstatus, order.Price, order.CustomerID)); //Orders order = (await repoOrders.GetAsync(4)); //await repoOrders.UpdateAsync(new Orders() {ID = 12, Orderstatus = 0, Price = 124, CustomerID = 1 }); //await repoIngredients.InsertCustomIngredientsAsync(orders.First(), articles.First(), articles.First().Ingredients); //Orders order = orders.First() ; //List<Articles> tempArticles = articles.GetRange(0, 2); //await repoOrders.MakeOrderAsync(order, tempArticles); //List<Articles> orderListArticles = (await repo.GetAllAsync(order)).ToList(); //foreach (var item in orderListArticles) //{ // Console.WriteLine(item.Name + " " + item.Type); // foreach (var item2 in item.Ingredients) // { // Console.Write(item2.Name.Trim() + ", "); // } //} //articles[0].ID = 71; //await General.articlesRepo.UpdateAsync(articles[0]); }