Select [Name] from <table> order by case when[Name] = 'Texas' then 1 else 2 end,[Name]
This is what I have tried so far: var value = from c in <table> orderby c.Name select new { NameIndex = c.Name };
... orderby (c.Name == "Texas" ? 1 : 2) ...
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)