public ICollection <DoughTypeDescription> GetAllDoughTypes()
{
SqlDataReader reader = this.ExecuteReader(
@"SELECT Id, Name
FROM DoughTypes");
ICollection <DoughTypeDescription> doughTypes = new List <DoughTypeDescription>();
using (reader)
{
while (reader.Read())
{
int doughTypeId = reader.GetInt32(0);
string doughTypeName = reader.GetString(1);
DoughTypeDescription doughType = new DoughTypeDescription(doughTypeId, doughTypeName);
doughTypes.Add(doughType);
}
}
return(doughTypes);
}
public ICollection <DoughTypeDescription> GetAllDoughTypes()
{
var doughTypes = new Dictionary <int, DoughTypeDescription>();
var reader = this.ExecuteReader(
@"select Id, Name
from DoughTypes");
using (reader)
{
while (reader.Read())
{
int doughTypeId = reader.GetInt32(0);
string doughTypeName = reader.GetString(1);
if (!doughTypes.ContainsKey(doughTypeId))
{
doughTypes[doughTypeId] = new DoughTypeDescription(doughTypeId, doughTypeName);
}
}
}
return(doughTypes.Values);
}
