LLBLGen Pro v4.0 LINQPad driver

Rating:        Based on 1 rating
Reviewed:  0 reviews
Downloads: 126
Change Set: 037975ba2f7d
Released: Apr 20, 2013
Updated: Apr 20, 2013 by SolutionsDesign
Dev status: Stable Help Icon

Recommended Download

Application LLBLGenPro_Linqpad_Driver_v4.0_20130420.lpx
application, 417K, uploaded Apr 20, 2013 - 126 downloads

Release Notes

Ready-to-use LINQPad driver for LLBLGen Pro v4.0. Requires LINQPad 2.40/4.40 or higher.

Installation

  • 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.

Usage

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
results.

For Adapter, obtain the adapter from the property 'AdapterToUse'. See the example below:
// Queryspec:
var qf = new QueryFactory();
var results = this.AdapterToUse.FetchQuery(qf.Customer);
results.Dump();

// Low level api:
var managers = new EntityCollection<ManagerEntity>();
this.AdapterToUse.FetchEntityCollection(managers, null);
managers.Dump();

Reviews for this release