static void Main(string[] args) { var connectionString = "Server=localhost;Database=adventureworks;Uid=root;Pwd=huffmanhigh1;"; using (var conn = new MySqlConnection(connectionString)); { var repo = new DapperDB(conn); var products = repo.GetProducts(); foreach (var prod in repo.GetProducts()) { Console.WriteLine("Product Name:" + prod.Name + "" + prod.ListPrice + prod.ModifiedDate.DayOfWeek); } repo.DeleteProduct(1); Console.WriteLine("Should have deleted product"); var product = new Product { ProductId = 2, Name = "Awesome Amazing Product" }; repo.UpdateProduct(product); Console.WriteLine("Should have updated the product" + product.ProductId); { repo.InsertProduct(product); Console.WriteLine("Should INSERT into Product " + product.ProductId); //ProductId = 5, //Name = "Bike", //ProductNumber = "BR=1004", //Color = "Blue", //SafetyStockLevel = 1000, //ReorderPoint = 500, //StandardCost = 500, //ListPrice = 1025.36, } } }
protected TopeveryRepositoryBase(IDbContextProvider <TopeveryDbContext> dbContextProvider) : base(dbContextProvider) { DapperDb = DapperDB.CreateDatabase <OracleConnection>(_connection); }