private YellowstonePathology.YpiConnect.Contract.Search.SearchResultCollection BuildSearchResultCollection(SqlCommand cmd) { YellowstonePathology.YpiConnect.Contract.Search.SearchResultCollection searchResultCollection = new Contract.Search.SearchResultCollection(); using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr); YellowstonePathology.YpiConnect.Contract.Search.SearchResult searchResult = new Contract.Search.SearchResult(); searchResult.WriteProperties(propertyWriter); searchResultCollection.Add(searchResult); } } } return(searchResultCollection); }
private YellowstonePathology.YpiConnect.Contract.Search.SearchResultCollection BuildSearchResultCollection(SqlCommand cmd) { YellowstonePathology.YpiConnect.Contract.Search.SearchResultCollection searchResultCollection = new Contract.Search.SearchResultCollection(); using (SqlConnection cn = new SqlConnection(YpiConnect.Service.Properties.Settings.Default.ServerSqlConnectionString)) { cn.Open(); cmd.Connection = cn; using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { YellowstonePathology.Business.Domain.Persistence.DataReaderPropertyWriter propertyWriter = new Business.Domain.Persistence.DataReaderPropertyWriter(dr); YellowstonePathology.YpiConnect.Contract.Search.SearchResult searchResult = new Contract.Search.SearchResult(); searchResult.WriteProperties(propertyWriter); searchResultCollection.Add(searchResult); } } } return searchResultCollection; }