private CompetitorProductDTO Map(tblCompetitorProducts tbl)
 {
     var dto = new CompetitorProductDTO
                   {
                       MasterId = tbl.id,
                       DateCreated = tbl.IM_DateCreated,
                       DateLastUpdated = tbl.IM_DateLastUpdated,
                       StatusId = tbl.IM_Status,
                       ProductName = tbl.Name,
                       ProductDescription = tbl.Description,
                       CompetitorMasterId = tbl.CompetitorId,
                       BrandMasterId = tbl.BrandId,
                       PackagingMasterId = tbl.PackagingId,
                       ProductTypeMasterId = tbl.ProductTypeId,
                       PackagingTypeMasterId = tbl.PackagingTypeId,
                       FlavourMasterId = tbl.FlavourId
                   };
     return dto;
 }
 /// <summary>
 /// Deprecated Method for adding a new object to the tblCompetitorProducts EntitySet. Consider using the .Add method of the associated ObjectSet&lt;T&gt; property instead.
 /// </summary>
 public void AddTotblCompetitorProducts(tblCompetitorProducts tblCompetitorProducts)
 {
     base.AddObject("tblCompetitorProducts", tblCompetitorProducts);
 }
 /// <summary>
 /// Create a new tblCompetitorProducts object.
 /// </summary>
 /// <param name="id">Initial value of the id property.</param>
 /// <param name="name">Initial value of the Name property.</param>
 /// <param name="competitorId">Initial value of the CompetitorId property.</param>
 /// <param name="brandId">Initial value of the BrandId property.</param>
 /// <param name="flavourId">Initial value of the FlavourId property.</param>
 /// <param name="packagingId">Initial value of the PackagingId property.</param>
 /// <param name="packagingTypeId">Initial value of the PackagingTypeId property.</param>
 /// <param name="productTypeId">Initial value of the ProductTypeId property.</param>
 /// <param name="iM_DateCreated">Initial value of the IM_DateCreated property.</param>
 /// <param name="iM_DateLastUpdated">Initial value of the IM_DateLastUpdated property.</param>
 /// <param name="iM_Status">Initial value of the IM_Status property.</param>
 public static tblCompetitorProducts CreatetblCompetitorProducts(global::System.Guid id, global::System.String name, global::System.Guid competitorId, global::System.Guid brandId, global::System.Guid flavourId, global::System.Guid packagingId, global::System.Guid packagingTypeId, global::System.Guid productTypeId, global::System.DateTime iM_DateCreated, global::System.DateTime iM_DateLastUpdated, global::System.Int32 iM_Status)
 {
     tblCompetitorProducts tblCompetitorProducts = new tblCompetitorProducts();
     tblCompetitorProducts.id = id;
     tblCompetitorProducts.Name = name;
     tblCompetitorProducts.CompetitorId = competitorId;
     tblCompetitorProducts.BrandId = brandId;
     tblCompetitorProducts.FlavourId = flavourId;
     tblCompetitorProducts.PackagingId = packagingId;
     tblCompetitorProducts.PackagingTypeId = packagingTypeId;
     tblCompetitorProducts.ProductTypeId = productTypeId;
     tblCompetitorProducts.IM_DateCreated = iM_DateCreated;
     tblCompetitorProducts.IM_DateLastUpdated = iM_DateLastUpdated;
     tblCompetitorProducts.IM_Status = iM_Status;
     return tblCompetitorProducts;
 }