public List<StoredProcedure> GetStoredProcedures()
{
var result = new List<StoredProcedure>();
//pull the SPs
DataTable sprocs = null;
using (SqlConnection conn = new SqlConnection(mConnectionString))
{
conn.Open();
sprocs = conn.GetSchema("Procedures");
conn.Close();
}
foreach (DataRow row in sprocs.Rows)
{
string spType = row["ROUTINE_TYPE"].ToString();
var sp = new StoredProcedure();
sp.Name = row["ROUTINE_NAME"].ToString();
if (spType == "PROCEDURE" & !sp.Name.StartsWith("sp_"))
{
sp.SetParameters(GetSPParams(sp.Name));
GetSPMetadata(sp);
result.Add(sp);
}
}
return result;
}
