Execcuting a SQL Query within LinqPad Program - any way to use the Program's data context?

ksecrist · May 2013

I've got a LINQPad program, with various linq queries, etc. If I want to place a SQL query in the midst is there a way to do that and still use the existing data context or do I need to define a SQLConnection and provide my own connection string etc etc.

Sorax · May 2013

Using Nutshell.mdf

var query = @"SELECT * FROM Customer WHERE ID > {0}";
this.ExecuteQuery(typeof(Customer), query, 3).Dump();

ksecrist · May 2013

That is cool - thanks! I could not find ExecuteQuery before you mentioned it - appreciate it.

Sorax · May 2013

No problem. Glad to help!

patku · June 2013

So, just to clarify, when you're using a data context (e.g. OP's case, Entity Framework, etc), `this` is the context itself.

Execcuting a SQL Query within LinqPad Program - any way to use the Program's data context?

Comments