Mindscape
  • Register
  • Login
  • YOUR CART IS EMPTY
home
Software
  • Developers Toolbox
  • LightSpeed
  • Raygun
  • WPF Elements
  • Web Workbench
  • Metro Elements
  • Silverlight Elements
  • NHibernate Designer
  • Phone Elements
  • WPF Diagrams
  • Simple DB management
  • Visual Tools for SharePoint
Downloads
Store
  • Buy online
  • Purchase order
  • Volume discounts
  • Reseller
  • Software license
  • Contact sales
Blog
Support
About
  • About Us
  • Contact
  • Testimonials
rss
twitter
facebook
LightSpeed Feature comparison Documentation Screencasts Key features Why LightSpeed? Download LightSpeed Designer Licensing LightSpeed Book Change log Testimonials Buy now LINQPad Support

LINQPad Support

Run ad-hoc LINQ queries against LightSpeed from LINQPad

LINQPad is a fantastic tool that allows developers to quickly and easily execute LINQ queries against their database. Now with LINQPad 2.0+, LINQPad supports a plug-in model which means developers can couple the convenience of LINQPad with the power of LightSpeed!

Because the driver uses LightSpeed, you’ll be able to use all the facilities of LightSpeed — for example, to perform Lucene-based full-text search from within LINQPad, or to include or exclude soft-deleted entities from the query.

Where to get LINQPad

If you have not used LINQPad before, you can download it for free at the official LINQPad website here.

Using the LightSpeed driver with LINQPad

To get the LightSpeed driver, just go into LINQPad, click Add Connection in the data sources list, choose View more drivers..., and choose the LightSpeed driver from the list. LINQPad will automatically download and install it. Once this is done, you'll see LightSpeed in the Add Connection dialog. Select LightSpeed and click Next.

Now all you need to do is configure the connection with details of your database and the assembly containing your LightSpeed model. You’ll need to tell LINQPad the following details:

  • What kind of database you’re talking to (SQLite, MySQL, SQL Server, etc.)
  • The connection string for the database
  • The assembly containing the LightSpeed model (your compiled EXE or DLL)
  • The strong-typed unit of work class in that assembly (don’t forget the namespace!)

To save time, you can also use the Infer from Model button to extract this configuration information from your .lsmodel file. (You’ll still need to have built the DLL or EXE though.)

You can also set up LightSpeed context properties such as whether table names in the database are pluralised and whether to quote identifiers in queries. If you’re planning to use LINQPad to do ad hoc inserts and updates, you can also specify the identity method and timestamp strategy.

That’s it! You’re ready to get querying!

Screenshot of configuring LINQPad with LightSpeed

What do you think?

We appreciate any feedback - new features are added based on the feedback of our users, please let us know what you think!

Data Products

  • LightSpeed ORM
  • NHibernate Designer
  • SimpleDB Tools
  • SharePoint Tools

DevOp Tools

  • Raygun

Visual Controls

  • WPF Elements
  • WPF Diagrams
  • Silverlight Elements
  • Phone Elements

Popular Products

  • Web Workbench

    Modern web development for Visual Studio!

  • Mindscape Megapack

    All Mindscape products for one awesome price!

Quick Links

  • Forums
  • Blog
  • Register
  • Login
  • Contact us
  • Twitter
  • Facebook
  • Google+
  • YouTube
  • Linkedin
  • Rss

© Mindscape 2023. Mindscape is a registered trademark of Mindscape Limited.

  • Terms
  • Privacy