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