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(); }