public static string CreateQuery(this SearchParameter search, string column, string source) { string result = string.Empty; try { string condition = search.ConditionList.CreateCondition(); string ordering = search.CreateOrdering(); string offset = search.CreateOffSet(); result = string.Format("SELECT COUNT(*) AS TotalRecord {0} {1}; {2} {3} {4} {5} {6}", source, condition, column, source, condition, ordering, offset); } catch (Exception ex) { throw ex; } return(result); }