internal void GetSqlTableInfo() { string cmdText = "exec sp_tables"; SqlCommand selectCommand = new SqlCommand(cmdText, this.SqlConn); DataSet dataSet = new DataSet(); new SqlDataAdapter(selectCommand).Fill(dataSet, "Tables"); this.m_AllTables = new SqlTableInfoArray(); this.m_UserTables = new SqlTableInfoArray(); this.m_SystemTables = new SqlTableInfoArray(); this.m_Views = new SqlTableInfoArray(); foreach (DataRow row in dataSet.Tables[0].Rows) { SqlTableInfo sqlTableInfo = new SqlTableInfo(this, row); this.m_AllTables.Add(sqlTableInfo); switch (sqlTableInfo.Type) { case TableType.Table: { this.m_UserTables.Add(sqlTableInfo); continue; } case TableType.SystemTable: { this.m_SystemTables.Add(sqlTableInfo); continue; } case TableType.View: { this.m_Views.Add(sqlTableInfo); continue; } } } }
public void Reload() { this.m_AllTables = null; this.m_SystemTables = null; this.m_UserTables = null; this.m_Views = null; this.m_StoredProcs = null; }