/// <summary> /// Finds the most common name. /// </summary> /// <returns></returns> public static string FindMostCommonName() { try { Criteria criteria = Criteria.For <PeopleNames>(); criteria .Add(criteria.Desc("Occurrences")) .Add(criteria.Asc("Name")); List <String> names = PeopleNames.SlicedProjectionFindAll <String>(criteria, "Name", 0, 1); return(names != null && names.Count == 1 ? names[0] : String.Empty); /* * Could also be: * * PeopleNames.FindFirst(criteria).Name */ } catch (Exception ex) { //Do something throw ex; } }
/// <summary> /// Finds all with letter. /// </summary> /// <param name="letter">The letter.</param> /// <param name="mode">The mode.</param> /// <returns></returns> public static List <Person> FindAllWithLetter(string letter, MatchMode mode) { try { Criteria criteria = Criteria.For <Person>(); criteria .Add(criteria.Like("Name", letter, mode)) .Add(criteria.Asc("Name")); return(Person.FindAll(criteria)); } catch (Exception ex) { //Do something throw ex; } }
/// <summary> /// Counts the peoploe starting with a or b. /// </summary> /// <returns></returns> public static int CountStartingWithAOrB() { try { Criteria criteria = Criteria.For <Person>(); criteria .Add( criteria.Or() .AddSubFilter(criteria.Like("Name", "a", MatchMode.Start)) .AddSubFilter(criteria.Like("Name", "b", MatchMode.Start)) ) .Add(criteria.Asc("Name")); return(Person.Count(criteria)); } catch (Exception ex) { //Do something throw ex; } }