private static void InsertDestination()
{
Destination destination = new Destination
{
Country = "Indonesia",
Description = "EcoTourism at its best in esquisite Bali",
Name = "Bali"
};
using(BreakAwayContext context = new BreakAwayContext())
{
context.Destinations.Add(destination);
context.SaveChanges();
}
}
//----------------------------------------------
//Chapter 2 - Adding Changing And Deleting Entities
//----------------------------------------------
//Adding New Entities
//--------------------------
private static void AddMachuPicchu()
{
using (var context = new BreakAwayContext())
{
var machuPicchu = new Destination
{
Name = "Machu Picchu",
Country = "Peru"
};
context.Destinations.Add(machuPicchu);
context.SaveChanges();
}
}
//Multiple Changes at Once
private static void MakeMultipleChanges()
{
using (var context = new BreakAwayContext())
{
var niagaraFalls = new Destination
{
Name = "Niagara Falls",
Country = "USA"
};
context.Destinations.Add(niagaraFalls);
var wineGlassBay = (from d in context.Destinations
where d.Name == "Wine Glass Bay"
select d).Single();
wineGlassBay.Description = "Picturesque bay with beaches.";
context.SaveChanges();
}
}
private List<Destination> ReadExcelData(OleDbConnection conn, string sheetName)
{
Console.WriteLine("Reading data...");
var excelDbCommand = new OleDbCommand(@"SELECT * FROM [" + sheetName + "]", conn);
using (var oleDbDataAdapter = new OleDbDataAdapter(excelDbCommand))
{
DataSet ds = new DataSet();
oleDbDataAdapter.Fill(ds);
var destinations = new List<Destination>();
using (var reader = ds.CreateDataReader())
{
while (reader.Read())
{
var destination = new Destination();
destination.Country = reader["Country"].ToString();
destination.Distance = double.Parse(reader["Distance"].ToString());
destination.LuxuryFactor = int.Parse(reader["LuxuryFactor"].ToString());
destinations.Add(destination);
}
}
return destinations;
}
}
private static void DeleteDestinationInMemoryAndDbCascade()
{
int destinationId;
using(BreakAwayContext context = new BreakAwayContext())
{
Destination destination = new Destination
{
Name = "Sample Destination",
Lodgings = new List<Lodging>
{
new Lodging { Name = "Lodging One" },
new Lodging { Name = "Lodging Two" }
}
};
context.Destinations.Add(destination);
context.SaveChanges();
destinationId = destination.DestinationId;
}
using(BreakAwayContext context = new BreakAwayContext())
{
Destination destination = context.Destinations.
Single(n => n.DestinationId == destinationId);
context.Destinations.Remove(destination);
context.SaveChanges();
}
using (BreakAwayContext context = new BreakAwayContext())
{
List<Lodging> lodgings = context.Lodgings.Where(n => n.DestinationId == destinationId).ToList();
Console.WriteLine("Lodgings: {0}", lodgings.Count);
}
}