Hi Frans,

I know the task is probably not doable. I think in SQL. All the developers I work with think in SQL. I can create complex SQL queries pretty quickly. I can quickly test in Query Analyzer to see where I screwed up. It takes me a very long time to create complex queries in LLBLGen (especially when factoring in testing time). This has been a barrier to wider acceptance within our company.

It would be absolutely amazing if I could type in my SQL query into some kind of magic translation editor and have LLBL create the code. A code translator from SQL to LLBLGenPro.

Just my thoughts.

A similar discussion is found here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=8822

If that would indeed be possible, I definitely would have tried to build one. It is of course doable to some extend but it's so complex as the different SQL constructs and the number of different ways to specify a given query is huge so writing a SQL -> C# parser is very very hard to do. Add to that that the main reason people want this is to get help with converting very complex queries to C# code, and it's IMHO a bit impossible.

So that's why we try to change the thinking of the developer: not thinking in SQL but thinking in entities and filters on entities is what should be done.