static void Main(string[] args) { VendorController VendorCtrl = new VendorController(@"STUDENT02\SQLEXPRESS", "prssql"); IEnumerable <Vendor> vendors = VendorCtrl.List(); foreach (Vendor vendor1 in vendors) { Console.WriteLine($"{vendor1.Code} {vendor1.Name}"); } Vendor vendor = VendorCtrl.Get(5); if (vendor == null) { Console.WriteLine("Vendor not found"); } else { Console.WriteLine($"{vendor.Code} {vendor.Name}"); } //Vendor newVendor = new Vendor(); //commenting out, already know this working and don't want to add more vendors //newVendor.Code = "TAR3"; //newVendor.Name = "Target3"; //newVendor.Address = "1234 Minnehaha Ave"; //newVendor.City = "Minneapolis"; //newVendor.State = "MN"; //newVendor.Zip = "55417"; //newVendor.Phone = "123-456-7890"; //newVendor.Email = "*****@*****.**"; //newVendor.IsPreApproved = true; //newVendor.Active = true; //bool success = VendorCtrl.Create(newVendor); vendor = VendorCtrl.Get(9); vendor.Address = "5252 Drury Lane"; bool success = VendorCtrl.Change(vendor); //VendorCtrl.CloseConnection(); vendor = VendorCtrl.Get(8); success = VendorCtrl.Remove(vendor); VendorCtrl.CloseConnection(); }