public List<Models.EmployeeMeta> GetAllTables2()
{
{
con.Open();
try
{
List<Models.EmployeeMeta> list = new List<Models.EmployeeMeta>();
String query = "select top 100 a.name from sys.tables a;";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var result = new Models.EmployeeMeta();
result.Table_Name = reader.GetString(0);
list.Add(result);
}
return list;
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
}
public List<Models.EmployeeMeta> GetConstraints()
{
{
con.Open();
try
{
List<Models.EmployeeMeta> list = new List<Models.EmployeeMeta>();
String query = "select top 100 CONSTRAINT_NAME, TABLE_NAME from INFORMATION_SCHEMA.TABLE_CONSTRAINTS";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var result = new Models.EmployeeMeta();
result.Constraint_Name = reader.GetString(0);
result.Table_Name = reader.GetString(1);
list.Add(result);
}
return list;
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
}
public List<Models.EmployeeMeta> GetEmployeesMeta2()
{
con.Open();
try
{
List<Models.EmployeeMeta> list = new List<Models.EmployeeMeta>();
String query = "SELECT b.name, a.name FROM sys.columns a JOIN sys.tables b ON a.object_id = b.object_id WHERE b.name LIKE 'CRONUS Sverige AB$Employee'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var result = new Models.EmployeeMeta();
result.Table_Name = reader.GetString(0);
result.Column_Name = reader.GetString(1);
list.Add(result);
}
return list;
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
public List<Models.EmployeeMeta> GetIndexes()
{
con.Open();
try
{
List<Models.EmployeeMeta> list = new List<Models.EmployeeMeta>();
String query = "select top 100 a.object_id, a.name from sys.indexes a where a.name like 'CRONUS%'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var result = new Models.EmployeeMeta();
result.Object_ID = reader.GetInt32(0);
result.Table_Name = reader.GetString(1);
list.Add(result);
}
return list;
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
public List<Models.EmployeeMeta> GetEmployeesMeta()
{
con.Open();
try
{
List<Models.EmployeeMeta> list = new List<Models.EmployeeMeta>();
String query = "SELECT Table_Name, Column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'CRONUS Sverige AB$Employee'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var result = new Models.EmployeeMeta();
result.Table_Name = reader.GetString(0);
result.Column_Name = reader.GetString(1);
list.Add(result);
}
return list;
}
catch (Exception)
{
throw;
}
finally
{
con.Close();
}
}
