static void Main(string[] args)
{
var connectionString = ConfigurationManager.ConnectionStrings["AdventureWorks"].ConnectionString;
Product prod2 = null;
var repo = new DapperProductRepository(connectionString);
prod2 = new Product
{
Id = 1000,
Name = ""
};
if (prod2 != null)
{
prod2.Name = "update was successful";
prod2.Id = 1028;
repo.UpdateProduct(prod2);
}
prod2.Name = "Here is a new product!";
prod2.Id = 1005;
repo.InsertProduct(prod2);
repo.DeleteProduct(1028);
foreach (var prod in repo.GetProducts())
{
Console.WriteLine("Product Name: " + prod.Name);
}
foreach (var prod in repo.GetProductsAndReview())
{
if (prod2 == null)
{
prod2 = prod;
}
;
Console.WriteLine(prod.Name);
}
repo.GetProductsWithReview();
repo.GetProductsAndReview();
Console.WriteLine("\nThe Program has ended, press any key to exit...");
Console.ReadLine();
}
static void Main(string[] args)
{
var connectionString = ConfigurationManager.ConnectionStrings["AdventureWorks"].ConnectionString;
var connection = new MySqlConnection(connectionString);
var repo = new DapperProductRepository(connectionString);
Product product = null;
foreach (var prod in repo.GetProducts())
{
if (product == null)
{
product = prod;
}
Console.WriteLine("Product Name: " + prod.Name);
}
foreach (var rate in repo.GetProductsWithReview())
{
if (product == null)
{
product = rate;
}
Console.WriteLine("Product Name: " + rate.Name + " Rating: " + rate.Rating);
}
foreach (var prod in repo.GetProductsAndReviews())
{
if (product == null)
{
product = prod;
}
Console.WriteLine("Product Name: " + prod.Name);
}
Console.ReadLine();
}
static void Main(string[] args)
{
var configuration = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
#if DEBUG
.AddJsonFile("appsettings.Debug.json")
#else
.AddJsonFile("appsettings.Release.json")
#endif
.Build();
var connectionString = configuration.GetConnectionString("DefaultConnection");
var dapperRepo = new DapperProductRepository(connectionString);
var repo = new ProductRepository(connectionString);
var newItem = new Product()
{
Name = "testProduct"
};
var updateItem = new Product()
{
Name = "updatedTestProduct"
};
//GetProducts
foreach (var prod in repo.GetProducts())
{
Console.WriteLine("Product Name: " + prod.Name);
}
WaitForEnterKey();
//GetProducts with Dapper
foreach (var prod in dapperRepo.GetProducts())
{
Console.WriteLine("Product Name: " + prod.Name);
}
WaitForEnterKey();
//GetProductsWithReview
foreach (var prod in repo.GetProductsWithReview())
{
Console.WriteLine("Product Name: " + prod.Name + "\n\nReview: " + prod.Review + "\n\n");
}
WaitForEnterKey();
//GetProductsWithReview with Dapper
foreach (var prod in dapperRepo.GetProductsWithReview())
{
Console.WriteLine("Product Name: " + prod.Name + "\n\nReview: " + prod.Review + "\n\n");
}
WaitForEnterKey();
//GetProductsAndReview
foreach (var prod in repo.GetProductsAndReview())
{
Console.WriteLine("Product Name: " + prod.Name + "\n\nReview: " + prod.Review + "\n\n");
}
WaitForEnterKey();
//GetProductsAndReview with Dapper
foreach (var prod in dapperRepo.GetProductsAndReview())
{
Console.WriteLine("Product Name: " + prod.Name + "\n\nReview: " + prod.Review + "\n\n");
}
WaitForEnterKey();
//InsertProduct
Console.WriteLine("Press Enter to Add a new Product");
Console.ReadKey();
repo.InsertProduct(newItem);
var newestId = repo.GetNewestId().Last().Id;
Console.WriteLine($"\nNew Item Added\nID: {newestId}\nName: {newItem.Name}");
WaitForEnterKey();
//UpdateProduct
updateItem.Id = newestId;
Console.WriteLine("Press Enter to Update the new Product");
Console.ReadKey();
repo.UpdateProduct(updateItem);
Console.WriteLine($"\nItem Updated\nID: {newestId}\nName: {updateItem.Name}");
WaitForEnterKey();
//DeleteProduct
Console.WriteLine("Press Enter to Delete the new Product");
Console.ReadKey();
repo.DeleteProduct(updateItem.Id);
Console.WriteLine($"\nItem with ID: {newestId} Deleted");
WaitForEnterKey();
//InsertProduct with Dapper
Console.WriteLine("Press Enter to Add a new Product with Dapper");
Console.ReadKey();
dapperRepo.InsertProduct(newItem);
newestId = dapperRepo.GetNewestId().Last().Id;
Console.WriteLine($"\nNew Item Added\nID: {newestId}\nName: {newItem.Name}");
WaitForEnterKey();
//UpdateProduct with Dapper
updateItem.Id = dapperRepo.GetNewestId().Last().Id;
Console.WriteLine("Press Enter to Update the new Product with Dapper");
Console.ReadKey();
dapperRepo.UpdateProduct(updateItem);
Console.WriteLine($"\nItem Updated\nID: {newestId}\nName: {updateItem.Name}");
WaitForEnterKey();
//DeleteProduct with Dapper
Console.WriteLine("Press Enter to Delete the new Product with Dapper");
Console.ReadKey();
dapperRepo.DeleteProduct(updateItem.Id);
Console.WriteLine($"\nItem with ID: {newestId} Deleted");
WaitForEnterKey();
}
