public IList <R_Project> GetProjects(string searchTerm, int pageIndex, int pageSize) { IList <R_Project> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_Project") .Where("IsDeleted = 0") .Where( "Name like '%" + searchTerm + "%'" + " or " + "Description like '%" + searchTerm + "%'" + " or " + "DeadlineCall like '%" + searchTerm + "%'" + " or " + "Funding like '%" + searchTerm + "%'" + " or " + "AreaOfInterest like '%" + searchTerm + "%'" ) ; results = R_Project.Fetch(pageIndex, pageSize, sql); return(results); }