public void TableSplitting()
{
// Inserting data
using (SakilaLiteTableSplittingContext context = new SakilaLiteTableSplittingContext())
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.Films.Add(new FilmLite
{
FilmId = 1,
Title = "ACADEMY DINOSAUR",
Description = "A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies",
Details = new FilmDetails
{
FilmId = 1,
ReleaseYear = 2006,
LanguageId = 1,
OriginalLanguageId = null,
RentalDuration = 6,
RentalRate = 0.99m,
Length = 86,
ReplacementCost = 20.99m,
Rating = "PG",
SpecialFeatures = "Deleted Scenes,Behind the Scenes",
LastUpdate = DateTime.Parse("2006-02-15 05:03:42")
}
});
context.Films.Add(new FilmLite
{
FilmId = 2,
Title = "ACE GOLDFINGER",
Description = "A Astounding Epistle of a Database Administrator And a Explorer who must Find a Car in Ancient China"
});
context.FilmDetails.Add(new FilmDetails
{
FilmId = 2,
ReleaseYear = 2006,
LanguageId = 1,
OriginalLanguageId = null,
RentalDuration = 3,
RentalRate = 4.99m,
Length = 48,
ReplacementCost = 12.99m,
Rating = "G",
SpecialFeatures = "Trailers,Deleted Scenes",
LastUpdate = DateTime.Parse("2006-02-15 05:03:42")
});
context.SaveChanges();
}
// Validating data
using (SakilaLiteTableSplittingContext context = new SakilaLiteTableSplittingContext())
{
var films = context.Films.Include(e => e.Details).ToList();
Action <FilmLite, int, string, short> validate = (film, id, title, releaseYear) =>
{
Assert.Equal(id, film.FilmId);
Assert.NotNull(film.Details);
Assert.NotNull(film.Details.Film);
Assert.Equal(id, film.Details.FilmId);
Assert.Equal(title, film.Title);
Assert.Equal(releaseYear, film.Details.ReleaseYear);
};
Assert.Collection(films,
film => validate(film, 1, "ACADEMY DINOSAUR", 2006),
film => validate(film, 2, "ACE GOLDFINGER", 2006)
);
}
}
public void TableSplitting()
{
// Inserting data
using (SakilaLiteTableSplittingContext context = new SakilaLiteTableSplittingContext())
{
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
context.Films.Add(new FilmLite
{
FilmId = 1,
Title = "ACADEMY DINOSAUR",
Description = "A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies",
Details = new FilmDetails
{
FilmId = 1,
ReleaseYear = 2006,
LanguageId = 1,
OriginalLanguageId = null,
RentalDuration = 6,
RentalRate = 0.99m,
Length = 86,
ReplacementCost = 20.99m,
Rating = "PG",
SpecialFeatures = "Deleted Scenes,Behind the Scenes",
LastUpdate = DateTime.Parse("2006-02-15 05:03:42")
}
});
context.Films.Add(new FilmLite
{
FilmId = 2,
Title = "ACE GOLDFINGER",
Description = "A Astounding Epistle of a Database Administrator And a Explorer who must Find a Car in Ancient China"
});
context.FilmDetails.Add(new FilmDetails
{
FilmId = 2,
ReleaseYear = 2006,
LanguageId = 1,
OriginalLanguageId = null,
RentalDuration = 3,
RentalRate = 4.99m,
Length = 48,
ReplacementCost = 12.99m,
Rating = "G",
SpecialFeatures = "Trailers,Deleted Scenes",
LastUpdate = DateTime.Parse("2006-02-15 05:03:42")
});
context.SaveChanges();
}
// Validating data
using (SakilaLiteTableSplittingContext context = new SakilaLiteTableSplittingContext())
{
var films = context.Films.Include(e => e.Details).ToList();
Assert.That(films.Where(a => a.FilmId == 1), Has.One.Items);
Assert.That(films.Where(a => a.FilmId == 2), Has.One.Items);
Assert.That(films.Select(c => c.Title), Has.Exactly(1).Matches <string>(Title => Title.Contains("ACADEMY DINOSAUR")));
Assert.That(films.Select(c => c.Title), Has.Exactly(1).Matches <string>(Title => Title.Contains("ACE GOLDFINGER")));
Assert.That(films.Where(a => a.Details.Film.Details.ReleaseYear == 2006), Has.Exactly(2).Items);
}
}
