public override IEnumerable <IEntity> GetList(Type type, IEnumerable <ICriterion> criteria, params QueryOption[] options) { var queryBuilder = new SqlQueryBuilder <Domain.ContactContactType>(criteria, options, PropertyColumnMappings, GetSubQueryMappings); using (var reader = ExecuteReader(queryBuilder.GenerateQuery(COLUMNS_LIST, "[ContactContactTypes] AS C"), System.Data.CommandType.Text, GenerateParameters(queryBuilder.Parameters))) { var result = new List <Domain.ContactContactType>(); while (reader.Read()) { result.Add(Parse(reader)); } return(result); } }