// GET api/values?firstName=f&lastName=l&emailAddress=e&phoneNumber=1 public IEnumerable <spAdamQuery_Result> Get(string firstName, string lastName, string emailAddress, string phoneNumber) { List <spAdamQuery_Result> result = null; using (var dbContext = new AdventureWorks2012Entities()) { result = dbContext.spAdamQuery(firstName, lastName, emailAddress, phoneNumber).ToList(); } return(result); }
// GET api/values/5 public IEnumerable <spAdamQuery_Result> Get(int id) { List <spAdamQuery_Result> result = null; using (var dbContext = new AdventureWorks2012Entities()) { result = dbContext.spAdamQuery("", "", "", "").ToList(); } return(result); }