Convert SQL to Linq To Objects Expressions at Run Time

Question

Does anyone know of any libraries that can be used to parse an SQL query and create a linq expression that can then be compiled and used against linq for objects?

This approach should work only for simple queries, for complex ones I can write a hard-coded user query

UPDATE: I found something called NQuery that should do the trick for me http://nquery.codeplex.com/ , so don't waste time with your time!

Answer 1

There is a call to the [SqlLinq] project ( https://github.com/dkackman/SqlLinq ) that converts SQL to C # expression trees and evaluates them.