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; }