public void GetFileEntriesByDisc_DiscExists_GetsCorrectFileEntries()
{
string dbLocation = @"c:\temp\Files on Dvd.accdb";
AccessRetriever myRetriever = new AccessRetriever(dbLocation);
int discId = 220;
DataSet dataSet = myRetriever.GetFileEntriesByDiscId(discId);
DataTable dt = dataSet.Tables[0];
int expectedCount = 4;
Assert.AreEqual(expectedCount, dt.Rows.Count);
Console.WriteLine("Debug this line and examine the dt object");
}
private DataSet RetrieveFileEntriesFromDatabase(AccessRetriever retriever, int?discId = null)
{
DataSet dataSet;
try {
if (discId == null)
{
dataSet = retriever.GetFileEntries();
}
else
{
dataSet = retriever.GetFileEntriesByDiscId((int)discId);
}
}
catch (Exception e) {
Log.Error(e, "Could not retrieve filenames from Access DB");
throw new InvalidOperationException("Could not retrieve filenames from Access DB", e);
}
if (dataSet is null)
{
throw new InvalidOperationException("Filenames dataSet is null");
}
return(dataSet);
}