You gotta .ToArray() those suckers. Don't let your Views execute the query.
>You don't need stored proc for this.
>
>Something like
>
>var customers = context.Customers.OrderBy(c => c.CompanyName);
>var customers = context.Customers.Where(c => c.State == "NY" && c.City == "New York");
>
>or mix them
>
>var customers = context.Customers.Where(c => c.State == "NY" && c.City == "New York").OrderBy(c => c.CompanyName);
>
>
>
>>
>>1. I need to display a list of possible selections in a dropdown list, so I want to select all the selections from my table and sort them alphabetically.
>>
>>2. I need to pull out a subset of data based on a couple parameters.