public ICollection <SizeDescription> GetAllSizes()
{
SqlDataReader reader = this.ExecuteReader(
@"SELECT Id, Name
FROM Sizes");
ICollection <SizeDescription> sizes = new List <SizeDescription>();
using (reader)
{
while (reader.Read())
{
int sizeId = reader.GetInt32(0);
string sizeName = reader.GetString(1);
SizeDescription size = new SizeDescription(sizeId, sizeName);
sizes.Add(size);
}
}
return(sizes);
}
public ICollection <SizeDescription> GetAllSizes()
{
var sizes = new Dictionary <int, SizeDescription>();
var reader = this.ExecuteReader(
@"select Id, Name
from Sizes");
using (reader)
{
while (reader.Read())
{
int sizeId = reader.GetInt32(0);
string sizeName = reader.GetString(1);
if (!sizes.ContainsKey(sizeId))
{
sizes[sizeId] = new SizeDescription(sizeId, sizeName);
}
}
}
return(sizes.Values);
}