public void ShouldBeAbleToPersistAndRecall()
{
using (var db = new TempDBLocalDb())
{
var runner = new MigrationsRunner(db.ConnectionString, Console.WriteLine);
runner.MigrateToLatest();
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
// first, put your left leg in
var item= ItemBuilder.BuildRandom();
using (var context = new LendingLibraryContext(db.CreateConnection()))
{
context.Items.Add(item);
context.SaveChangesWithErrorReporting();
}
// shake it all about
using (var context = new LendingLibraryContext(db.CreateConnection()))
{
var persisted = context.Items.FirstOrDefault(o => o.ItemId == item.ItemId);
Assert.IsNotNull(persisted);
Assert.AreEqual(item.ItemId, persisted.ItemId);
Assert.AreEqual(item.Description, persisted.Description);
Assert.AreEqual(item.Mimetype, persisted.Mimetype);
Assert.AreEqual(item.Photo, persisted.Photo);
}
//---------------Test Result -----------------------
}
}
private static void MigrateDatabase()
{
var connectionName = "LendingLibrary.Domain.LendingLibraryDbContext";
CreateDb();
var connectionString = ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;
var migrationsRunner = new MigrationsRunner(connectionString);
migrationsRunner.MigrateToLatest();
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
GlobalConfiguration.Configure(WebApiConfig.Register);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
//var windsorBootstrapper = new WindsorBootstrapper();
var windsorContainer = InitContainer();
ControllerBuilder.Current.SetControllerFactory(new ControllerFactory(windsorContainer));
var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
var migrationsRunner = new MigrationsRunner(connectionString);
migrationsRunner.MigrateToLatest();
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
GlobalConfiguration.Configure(WebApiConfig.Register);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
//var windsorBootstrapper = new WindsorBootstrapper();
var windsorContainer = InitContainer();
ControllerBuilder.Current.SetControllerFactory(new ControllerFactory(windsorContainer));
var connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
var migrationsRunner = new MigrationsRunner(connectionString);
migrationsRunner.MigrateToLatest();
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
WebApiConfig.Register(GlobalConfiguration.Configuration);
FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
RouteConfig.RegisterRoutes(RouteTable.Routes);
BundleConfig.RegisterBundles(BundleTable.Bundles);
AuthConfig.RegisterAuth();
try
{
MigrationsRunner.MigrateToLatest();
}
catch
{
// Wait for user tables to be initialized. This won't happen a second time.
// (Migrations are run after initializing the tables.)
}
}
public void ShouldBeAbleToPersistAndRecall()
{
using (var db = new TempDBLocalDb())
{
var runner = new MigrationsRunner(db.ConnectionString, Console.WriteLine);
runner.MigrateToLatest();
//---------------Set up test pack-------------------
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
// first, put your left leg in
var person = CreatePerson();
using (var context = new LendingLibraryContext(db.CreateConnection()))
{
context.People.Add(person);
context.SaveChangesWithErrorReporting();
}
// shake it all about
using (var context = new LendingLibraryContext(db.CreateConnection()))
{
var persisted = context.People.FirstOrDefault(o => o.PersonId == person.PersonId);
Assert.IsNotNull(persisted);
Assert.AreEqual(person.Email, persisted.Email);
Assert.AreEqual(person.FirstName,persisted.FirstName);
Assert.AreEqual(person.PersonId,persisted.PersonId);
Assert.AreEqual(person.Surname,persisted.Surname);
Assert.AreEqual(person.PhoneNumber,persisted.PhoneNumber);
Assert.AreEqual(person.Photo,persisted.Photo);
}
//---------------Test Result -----------------------
}
}
private void Create()
{
MigrationsRunner.MigrateToLatest(DbConnString);
}
public void MigrateToLatest()
{
_schemaImporter.MigrateToLatest();
_migrationsRunner.MigrateToLatest();
}
private void MigrateDatabaseWith(string connectionString)
{
var runner = new MigrationsRunner(connectionString);
runner.MigrateToLatest();
}