Call Stored Procedure in HibernateTemplate helper Functions
public class Flagger
    {
        public virtual string FlaggerName { set; get; }
        public virtual int StatusId { set; get; }
        public virtual DateTime DataFileReceived { set; get; }
        public virtual DateTime ProcessStartDate { set; get; }
        public virtual DateTime ProcessCompleteDate { set; get; }
        public virtual int Total { set; get; }
        public virtual int Identical { set; get; }
        public virtual int Differences { set; get; }
        public virtual string ServiceId { set; get; }
        public virtual string CountyFips { set; get; }
        public virtual string StateFips { set; get; }
        public virtual string DtCountyId { set; get; }
    }


    public IEnumerable<Flagger> GetAllFlaggers()
    {
         var getsp = HibernateTemplate.FindByNamedQuery<Flagger>("exec TestFlaggerSp");
         return getsp;
    }