LINQ to Dynamics AX (1)

Hi all,

I have began work on a Linq provider to AX and I have made some great progress so far. There are a few great blogs on provider development for SQL server, so I received a ton of concept help from them, and of course added what I know about AX to make them work for Dynamics 2009. Although the concepts may work on version 3 also, I have only tested against 5.

As I said, it's a work in progress. At this point I have a working, read only provider with WHERE capability, but as usual, it uses the Business Connector ONLY. No access is done directly to SQL server.

Building a Linq to Dynamics AX provider should be easy right? After all, it's only implementing IQueryable and IEnumerable on the Object architecture I already developed right? That's what I thought too. It gets a little trickier, but it's not that crazy. By the end of this concept you will have a provider to build from, and that's not bad.

The concept consists of 4 main parts..
1) The Data Access Provider and Access Layer
2) The Query Transalator
3) The Expression Evaluator
4) The Object Class that will marshal the AX data around.


Thanks,