How do I get the schema of a stored procedure using Linq to SQL?

Question

Basically I'm trying to get a list of parameters of a stored procedure using Linq to SQL? Is there a way to do this?

+1

AngryHacker 05 dec. '08 at 19:14

2 answers

+2

leppie 05 dec. '08 at 19:20

Amy B · Accepted Answer · 2008-12-05T19:25:52+0000

During development? Just drag the stored procedure onto the LINQ designer surface.

At run time?

You need sql like this:

SELECT *
FROM syscolumns
WHERE id =
(
  SELECT id
  FROM sysobjects
  WHERE Name = @ProcName
)

Which can be called by LinqToSql like this:

var params = 
  db.sysobjects
  .Where(o => o.Name == ProcName)
  .SelectMany(o =>
    db.syscolumns
    .Where(c => c.id == o.id)
  )