public string LanguageID {get; set;}

class MyPage : System.Web.UI.Page
{
   public Dynamicweb.eCommerce.Variants.VariantOptionCollection getVariantOptions(Dynamicweb.eCommerce.Prices.Price price)
   {
       string SQL = "SELECT EcomVariantsOptions.* FROM EcomVariantsOptions ";
       SQL += "INNER JOIN EcomVariantGroups ON EcomVariantGroups.VariantGroupID = EcomVariantsOptions.VariantOptionGroupID ";
       SQL += "WHERE EcomVariantsOptions.VariantOptionLanguageID = '" + price.LanguageID + "' ";
       SQL += "AND EcomVariantsOptions.VariantOptionID = '" + price.UnitID + "' ";
       SQL += "AND EcomVariantGroups.VariantGroupUnit = " + Database.SqlBool(true) + " ";
       SQL += "ORDER BY VariantOptionSortOrder, VariantOptionId";

       return GetVariantOptionCollection(SQL);
   }

   private Dynamicweb.eCommerce.Variants.VariantOptionCollection GetVariantOptionCollection(string sql)
   {
       Dynamicweb.eCommerce.Variants.VariantOptionCollection col = default(Dynamicweb.eCommerce.Variants.VariantOptionCollection);
       string CacheKey = "Variant.Option.Collection." + sql;

       if (HttpContext.Current.Items.Contains(CacheKey))
       {
           col = (Dynamicweb.eCommerce.Variants.VariantOptionCollection)HttpContext.Current.Items[CacheKey];
       }
       else
       {
           col = new Dynamicweb.eCommerce.Variants.VariantOptionCollection();
           col.Load(sql);
           HttpContext.Current.Items.Add(CacheKey, col);
       }
       return col;
   }
}