public void RunNHibernateTests()
{
DisplayAllValues();
var entry = CreateNewEntry();
DisplayAllValues();
UpdateEntry(entry);
DisplayAllValues();
DeleteEntry(entry);
DisplayAllValues();
AttemptToEnterDuplicateKey();
MissingForeignKey();
DeleteForeignKeyReference();
UpdateFailsDueToMissingForeignKey();
void DeleteForeignKeyReference()
{
Logger.WriteLine("Attempt to delete parent record in foreign key relationship...");
try
{
_nhibernateRepository.RunMultipeStepsInsideTransaction((session, transaction) =>
{
var parent = new Models.DbSwitcher
{
CreatedDate = DateTime.Now,
IsTrue = true,
Summary = "First",
UniqueId = Guid.NewGuid()
};
parent.Id = (int)session.Save(parent);
session.Flush();
var child = new Models.DependentTable
{
CreatedDate = DateTime.Now,
DbSwitcherId = parent.Id
};
child.Id = (int)session.Save(child);
session.Flush();
session.Delete(parent);
session.Flush();
});
}
catch (Exception ex)
{
WriteExceptionMessage(ex);
}
}
void MissingForeignKey()
{
Logger.WriteLine("Attempt to create dependent record when foreign key reference does not exist...");
try
{
var child = new Models.DependentTable
{
CreatedDate = DateTime.Now,
DbSwitcherId = 1234567
};
_nhibernateRepository.Create(child);
}
catch (Exception ex)
{
WriteExceptionMessage(ex);
}
}
void UpdateFailsDueToMissingForeignKey()
{
Logger.WriteLine("Attempt to change a foreign key to reference record that does not exist...");
try
{
_nhibernateRepository.RunMultipeStepsInsideTransaction((session, transaction) =>
{
var parent = new Models.DbSwitcher
{
CreatedDate = DateTime.Now,
IsTrue = true,
Summary = "First",
UniqueId = Guid.NewGuid()
};
parent.Id = (int)session.Save(parent);
session.Flush();
var child = new Models.DependentTable
{
CreatedDate = DateTime.Now,
DbSwitcherId = parent.Id
};
child.Id = (int)session.Save(child);
session.Flush();
child.DbSwitcherId = 123234235;
session.Update(child);
session.Flush();
});
}
catch (Exception ex)
{
WriteExceptionMessage(ex);
}
}
void AttemptToEnterDuplicateKey()
{
Logger.WriteLine("Attempting Duplicate Key Test...");
var first = new Models.DbSwitcher
{
CreatedDate = DateTime.Now,
IsTrue = true,
Summary = "First",
UniqueId = Guid.NewGuid()
};
var second = new Models.DbSwitcher
{
CreatedDate = DateTime.Now,
IsTrue = true,
Summary = "Second",
UniqueId = first.UniqueId
};
_dbContext.DbSwitchers.Add(second);
try
{
_nhibernateRepository.Create <Models.DbSwitcher>(new[] { first, second });
}
catch (Exception ex)
{
WriteExceptionMessage(ex);
}
}
void DisplayAllValues()
{
foreach (var dbSwitcher in _nhibernateRepository.FindAll <Models.DbSwitcher>())
{
Logger.WriteLine(dbSwitcher.ToString());
}
}
Models.DbSwitcher CreateNewEntry()
{
Logger.WriteLine("CreateNewEntry...");
var item = _nhibernateRepository.Create(new Models.DbSwitcher
{
CreatedDate = DateTime.Now,
IsTrue = true,
Summary = "New Entry",
UniqueId = Guid.NewGuid()
});
return(item);
}
void UpdateEntry(Models.DbSwitcher entity)
{
Logger.WriteLine("UpdateEntry...");
entity.IsTrue = false;
entity.IsTrue = true;
_nhibernateRepository.Update(entity);
}
void DeleteEntry(Models.DbSwitcher entity)
{
Logger.WriteLine("DeleteEntry...");
_nhibernateRepository.Delete(entity);
}
}
public void RunEntityFrameworkTests()
{
DisplayAllValues();
var entry = CreateNewEntry();
DisplayAllValues();
UpdateEntry(entry);
DisplayAllValues();
DeleteEntry(entry);
DisplayAllValues();
AttemptToEnterDuplicateKey();
MissingForeignKey();
DeleteForeignKeyReference();
UpdateFailsDueToMissingForeignKey();
void DeleteForeignKeyReference()
{
Logger.WriteLine("Attempt to delete parent record in foreign key relationship...");
try
{
using (var _ = new TransactionScope())
{
var parent = new Models.DbSwitcher
{
CreatedDate = DateTime.Now,
IsTrue = true,
Summary = "First",
UniqueId = Guid.NewGuid()
};
_dbContext.DbSwitchers.Add(parent);
_dbContext.SaveChanges();
var child = new Models.DependentTable
{
CreatedDate = DateTime.Now,
DbSwitcherId = parent.Id
};
_dbContext.DependentTables.Add(child);
_dbContext.SaveChanges();
_dbContext.Remove(parent);
_dbContext.SaveChanges();
}
}
catch (Exception ex)
{
WriteExceptionMessage(ex);
}
}
void MissingForeignKey()
{
Logger.WriteLine("Attempt to create dependent record when foreign key reference does not exist...");
try
{
var child = new Models.DependentTable
{
CreatedDate = DateTime.Now,
DbSwitcherId = 1234567
};
_dbContext.DependentTables.Add(child);
_dbContext.SaveChanges();
}
catch (Exception ex)
{
WriteExceptionMessage(ex);
}
}
void UpdateFailsDueToMissingForeignKey()
{
Logger.WriteLine("Attempt to change a foreign key to reference record that does not exist...");
try
{
using (var _ = new TransactionScope())
{
var parent = new Models.DbSwitcher
{
CreatedDate = DateTime.Now,
IsTrue = true,
Summary = "First",
UniqueId = Guid.NewGuid()
};
_dbContext.DbSwitchers.Add(parent);
_dbContext.SaveChanges();
var child = new Models.DependentTable
{
CreatedDate = DateTime.Now,
DbSwitcherId = parent.Id
};
_dbContext.DependentTables.Add(child);
_dbContext.SaveChanges();
child.DbSwitcherId = 123124634;
_dbContext.SaveChanges();
}
}
catch (Exception ex)
{
WriteExceptionMessage(ex);
}
}
void AttemptToEnterDuplicateKey()
{
Logger.WriteLine("Attempting Duplicate Key Test...");
var first = new Models.DbSwitcher
{
CreatedDate = DateTime.Now,
IsTrue = true,
Summary = "First",
UniqueId = Guid.NewGuid()
};
_dbContext.DbSwitchers.Add(first);
var second = new Models.DbSwitcher
{
CreatedDate = DateTime.Now,
IsTrue = true,
Summary = "Second",
UniqueId = first.UniqueId
};
_dbContext.DbSwitchers.Add(second);
try
{
using (var _ = new TransactionScope())
{
_dbContext.SaveChanges();
}
}
catch (Exception ex)
{
WriteExceptionMessage(ex);
}
}
void DisplayAllValues()
{
foreach (var dbSwitcher in _dbContext.DbSwitchers.Where(x => x.Id > -1).ToList())
{
Logger.WriteLine(dbSwitcher.ToString());
}
}
Models.DbSwitcher CreateNewEntry()
{
Logger.WriteLine("CreateNewEntry...");
var item = _dbContext.DbSwitchers.Add(new Models.DbSwitcher
{
CreatedDate = DateTime.Now,
IsTrue = true,
Summary = "New Entry",
UniqueId = Guid.NewGuid()
}).Entity;
_dbContext.SaveChanges();
return(item);
}
void UpdateEntry(Models.DbSwitcher entity)
{
Logger.WriteLine("UpdateEntry...");
entity.IsTrue = false;
_dbContext.SaveChanges();
}
void DeleteEntry(Models.DbSwitcher entity)
{
Logger.WriteLine("DeleteEntry...");
_dbContext.Remove(entity);
_dbContext.SaveChanges();
}
}
