c# sqldatareader to list
List<someObject> objectList = new List<someObject>();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
someObject o = new someObject();
o.id = rdr["id"];
o.name = rdr["name"];
objectList.Add(o);
}