public IList <Gig> Get(string where, string orderBy, int startIndex, int noRecords, out int totalNoRecords)
{
IList <Gig> gigs = new List <Gig>();
using (SprocWrapper db = new SprocWrapper())
{
using (IDataReader reader = db.Gigs_Get(where, orderBy))
{
FillGigCollection(reader, gigs, 0, Int32.MaxValue, out totalNoRecords);
}
}
return(gigs);
}