示例#1
0
 public Builder WITH(SqlId alias, Builder subQuery)
 {
     return this.WITH("{0} AS ({1})", alias, subQuery);
 }
示例#2
0
 public Builder UPDATE(SqlId id)
 {
     return this.UPDATE("{0}", id);
 }
示例#3
0
        public Builder UPDATE(Builder subQuery)
        {
            var withAlias = new SqlId("subQuery");

            return this.WITH(withAlias, subQuery).UPDATE(withAlias);
        }
示例#4
0
 public Builder FROM(SqlId alias, Builder subQuery)
 {
     return this.FROM("({0}) {1}", subQuery, alias);
 }
示例#5
0
 public Builder SET(SqlId id, object value)
 {
     return this.SET("{0} = {1}", id, value);
 }
示例#6
0
 public Builder DELETE_FROM(SqlId id)
 {
     return this.DELETE_FROM("{0}", id);
 }
示例#7
0
        public Builder DELETE_FROM(Builder subQuery)
        {
            var withAlias = new SqlId("subQuery");

            return this.WITH(withAlias, subQuery).DELETE_FROM(withAlias);
        }
示例#8
0
        public Builder UPDATE(Builder subQuery)
        {
            var withAlias = new SqlId("subQuery");

            return(this.WITH(withAlias, subQuery).UPDATE(withAlias));
        }
示例#9
0
 public Builder SET(SqlId id, object value)
 {
     return(this.SET("{0} = {1}", id, value));
 }
示例#10
0
 public Builder UPDATE(SqlId id)
 {
     return(this.UPDATE("{0}", id));
 }
示例#11
0
        public Builder DELETE_FROM(Builder subQuery)
        {
            var withAlias = new SqlId("subQuery");

            return(this.WITH(withAlias, subQuery).DELETE_FROM(withAlias));
        }
示例#12
0
 public Builder DELETE_FROM(SqlId id)
 {
     return(this.DELETE_FROM("{0}", id));
 }
示例#13
0
 public Builder FROM(SqlId alias, Builder subQuery)
 {
     return(this.FROM("({0}) {1}", subQuery, alias));
 }
示例#14
0
 public Builder WITH(SqlId alias, Builder subQuery)
 {
     return(this.WITH("{0} AS ({1})", alias, subQuery));
 }