CODEWITHSUNDEEP
postgresqllinqpad
mpen
mpen

Reputation: 282895

Is it possible to use LinqPad with PostgreSQL?

The comment here says I can use LightSpeed, which I've downloaded and installed. Then I get to this screen:

And I'm not sure what to do. I'm not too familiar with connection strings, first of all. I found this, but... I think "Model assembly" and "Unit of work class" are required. I don't have any DLL's and I'm not working with LightSpeed models, so I'm not sure this is even useful.

The IQ addon Driver works great with my MySQL database. Really easy to set up and use. Are there any drivers that work with PostgreSQL yet? Looks like you can add them by choosing an "*.lpx" file.

Upvotes: 11

Views: 4899

Answers (2)

fknx
fknx

Reputation: 1785

I've developed a dynamic LINQPad driver for PostgreSQL databases. Using it you can query the database without the necessity to define your model first (similar to the IQ or the built in LINQ to SQL driver).

You can find it on GitHub:

https://github.com/fknx/linqpad-postgresql-driver

Upvotes: 7

Joe Albahari
Joe Albahari

Reputation: 30934

The LightSpeed driver is a static driver, meaning that you must first create a model (and hence a typed DataContext) using the LightSpeed tools.

If you just want to query PostgreSQL in LINQ, you need a dynamic LINQPad driver which no-one has written has yet, AFAIK.

Upvotes: 5

Related Questions