Multiple Databases -- CS0103 error

My 'Connection' says: LQWAXDBPROD.DABC + DYNAMICS_AX

Using C# Statement(s) my partial code looks like this:

var results = (from a in AX_REALTIME_ADJUSTMENTS //From the DABC DB
.Where(x => x.POSTED == 1)
from j in WMSJOURNALTABLEs //From the DYNAMICS_AX DB
.Where(x => x.UT_AP_VARIANCEJOURNALID = a.JOURNALID)
.DefaultIfEmpty()
select new {
a.INVENTLOCATIONID
}).Dump();
I get the error: "CS0103 The name 'WMSJOURNALTABLEs' does not exist in the current context"

When I open up the list of 'Tables' under the DYNAMICS_AX database, I can see the WMSJOURNALTABLEs is there and it is spelled exactly like I have it in my LINQ statement?

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!