Enumerate Stored Procedure

zkaram

Hello, I'm wondering if there is a way to list all stored procedure in a database just like doing Mapping.GetTables() or Mapping.GetFunctions()

JoeAlbahari

Stored procedures are not part of the mapping, but you can still list them via Reflection:

typeof (TypedDataContext).GetMethods(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly).Where (m => !m.IsSpecialName)

zkaram

Thanks Joe, That's awesome