I am using entity framework with asp.net mvc3 razor. Now i had an table which represents the Countries(like India, US) e.t.c. And my requirement is i need to open a pop-up with the flags of all countries which i had in database. And when user click on one flag i need to show that particular country details first and remaining as line by line in the webgrid(asp.net mvc3 razor)

So i had prepared a list of "Countries" by getting all the countries from database.And i prepared another list "OrderofCountries" by adding Order(property) "1" to the which user had clicked. And from 2 to all the remaining countries.Now i need to join this list i.e "OrderofContries" with the remaining tables(from database as for the requirement). But i entity framework it raises error when i join like

Unable to create a constant value of type 'Slmg.BusinessObjects.CountriesBO'. Only primitive types ('such as Int32, String, and Guid') are supported in this context.

My idea here is by using order property i can sort the data so that i can get the required data.

Can we join our prepared list with the database table in entiy framework? How to solve my issue. Can any one please help me to find the solution.