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#.
views:
574answers:
2
+2
A:
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.
Randy Minder
2010-01-20 18:08:32
Are there any know problems to install linqer on Vista. We are having problems for some reason.
Asad Butt
2010-01-20 18:10:11
I've never tried. I only have it installed on XP. If such a problem exists, there should be something stated about this on their website.
Randy Minder
2010-01-20 18:17:45
+2
A:
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.
Reed Copsey
2010-01-20 18:28:07
Thanks mate, point noted. Reason behind using a tool is to convert already in use large amount of sql queries with LINQ.
Asad Butt
2010-01-20 18:33:37