public void SetFileLocationAtLaterTime()
{
using (var context = Factory.FluentApi.GetContext()) {
using (var fileOptions = Factory.GetExcelFileOptions()) {
//remove all file related info from options
var fileStream = fileOptions.ExcelFileStream;
fileOptions.ExcelFileStream = null;
var worksheetName = fileOptions.WorksheetName;
fileOptions.WorksheetName = null;
var filePassword = fileOptions.FilePassword;
fileOptions.FilePassword = null;
using (IExcelRepository <DomainObject_FluentApi, int> repo
= new EPPlusDomainRepository <DomainObject_FluentApi, int>(context, fileOptions)) {
DomainObject_FluentApi parsedRow;
//without file information, repo runs into exception
Assert.Throws <NullReferenceException>(() => {
parsedRow = repo.GetByRowId(10);
});
//set file location before usage
repo.SetExcelDataSource(fileStream, worksheetName, filePassword);
parsedRow = repo.GetByRowId(10);
UnitTestMetadata.AssertEqual(UnitTestMetadata.ActualRow10, parsedRow);
}
}
}
}
public void GetByKeyOrRowId()
{
using (var context = Factory.FluentApi.GetContext())
using (var fileOptions = Factory.GetExcelFileOptions())
using (IExcelRepository <DomainObject_FluentApi, int> repo
= new EPPlusDomainRepository <DomainObject_FluentApi, int>(context, fileOptions)) {
var parsedRow10 = repo.GetByRowId(10);
UnitTestMetadata.AssertEqual(UnitTestMetadata.ActualRow10, parsedRow10);
parsedRow10 = repo.GetByKey(10);
UnitTestMetadata.AssertEqual(UnitTestMetadata.ActualRow10, parsedRow10);
}
}
