If you want to test LLBLGenPro/Npgsql queries with LINQPad, and you really should, you have to follow these steps.
- Install the official LLBLGenPro driver for LINQPad (Add connection, View more drivers..., ...)
- Reference LLBLGenPro generated assemblies (connection configuration), enter proper connection strings and, albeit optional, provide a .config file that contains DBProviderFactiories entry for Npgsql (watch out for version number)
- Once connection is created, add Npgsql NuGet package to query. The version should match the one configured in step #2.
And voila, beautiful interactive queries at your disposal. You can even use ORM Profiler.
Sample Npgsql factory entry:
<!-- PostgreSql -->
<add name="PostgreSql Client Data Provider" invariant="Npgsql" description=".Net Framework Data Provider for PostgreSql" type="Npgsql.NpgsqlFactory, Npgsql, Version=18.104.22.168, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
I’ve uploaded all the sources and slides of my Cxncel presentation to GitHub. Enjoy.