/// <summary>
/// Retrieves list of ChapterContent objects from SqlCommand, after database query
/// number of rows retrieved and returned depends upon the rows field value
/// </summary>
/// <param name="cmd">The command object to use for query</param>
/// <param name="rows">Number of rows to process</param>
/// <returns>A list of ChapterContent objects</returns>
private ChapterContentList GetList(SqlCommand cmd, long rows)
{
// Select multiple records
SqlDataReader reader;
long result = SelectRecords(cmd, out reader);
//ChapterContent list
ChapterContentList list = new ChapterContentList();
using ( reader )
{
// Read rows until end of result or number of rows specified is reached
while (reader.Read() && rows-- != 0)
{
ChapterContent chapterContentObject = new ChapterContent();
FillObject(chapterContentObject, reader);
list.Add(chapterContentObject);
}
// Close the reader in order to receive output parameters
// Output parameters are not available until reader is closed.
reader.Close();
}
return(list);
}
