I have a table field called “ApDay VARCHAR(15)” which contains Days of Week. I want to sort the table values according to the ApDay field. That means i want to sort results according to the days of week. But i want to sort them to a custom order. Which means the “Saturday” should come first then other like “sunday,monday,…” so on. I am using entity framework. Can any one plese tell me how to achieve this using entity framework and C#.
Thanks in advance.