public IEnumerable<DataContracts.IPerson> Search(PersonSearchParameters parameters) { var people = new List<IPerson>(); using (var connection = new SqlConnection(base.ConnectionString)) { using (var command = new SqlCommand("sp_PersonSearch", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@firstName", (object)parameters.FirstName ?? DBNull.Value); command.Parameters.AddWithValue("@middleName", (object)parameters.MiddleName ?? DBNull.Value); command.Parameters.AddWithValue("@lastName", (object)parameters.LastName ?? DBNull.Value); var adapter = new PersonAdapter(); connection.Open(); var reader = command.ExecuteReader(); while (reader.Read()) { people.Add((Person)adapter.Resolve(new Person(), reader)); } } } return people; }
public IEnumerable<DataContracts.IPerson> Search(PersonSearchParameters parameters) { throw new NotImplementedException(); }