Sorting data returned by the database

Question

In our project, we have a requirement that when the recordset is returned to the database, the records must be sorted relative to the TITLE field in the record. Entries should be sorted alphabetically, but if there is a number in the entry name, then it should appear after entries whose title consists only of alphabets.

More: we use SQL Server and C #. Data from the database enters the Entity class, which passes data to other layers.

So, what will be the possible and effective solution for this requirement.

Answer 1

, , TITLE. :

class Entity
{
   ...
   public string TITLE { get; set; }
   ...
}

List<Entity>, , , Sort .

, , Sort Comparer. . http://msdn.microsoft.com/en-us/library/234b841s.aspx.
Compare(Entity x, Entity y) .

---

TITLE's:
:

private static int StringComparer(string x, string y)
{
    if (!x.AllChar()) return 1;
    if (!y.AllChar()) return -1;

    return x.CompareTo(y) * -1;
}

public static bool AllChar(this string x)
{
    char[] chars = x.ToCharArray();
    bool allchar = chars.Any<char>((c) => !char.IsLetter(c));

    return !allchar;
}