tags:

views:

10364

answers:

3
+25  Q: 

SQL to LINQ Tool

Is there a tool out there which can convert SQL syntax to LINQ syntax? I just want to rewrite basic queries with join, etc, to LINQ. It would save me a lot of time.

Cheers!

+10  A: 

I found this, but I don't know how good it is. http://www.sqltolinq.com/

Nikki9696
For what it does, the tool is what I need right now. The down side, it assigns, t0, t1, etc for my table names, but it did convert my query, and it did catch the distinct clause I used.THANKS!
Chris
But it's not free!!!!! :(((((((((
Ismail
+4  A: 

I know that this isn't what you asked for but LinqPad is a really great tool to teach yourself Linq (and it's free :o). You can get it here.

When time isn't critical, I have been using it for the last week or so instead or a querey window in SQL Server and my Linq skills are getting better and better.

wcm
Thanks, I do use LinqPad, but in this case time is a factor and I need something to do the translation.
Chris
A: 

Linqer does not work properly on anything that might seem complex. It takes less time to use linqpad and figure it out yourself. It seems like a bit of a useless tool for anyone that works with linq every day.

Wilhelm
Can you provide an example of such failure?
Chris
Sorry that was a while ago... As i remember it was a group by that did not really convert nicely. I was probably frustrated because it took me longer to get linqer to give me a result than just sitting with linqpad. Pity I can't be specific. :(
Wilhelm