471,354 Members | 1,520 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

SQL to LINQ

Hi,

I wonder, is there some tool that transforms SQL procedures to
LINQ? :-)

I want to use LINQ but I have so much work done in SQL that would be
great to transform my SQL code to LINQ.

Thanks,
Miguel
Jun 27 '08 #1
1 1753
Not an answer to your question, but a question: LINQ will translate what you
throw at it into an expression tree, tree which will be re-evaluated to
produce an SQL statement. That seems slower than using the already known SQL
statement. Why would you want to do that in the first place?

Furthermore, about your question, LINQ does not have concepts for every
thing MS SQL Server exposes through its SQL, neither ( I think, can be
wrong ) can a lambda expression for an expression tree provide some flow
control, at least, not as T-SQL can. I am not even sure an expression tree
can hold more than one SQL 'statement' (such as multi-line stored procedure
which can update, delete, and append rows to multiple tables within its
execution). So the translation tool will be quite limited, no?
Vanderghast, Access MVP
"shapper" <md*****@gmail.comwrote in message
news:1e**********************************@a1g2000h sb.googlegroups.com...
Hi,

I wonder, is there some tool that transforms SQL procedures to
LINQ? :-)

I want to use LINQ but I have so much work done in SQL that would be
great to transform my SQL code to LINQ.

Thanks,
Miguel
Jul 2 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Dave Johnson | last post: by
9 posts views Thread by =?Utf-8?B?cmF1bGF2aQ==?= | last post: by
reply views Thread by =?Utf-8?B?SHlwZXJjb2Rlcg==?= | last post: by
4 posts views Thread by =?Utf-8?B?RXJpYyBGYWxza2Vu?= | last post: by
14 posts views Thread by thj | last post: by
9 posts views Thread by Cirene | last post: by
3 posts views Thread by =?Utf-8?B?UGF1bCBQcmV3ZXR0?= | last post: by
4 posts views Thread by George | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.