public List <ClassicleObject> GetTablesAndViews()
{
var cObjects = new List <ClassicleObject>();
using (var connection = new SqlConnection())
{
connection.ConnectionString = ConnectionString;
using (var command = new SqlCommand())
{
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "sp_tables";
command.Parameters.AddWithValue("@table_qualifier", DatabaseName);
command.Parameters.AddWithValue("@table_owner", DefaultSchema);
using (var adapter = new SqlDataAdapter())
{
adapter.SelectCommand = command;
using (var ds = new DataSet())
{
adapter.Fill(ds);
if (ds.Tables.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
var cObject = new ClassicleObject {
ObjectName = (string)row["TABLE_NAME"]
};
if (cObject.ObjectName.ToLower() == "dtproperties" || cObject.ObjectName.ToLower() == "syscolumns" ||
cObject.ObjectName.ToLower() == "sysdepends" || cObject.ObjectName.ToLower() == "syscomments" ||
cObject.ObjectName.ToLower() == "sysfilegroups" || cObject.ObjectName.ToLower() == "sysfiles" ||
cObject.ObjectName.ToLower() == "sysfiles1" || cObject.ObjectName.ToLower() == "sysforeignkeys" ||
cObject.ObjectName.ToLower() == "sysproperties" || cObject.ObjectName.ToLower() == "sysusers" ||
cObject.ObjectName.ToLower() == "sysconstraints" || cObject.ObjectName.ToLower() == "syssegments" ||
cObject.ObjectName.ToLower() == "sysdiagrams")
{
continue;
}
cObject.IsView = ((string)row["TABLE_TYPE"]).ToLower() == "view";
cObjects.Add(cObject);
}
}
}
}
}
}
return(cObjects);
}
public List <ClassicleObject> GetTablesAndViews()
{
var classicleObjects = new List <ClassicleObject>();
using (var connection = new MySqlConnection(ConnectionString))
{
connection.Open();
using (DataTable tables = connection.GetSchema("Tables"))
{
foreach (DataRow row in tables.Rows.Cast <DataRow>())
{
if (((string)row["TABLE_SCHEMA"]) != DatabaseName)
{
continue;
}
var obj = new ClassicleObject();
obj.IsView = false;
obj.ObjectName = (string)row["TABLE_NAME"];
classicleObjects.Add(obj);
}
}
using (DataTable views = connection.GetSchema("Views"))
{
foreach (DataRow row in views.Rows)
{
if (((string)row["TABLE_SCHEMA"]) != DatabaseName)
{
continue;
}
var obj = new ClassicleObject
{
IsView = true,
ObjectName = (string)row["TABLE_NAME"]
};
classicleObjects.Add(obj);
}
}
}
return(classicleObjects);
}
public List<ClassicleObject> GetTablesAndViews()
{
var classicleObjects = new List<ClassicleObject>();
using (var connection = new SQLiteConnection(ConnectionString))
{
connection.Open();
using (DataTable tables = connection.GetSchema("Tables"))
{
foreach (DataRow row in tables.Rows.Cast<DataRow>().Where(row => ((string)row["TABLE_TYPE"]).ToLower() == "table"))
{
var obj = new ClassicleObject
{
IsView = false,
ObjectName = (string)row["TABLE_NAME"]
};
classicleObjects.Add(obj);
}
}
using (DataTable views = connection.GetSchema("Views"))
{
foreach (DataRow row in views.Rows)
{
var obj = new ClassicleObject
{
IsView = true,
ObjectName = (string)row["TABLE_NAME"]
};
classicleObjects.Add(obj);
}
}
}
return classicleObjects;
}
