static void main() { DrinkContext db = new DrinkContext(); CoffeeStore charleys = new CoffeeStore() { Eircode = "T12GH46", City = City.Dublin, OpeningTime = OpeningHour.AM0700, ClosingTime = ClosingHour.PM1800, Location = "dublin fair city", StoreName = "charleys", hasWifi = true }; List <Review> reviews = new List <Review>(); reviews.Add(new Review() { CustomerName = "Stevo", CustomerEmail = "*****@*****.**", Eircode = charleys.Eircode, Comment = "It was great", Rating = 4 }); reviews.Add(new Review() { CustomerName = "john", CustomerEmail = "*****@*****.**", Eircode = charleys.Eircode, Comment = "It was great", Rating = 3 }); reviews.Add(new Review() { CustomerName = "pete", CustomerEmail = "*****@*****.**", Eircode = charleys.Eircode, Comment = "It wasn't great", Rating = 2 }); //my local connection string //Data Source=.\SQLEXPRESS;Initial Catalog=newDb;Integrated Security=SSPI;AttachDBFilename=C:\martin\data\coffeeDb.mdf }
static void main() { DrinkContext db = new DrinkContext(); CoffeeStore charleys = new CoffeeStore() { Eircode = "T12GH46", City = City.Dublin, OpeningTime = OpeningHour.AM0700, ClosingTime = ClosingHour.PM1800, Location = "dublin fair city", StoreName = "charleys", hasWifi = true }; List<Review> reviews = new List<Review>(); reviews.Add(new Review() { CustomerName = "Stevo", CustomerEmail = "*****@*****.**", Eircode = charleys.Eircode, Comment = "It was great", Rating = 4 }); reviews.Add(new Review() { CustomerName = "john", CustomerEmail = "*****@*****.**", Eircode = charleys.Eircode, Comment = "It was great", Rating = 3 }); reviews.Add(new Review() { CustomerName = "pete", CustomerEmail = "*****@*****.**", Eircode = charleys.Eircode, Comment = "It wasn't great", Rating = 2 }); //my local connection string //Data Source=.\SQLEXPRESS;Initial Catalog=newDb;Integrated Security=SSPI;AttachDBFilename=C:\martin\data\coffeeDb.mdf }
public void AddReview(Review review) { using (DrinkContext db = new DrinkContext()) { try { db.Reviews.Add(review); db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.ToString()); } } }
public void AddDrink(Drink drink) { using (DrinkContext db = new DrinkContext()) { try { db.Drinks.Add(drink); db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.ToString()); } } }
public void AddStore(CoffeeStore cs) { using (DrinkContext db = new DrinkContext()) { try { db.CoffeeStores.Add(cs); db.SaveChanges(); } catch (Exception e) { Console.WriteLine(e.ToString()); } } }