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.