public static List<Person> GetByUserId(Guid userId) { List<Person> personList = new List<Person>(); using (ObjectConnection objectConnection = new ObjectConnection()) { using (GetPersonByUserIdCommand objectCommand = new GetPersonByUserIdCommand(objectConnection)) { objectCommand.UserId = userId; objectConnection.Open(); using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader()) { if (!sqlDataReader.HasRows) { return personList; } using (PersonSqlDataReader objectSqlDataReader = new PersonSqlDataReader(sqlDataReader)) { while (objectSqlDataReader.Read()) { Person person = objectSqlDataReader.Person; personList.Add(person); } } } } } return personList; }
public static Person GetByPersonId(Guid personId) { Person person = new Person(); using (ObjectConnection objectConnection = new ObjectConnection()) { using (GetPersonByPersonIdCommand objectCommand = new GetPersonByPersonIdCommand(objectConnection)) { objectCommand.PersonId = personId; objectConnection.Open(); using (SqlDataReader sqlDataReader = objectCommand.ExecuteReader()) { if (!sqlDataReader.HasRows) { return person; } using (PersonSqlDataReader objectSqlDataReader = new PersonSqlDataReader(sqlDataReader)) { while (objectSqlDataReader.Read()) { person = objectSqlDataReader.Person; } } } } } return person; }