SQL to LINQ converter required, any idea?

开发者_开发知识库We have LINQPad which is great for testing Linq expressions targeting database.

Can any one recommend "free ware" tool, that could help us convert

• "Sql Queries" to LINQ expressions

and why you recommend it?

NOTE: Please keep in mind, we use c#.

As far as tool, Randy Minder's suggestion of Linqer is the only direct tool I've seen.

That being said, the Visual Basic team did a very good series showing how to go from SQL to LINQ. This walks through what it takes to learn how to do the conversion yourself. Converting from VB's LINQ to C# LINQ is very easy (most of the statements are nearly identical in LINQ), so it's a good way to learn how to do this, even for C# developers.

Even if you're using a tool, I'd recommend trying to understand the concepts - tools don't always produce the best code. Knowing how to do this yourself is very valuable.

The only tool I am aware of that will do this is Linqer. It is not free, but can be purchased for under $50 I believe. It has worked very well for me.