/// <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;
}
}
