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());
}
public bool TryGetDbView(string dbViewId, out DbView dbView)
{
return _acDomain.Rdbs.DbViews.TryGetDbView(this, dbViewId, out dbView);
}
public bool TryGetDbView(string dbViewId, out DbView dbView)
{
return(_acDomain.Rdbs.DbViews.TryGetDbView(this, dbViewId, out dbView));
}
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();
}