Thanks for your feedback.

Is there any work around for this? I have looked at the beer house code at there is times a SP only returns a couple fields and their doesn't seem to be any problem. For performance reasons it would be better if the SP only returned the exact information required.

can you post a sample of where beerhouse does that (don't know the code by heart :)
and the SP that is used ?

My problem was that the stored procedure, tbh_Articles_GetArticles, has a bug in it. The line that says "tbh_Articles.ReleaseDate AS RelDate" should actually be "tbh_Articles.ReleaseDate AS ReleaseDate". My reader was rightfully looking for something called "ReleaseDate" but the stored procedure named it "RelDate" instead. So I changed to what the reader was looking for (reader["ReleaseDate"]).

This happens in several stored procedures from the book (wherever Articles.ReleaseDate is selected).

hello,

example with ImageUrl (if you have stored procedure that not retieve ImageUrl field for example you set exclude to true :


 protected virtual CategoryDetails GetCategoryFromReader(IDataReader reader, bool exclude)
      {

if(!exclude)
         return new CategoryDetails(
            (int)reader["CategoryID"],
            (DateTime)reader["AddedDate"],
            reader["AddedBy"].ToString(),
            reader["Title"].ToString(),
            (int)reader["Importance"],
            reader["Description"].ToString(),
            reader["ImageUrl"].ToString());
else
         return new CategoryDetails(
            (int)reader["CategoryID"],
            (DateTime)reader["AddedDate"],
            reader["AddedBy"].ToString(),
            reader["Title"].ToString(),
            (int)reader["Importance"],
            reader["Description"].ToString(),
            "";

      }


      protected virtual List<CategoryDetails> GetCategoryCollectionFromReader(IDataReader reader, bool exclude)
      {
         List<CategoryDetails> categories = new List<CategoryDetails>();
         while (reader.Read())
            categories.Add(GetCategoryFromReader(reader, exclude));
         return categories;


cheers