public List<string> TableNames()
{
if (!IsOpen())
return null;
if ((_tablenames != null) && (_tablenames.Count > 0))
return _tablenames;
DataTable dtTables = _conn.GetSchema("Tables");
if ((dtTables != null) && (dtTables.Rows.Count > 0))
{
_tablenames = new List<string>();
foreach (DataRow row in dtTables.Rows)
{
string name = (row["TABLE_NAME"] as string);
if (name.StartsWith("MSys"))
continue;
_tablenames.Add(name);
}
return _tablenames;
}
return null;
}