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); } }