public SqlProductsDal() { foreach (var product in Products) { var brandName = Brands.Find(product.BrandId).BrandName; Console.WriteLine(brandName); /*Console.WriteLine( * "{0}: Brand: {1} --- Color: {2} --- Sex:{3} --- Price:{4} --- Type: {5}" * , product.ProductId, product.BrandId, product.ColorId, product.SexId, product.Price, product.ProductTypeId * );*/ } }