public string GetViewDefinition(RdbDescriptor db, DbView view)
{
const string sql = "sp_helptext";
var sb = new StringBuilder();
using (var reader = db.ExecuteReader(sql, CommandType.StoredProcedure, CreateParameter(db, "objname", view.Name, DbType.String)))
{
while (reader.Read())
{
sb.Append(reader.GetString(reader.GetOrdinal("Text")));
}
}
return(sb.ToString());
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public IList <DbViewColumn> GetViewColumns(RdbDescriptor db)
{
var sql = _acDomain.Config.SqlServerViewColumnsSelect;
IList <DbViewColumn> list = new List <DbViewColumn>();
using (var reader = db.ExecuteReader(sql, null))
{
while (reader.Read())
{
list.Add(DbViewColumn.Create(db.Database.Id, reader));
}
reader.Close();
return(list);
}
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public IList <DbView> GetDbViews(RdbDescriptor db)
{
var queryString = _acDomain.Config.SqlServerViewsSelect;
var views = new List <DbView>();
using (var reader = db.ExecuteReader(queryString, null))
{
while (reader.Read())
{
views.Add(new DbView(db.Database.Id, reader));
}
reader.Close();
}
return(views);
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public IList <DbTable> GetDbTables(RdbDescriptor db)
{
var sql = _acDomain.Config.SqlServerTablesSelect;
var tables = new List <DbTable>();
using (var reader = db.ExecuteReader(sql, null))
{
while (reader.Read())
{
tables.Add(new DbTable(db.Database.Id, reader));
}
reader.Close();
}
return(tables);
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <param name="sortField"></param>
/// <param name="sortOrder"></param>
/// <returns></returns>
public IList <DbTableSpace> GetTableSpaces(RdbDescriptor db, string sortField, string sortOrder)
{
if (string.IsNullOrEmpty(sortField))
{
sortField = "Rows";
}
if (string.IsNullOrEmpty(sortOrder))
{
sortOrder = "asc";
}
Debug.Assert(sortOrder == "asc" || sortOrder == "desc");
string sql =
@"CREATE TABLE #T
(
Name VARCHAR(255) ,
[Rows] BIGINT ,
Reserved VARCHAR(20) ,
Data VARCHAR(20) ,
IndexSize VARCHAR(20) ,
UnUsed VARCHAR(20)
)
EXEC SP_MSFOREACHTABLE ""INSERT INTO #T EXEC SP_SPACEUSED '?'""
SELECT *
FROM #T
ORDER BY " + sortField + " " + sortOrder +
@" DROP TABLE #T";
var spaces = new List <DbTableSpace>();
using (var reader = db.ExecuteReader(sql, null))
{
while (reader.Read())
{
spaces.Add(DbTableSpace.Create(reader));
}
reader.Close();
}
return(spaces);
}
public string GetViewDefinition(RdbDescriptor db, DbView view)
{
const string sql = "sp_helptext";
var sb = new StringBuilder();
using (var reader = db.ExecuteReader(sql, CommandType.StoredProcedure, CreateParameter(db, "objname", view.Name, DbType.String)))
{
while (reader.Read())
{
sb.Append(reader.GetString(reader.GetOrdinal("Text")));
}
}
return sb.ToString();
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public IList<DbViewColumn> GetViewColumns(RdbDescriptor db)
{
var sql = _acDomain.Config.SqlServerViewColumnsSelect;
IList<DbViewColumn> list = new List<DbViewColumn>();
using (var reader = db.ExecuteReader(sql, null))
{
while (reader.Read())
{
list.Add(DbViewColumn.Create(db.Database.Id, reader));
}
reader.Close();
return list;
}
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <param name="sortField"></param>
/// <param name="sortOrder"></param>
/// <returns></returns>
public IList<DbTableSpace> GetTableSpaces(RdbDescriptor db, string sortField, string sortOrder)
{
if (string.IsNullOrEmpty(sortField))
{
sortField = "Rows";
}
if (string.IsNullOrEmpty(sortOrder))
{
sortOrder = "asc";
}
Debug.Assert(sortOrder == "asc" || sortOrder == "desc");
string sql =
@"CREATE TABLE #T
(
Name VARCHAR(255) ,
[Rows] BIGINT ,
Reserved VARCHAR(20) ,
Data VARCHAR(20) ,
IndexSize VARCHAR(20) ,
UnUsed VARCHAR(20)
)
EXEC SP_MSFOREACHTABLE ""INSERT INTO #T EXEC SP_SPACEUSED '?'""
SELECT *
FROM #T
ORDER BY " + sortField + " " + sortOrder +
@" DROP TABLE #T";
var spaces = new List<DbTableSpace>();
using (var reader = db.ExecuteReader(sql, null))
{
while (reader.Read())
{
spaces.Add(DbTableSpace.Create(reader));
}
reader.Close();
}
return spaces;
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public IList<DbView> GetDbViews(RdbDescriptor db)
{
var queryString = _acDomain.Config.SqlServerViewsSelect;
var views = new List<DbView>();
using (var reader = db.ExecuteReader(queryString, null))
{
while (reader.Read())
{
views.Add(new DbView(db.Database.Id, reader));
}
reader.Close();
}
return views;
}
/// <summary>
///
/// </summary>
/// <param name="db"></param>
/// <returns></returns>
public IList<DbTable> GetDbTables(RdbDescriptor db)
{
var sql = _acDomain.Config.SqlServerTablesSelect;
var tables = new List<DbTable>();
using (var reader = db.ExecuteReader(sql, null))
{
while (reader.Read())
{
tables.Add(new DbTable(db.Database.Id, reader));
}
reader.Close();
}
return tables;
}