Getting Into Epicor Functions, Need Assembly/Service Reference for LINQ Expressions

If you add the table and do

this.Db.UserFile.Where(u => u.DcdUserID == callContextClient.CurrentUserId).Select(x => x.EMailAddress).First()

You will get an error, ignore it, press ok and that should work.

image

Here is Epicor’s Fill Table Generated Code and below my widget expression despite the Designer Error:


I assume the error only happens because the Designer doesn’t see the this.Db variable since its validating only a Partial Class.

image