This is caused because of Where-Expression. You should only use variables in there or call methods that can be translated to SQL. First, save your Session value in a variable.
In this example I am going to explain How to create DropDownList using MVC .net.Here, I am binding the MVC dropdownlist from model object (myDatabaseEntity) using entity framework.