Ready-to-use LINQPad driver for LLBLGen Pro
v4.0. Requires LINQPad 2.40/4.40 or higher.
- in LINQPad click 'Add connection'
- on the dialog, click 'View more drivers'
- click 'Browse' and browse to the .lpx file
- click 'Open'. LINQPad will now install the driver properly.
After clicking 'Add connection' in LINQPad, select the 'LLBLGen Pro v4.0 LINQPad driver' from the list under 'Use a typed data context from your own assembly'. This opens the connection specification dialog.
The dialog is straight forward. For connection string, you should either specify a compatible connection string or
an app.config file which contains the connection string, e.g. the one generated with the generated code. If you have ORM Profiler
installed, the option to enable it at the start of the query, is enabled.
Click OK and a new connection is made with the generated code you've chosen. You can start querying right away.
QuerySpec and Low-level API queries
The driver supports QuerySpec and Low-level API queries. To execute them, do the following:
In LINQPad, set the 'language' combo box in the query pane in LINQpad to 'C# Statements' or 'VB.NET statements'.
Specify the query as-is. To see results, use the Dump(); extension method by appending it to the
For Adapter, obtain the adapter from the property 'AdapterToUse'. See the example below:
var qf = new QueryFactory();
var results = this.AdapterToUse.FetchQuery(qf.Customer);
// Low level api:
var managers = new EntityCollection<ManagerEntity>();