-- SNIPPET TO EXECUTE AS DATA SET
System.Data.DataSet ds = sagesql.ExecuteAsDataSet(sp);
if (ds != null && ds.Tables.Count > 0)
{
AudienceDetailInfo lstCampaignObjectiveInfo = DataSourceHelper.FillObject<AudienceDetailInfo>(ds.Tables[0].CreateDataReader());
}