public IEnumerable GetGenericData(GenericDataSearchParameters sp)
        {
            if (sp.FromType == null)
            {
                throw new Exception("No Generic Type Detected");
            }
            var type = sp.FromType;

            SetSqlFormat("select * from {0}", type.Name);
            ClearParameters();

            sp.AppendExtraFieldsValues();
            foreach (var item in sp.Filters)
            {
                AddSqlWhereField(item.FieldName, item.Value);
            }

            IList lst = (IList)Activator.CreateInstance(GetListType(type));

            FillList(lst, type);
            return(lst);
        }
 public List <T> GetGenericData <T>(GenericDataSearchParameters sp)
 {
     sp.FromType = typeof(T);
     return(GetGenericData(sp) as List <T>);
 }
 public object GetSingleGenericData(GenericDataSearchParameters genericDataSearchParameters)
 {
     return(GetGenericData(genericDataSearchParameters).OfType <object>().FirstOrDefault());
 }