Ok, after some months of development I took a major decision and dropped the Linq data layer from our project. I had to spend to much time creating exotic lambda expressions to do the simplest things. And since I am working in a disconnected environment it all adds an extra hassle connecting the disconnected items back to the datacontext. Deletes weren't working, updates needed a detach every time we wanted to persist entities to the data store, ...

So I went on a crusade for a high performance and easy to extend data access layer. I came out to .NetTiers together with CodeSmith to generate the data layer. It also gives us the possibility to extend it all to our needs.

Goodbye Linq to SQL ... we had a good time together and I learned a lot about lambda expressions but the rest is just a hole in my memory.

BTW, I'm really into Linq to XML since that is a real progress to traversing XML docs.

Development data, c#