/// <summary>
/// 这个功能演示联级删除 FluentApi
/// </summary>
static void FluentApiDeleteDestinationInMemoryAndDbCascade()
{
Guid destinationId;
using (var context = new FluentApiBreakAwayContext(nameOrConnectionString))
{
var destination = new FluentApiModel.Destination
{
Name = "Sample Destination",
Address = new FluentApiModel.Address
{
City = "City",
StreetAddress = "StreetAddress",
State = "State",
ZipCode = "ZipCode"
},
Info = new FluentApiModel.PersonalInfo
{
DietryRestrictions = "DietryRestrictions",
Height = new FluentApiModel.Measurement
{
Reading = 0.1M,
Units = "0.2"
},
Width = new FluentApiModel.Measurement
{
Reading = 1.1M,
Units = "1.2"
}
},
Lodgings = new List <FluentApiModel.Lodging>
{
new FluentApiModel.Lodging
{
Name = "Lodging One"
},
new FluentApiModel.Lodging
{
Name = "Lodging Two"
}
}
};
context.Destinations.Add(destination);
context.SaveChanges();
destinationId = destination.DestinationId;
}
using (var context = new FluentApiBreakAwayContext(nameOrConnectionString))
{
var destination = context.Destinations.Include("Lodgings").Single(d => d.DestinationId == destinationId);
var aLodging = destination.Lodgings.FirstOrDefault();
context.Destinations.Remove(destination);
Console.WriteLine("State of one Lodging: {0}", context.Entry(aLodging).State.ToString());
context.SaveChanges();
}
}
static void FluentApiInsertDestination()
{
var destination = new FluentApiModel.Destination
{
Country = "Indonesia",
Description = "EcoTourism at its best in exquisite Bali",
Name = "Bali",
Address = new FluentApiModel.Address
{
City = "shanghai",
State = "huayi",
ZipCode = "000000",
StreetAddress = "yishanlu"
},
Info = new FluentApiModel.PersonalInfo
{
DietryRestrictions = "DietryRestrictions",
Height = new FluentApiModel.Measurement
{
Reading = 100,
Units = "200"
},
Width = new FluentApiModel.Measurement
{
Reading = 200,
Units = "300"
},
},
Lodgings = new List <FluentApiModel.Lodging>()
{
new FluentApiModel.Lodging
{
Name = "lodging Name",
Owner = "lodging Owner",
//IsResort = true,
MilesFromNearestAirport = 1.1M
},
new FluentApiModel.Lodging
{
Name = "lodging Name2",
Owner = "lodging Owner2",
//IsResort = true,
MilesFromNearestAirport = 2.2M
}
}
};
using (var context = new FluentApiBreakAwayContext(nameOrConnectionString))
{
context.Destinations.Add(destination);
context.SaveChanges();
}
using (var context = new FluentApiBreakAwayContext(nameOrConnectionString))
{
var destinationsArray = context.Destinations.ToList();
var destinationFirst = destinationsArray[0];
destinationFirst.Description += "Trust us, you'll love it!";
context.SaveChanges();
//context.Destinations.Remove(destinationFirst);
context.SaveChanges();
}
}