public partial class product : EntityObject
  {
    /// <summary>
        /// Нет доступной документации по метаданным.
        /// </summary>
        ///
    
        public global::System.String СName
        {
            get
            {
              int? container_id = this.container_id;

              /*
              var query = (from cont in this.container join measure in this.container.refMeasure on cont.measure_id equals measure.measure_id
                           where cont.container_id == container_id
                           select new { contName = cont.containerName, contCapacity = cont.containerCapacity, measName = measure.measureName }).First();

              */

              //container cnt = (this.container as Manufacture.DB.container);
              using (ManufactureEntities mEntity = new ManufactureEntities())
              {

                var query = (from cont in mEntity.container
                             join measure in mEntity.refMeasure on cont.measure_id equals measure.measure_id
                             where cont.container_id == container_id
                             select new { contName = cont.containerName, contCapacity = cont.containerCapacity, measName = measure.measureName }).First();


                //return query.contName + " " + System.Convert.ToString(query.contCapacity) + " " + query.measName;
                return query.contName + " " + System.Convert.ToString(query.contCapacity) + " " + query.measName;
              }
            }
        }

   
  }