internal void GetSqlSpInfo() { SqlCommand selectCommand = new SqlCommand("sp_stored_procedures", this.SqlConn); selectCommand.CommandType = CommandType.StoredProcedure; DataSet dataSet = new DataSet(); new SqlDataAdapter(selectCommand).Fill(dataSet, "StoredProcs"); this.m_StoredProcs = new SqlSpInfoArray(); foreach (DataRow row in dataSet.Tables[0].Rows) { SqlSpInfo sqlSpInfo = new SqlSpInfo(this, row); this.m_StoredProcs.Add(sqlSpInfo); } }
public void Reload() { this.m_AllTables = null; this.m_SystemTables = null; this.m_UserTables = null; this.m_Views = null; this.m_StoredProcs = null; }