Can I add a linq compiler to my project?

Question

I'd like to allow some of our business analysts to write in linq instead of SQL where applicable. Corporate would never go for allowing linqpad to be installed, so where would I start on learning how to allow say simple linq queries or expressions in vs2008 project?

Is there sometype of eval() function for .net that would compile and run a linq expression?

Answer 1

Take a look at this tutorial on dynamically executing code. Its pretty complete, and you could simply restrict use to the Linq namespace and your DAL's, if you wanted. You could also add checks to make sure they're not (for example) performing more than one statement, as well as advanced data visualization.