Cacher is the code snippet organizer for pro developers

var reader = _cmd.ExReader(@"SELECT * FROM brands;");

if (reader.HasRows)
{
    while (reader.Read())
    {
        var brnd = new BrandsFromDb();
        brnd.BrandId = Convert.ToInt32(reader["id"]);
        brnd.BrandKey = Convert.ToString(reader["brand_key"]);
        brnd.BrandName = Convert.ToString(reader["brand_name"]);
        brnd.ProgramId = Convert.ToInt32(reader["program_id"]);

        lstBrands.Add(brnd);
    }
}
reader.Close();