Is it Possible to call a Stored Procedure using LINQ in LINQPad?

c# linq stored-procedures linqpad
Jeff LaFay picture Jeff LaFay · Nov 10, 2010 · Viewed 13k times · Source

In visual studio you have the nice designer that encapsulates a stored proc with a nifty little method. I totally love LINQPad and use it on a daily basis at work (haven't had a need to open up SQL Studio for my job since I've been using it!) and would like to call stored procs while using it.

I'm afraid I know the answer to my own question but I'm hoping that maybe there's a feature I'm missing or perhaps someone has some black magic they can lend me to make this happen. Btw, I'm using LINQPad 4 if that makes a difference.

Edit
See my answer below.

Answer

Daniel Pryden picture Daniel Pryden · Nov 11, 2010

At least in my copy of LINQPad, stored procedures show up in the database treeview and can be invoked directly.

Here's a screenshot:

Screenshot

Related questions

Group by in LINQ

Let's suppose if we have a class like: class Person { internal int PersonID; internal string car; } I have a list of this class: List<Person> persons; And this list can have multiple instances with same PersonIDs, for example: …

Read More
LINQ query on a DataTable

I'm trying to perform a LINQ query on a DataTable object and bizarrely I am finding that performing such queries on DataTables is not straightforward. For example: var results = from myRow in myDataTable where results.Field("RowNo") == 1 select results; This …

Read More
Join/Where with LINQ and Lambda

I'm having trouble with a query written in LINQ and Lambda. So far, I'm getting a lot of errors here's my code: int id = 1; var query = database.Posts.Join(database.Post_Metas, post => database.Posts.Where(x => x.…

Read More