/// <summary>
 /// Fetches the available attributes by product id.
 /// </summary>
 /// <param name="productId">The product id.</param>
 /// <returns></returns>
 public AttributeCollection FetchAvailableAttributesByProductId(int productId)
 {
     IDataReader reader = SPs.FetchAvailableAttributesByProductId(productId).GetReader();
       AttributeCollection attributeCollection = new AttributeCollection();
       attributeCollection.LoadAndCloseReader(reader);
       return attributeCollection;
 }