Multiple Databases -- CS0103 error

Craig

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?

JoeAlbahari

Right-click the WMSJOURNALTABLEs table in the Schema Explorer and choose 'WMSJOURNALTABLEs.Take(100)'. Does that work?

Craig

Yes, sir!