How do you generate SQL using LINQ?

Question

I want to be able to take a LINQ statement like this.

var User = from u in Users
           where u.UserID == 7
           select u.UserName;

And have it generate SQL like this.

SELECT UserName FROM Users WHERE Users.UserID = 7

I know LINQ TO SQL does this but I don't want all that added xml mapping and generated code. Obviously this is possible since LINQ TO SQL does it but how does it do it?

Update

Other reason why I don't want to use LINQ to SQL is because I want to use it for PostgreSQL.

Possible duplicate of stackoverflow.com/questions/550826/… — BeemerGuy
– BeemerGuy, Commented Oct 28, 2010 at 2:27
DbLinq is an open-source LINQ provider for PostgreSQL: code.google.com/p/dblinq2007 — Tim Robinson
– Tim Robinson, Commented Oct 28, 2010 at 12:55

BobbyShaftoe · Accepted Answer · 2010-10-28 02:27:04Z

2

So, you should download LinqPad:

http://www.linqpad.net/

This will give you some nice information about what LINQ is doing.

answered Oct 28, 2010 at 2:27

BobbyShaftoe

28.5k7 gold badges56 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ian Mercer · Accepted Answer · 2010-10-28 07:05:49Z

1

You probably want one of the approaches suggested here- http://www.thereforesystems.com/view-query-generate-by-linq-to-sql/

But you could consider instead using Entity Framework with Postgres SQL http://www.devart.com/dotconnect/postgresql/

answered Oct 28, 2010 at 7:05

Ian Mercer

39.4k8 gold badges103 silver badges139 bronze badges

1 Comment

Donny V. Over a year ago

The first one uses LINQ to SQL and the second one is a product. Looking for an open source answer or some steps on how to do it.

Donny V. · Accepted Answer · 2010-11-02 12:42:16Z

1

Right now there doesn't seem to be an open source production ready LINQ to PostgreSQL library. So since this is a new project I'm going to use MongoDB with MongoDB-CSharp as my LINQ driver. It does everything I need it too with the added benefit of not having to worry about schemas and stored procedures.

answered Nov 2, 2010 at 12:42

Donny V.

23.9k13 gold badges69 silver badges81 bronze badges

Comments

Ramesh · Accepted Answer · 2010-12-16 08:17:15Z

0

Try to use Devart LinqConnect - http://www.devart.com/linqconnect/. It supports PostgreSQL and allows you to define flexible templates for sql generation.

edited Dec 16, 2010 at 8:17

answered Dec 13, 2010 at 15:46

Ramesh

1013 bronze badges

Collectives™ on Stack Overflow

How do you generate SQL using LINQ?

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related