Devart Forums

Code: Select all

partial class OplHistory {
   public string ModifiedByName { get; set; }
   public string ModifiedBySite { get; set; }
}

Code: Select all

using System.Linq;
using Devart.Data.Oracle;
usig System.Data.Common;

public List<OplHistory> GetWoHistory(long dealNum, long jobNum, long cycleNum) {
      var query = from hist in DB.OplHistories
                  join emp in DB.Employees on hist.ModifyEmpId equals emp.EmployeeId
                  join site in DB.Sites on hist.ModifySiteId equals site.SiteId
                  where hist.DealNumber == dealNum &&
                        hist.JobNumber == jobNum &&
                        hist.CycleNumber == cycleNum
                  select new OplHistory {
                     ModifyColumn = hist.ModifyColumn,
                     OldValue = hist.OldValue,
                     NewValue = hist.NewValue,
                     ModifiedByName = emp.NameFirst + " " + emp.NameLast,
                     ModifiedBySite = site.NameShort
                  };
   return query.ToList();
}

Code: Select all

UnmappedClassMember OplHistory, ModifiedByName. source: Devart.Data.Linq

Code: Select all

at Devart.Data.Linq.Engine.h.a(MemberInitExpression A_0)
   at Devart.Data.Linq.Engine.h.j(Expression A_0)
   at Devart.Data.Linq.Engine.h.d(Expression A_0, Expression A_1)
   at Devart.Data.Linq.Engine.h.b(MethodCallExpression A_0)
   at Devart.Data.Linq.Engine.h.j(Expression A_0)
   at Devart.Data.Linq.Engine.h.i(Expression A_0)
   at Devart.Data.Linq.Engine.do.d(Expression A_0)
   at Devart.Data.Linq.Engine.do.f(Expression A_0)
   at Devart.Data.Linq.Engine.DataQuery`1.h()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at RRD.OnePlace.BLL.CycleBO.GetWoHistory(Int64 dealNum, Int64 jobNum, Int64 cycleNum) in C:\OnePlace\WebSite\RRD.OnePlace.BLL\CycleBO.cs:line 1213
   at RRD.OnePlace.WEB.Popups.WorkOrderHistory.Page_Load(Object sender, EventArgs e) in C:\OnePlace\WebSite\RRD.OnePlace.WEB\Popups\WorkOrderHistory.aspx.cs:line 15
   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
   at RRD.OnePlace.WEB.BasePage.OnLoad(EventArgs e) in C:\OnePlace\WebSite\RRD.OnePlace.WEB\AppClasses\BasePage.cs:line 61
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Code: Select all

public partial class OplHistory_inherited : OplHistory
    {
      public string ModifiedByName { get; set; }
      public string ModifiedBySite { get; set; }
   }

Code: Select all

static List<OplHistory_inherited> GetWoHistory(long jobNum, long cycleNum) {
         var query = from hist in DB.OplHistories
                     join emp in DB.Employees on hist.ModifyEmpId equals emp.EmployeeId
                     where hist.JobNumber == jobNum &&
                           hist.CycleNumber == cycleNum
                     select new OplHistory_inherited {
                        JobNumber = hist.JobNumber, 
                        ModifiedByName = emp.NameFirst + " " + emp.NameLast,
                     };
         return query.ToList();
      }