コード例 #1
0
        public string UnionKeyword(SqlUnionType unionType)
        {
            switch (unionType)
            {
            case SqlUnionType.Union:
                return("UNION");

            case SqlUnionType.UnionAll:
                return("UNION ALL");

            case SqlUnionType.Intersect:
                return("INTERSECT");

            case SqlUnionType.IntersectAll:
                return("INTERSECT ALL");

            case SqlUnionType.Except:
                return("EXCEPT");

            case SqlUnionType.ExceptAll:
                return("EXCEPT ALL");

            default:
                throw new NotImplementedException();
            }
        }
コード例 #2
0
 /// <summary>
 /// Gets the union keyword for specified union type.
 /// </summary>
 /// <param name="unionType">Type of the union.</param>
 /// <returns>
 /// Union keyword
 /// </returns>
 /// <exception cref="NotImplementedException"></exception>
 public string UnionKeyword(SqlUnionType unionType)
 {
     return(unionType switch
     {
         SqlUnionType.Union => "UNION",
         SqlUnionType.UnionAll => "UNION ALL",
         _ => throw new NotImplementedException(),
     });
コード例 #3
0
ファイル: SqliteDialect.cs プロジェクト: aTiKhan/Serenity
 /// <summary>
 /// Gets the union keyword for specified union type.
 /// </summary>
 /// <param name="unionType">Type of the union.</param>
 /// <returns>
 /// Union keyword
 /// </returns>
 /// <exception cref="NotImplementedException"></exception>
 public string UnionKeyword(SqlUnionType unionType)
 {
     return(unionType switch
     {
         SqlUnionType.Union => "UNION",
         SqlUnionType.UnionAll => "UNION ALL",
         SqlUnionType.Intersect => "INTERSECT",
         SqlUnionType.Except => "EXCEPT",
         _ => throw new NotImplementedException(),
     });
コード例 #4
0
ファイル: MySqlDialect.cs プロジェクト: yuanqinghua/Serenity
        /// <summary>
        /// Gets the union keyword for specified union type.
        /// </summary>
        /// <param name="unionType">Type of the union.</param>
        /// <returns>
        /// Union keyword
        /// </returns>
        /// <exception cref="System.NotImplementedException"></exception>
        public string UnionKeyword(SqlUnionType unionType)
        {
            switch (unionType)
            {
            case SqlUnionType.Union:
                return("UNION");

            case SqlUnionType.UnionAll:
                return("UNION ALL");

            default:
                throw new NotImplementedException();
            }
        }
コード例 #5
0
ファイル: SqlQuery.cs プロジェクト: ShivkrupaIMS/VaradLife
 public SqlQuery Union(SqlUnionType unionType = SqlUnionType.Union)
 {
     this.unionQuery = this.Clone();
     this.unionQuery.countRecords = false;
     this.unionQuery.parent       = this;
     this.unionQuery.parameters   = null;
     this.unionType        = unionType;
     this.columns          = new List <Column>();
     this.from             = new StringBuilder();
     this.aliasExpressions = null;
     this.aliasWithJoins   = null;
     this.distinct         = false;
     this.having           = null;
     this.groupBy          = null;
     this.orderBy          = null;
     this.forXml           = null;
     this.skip             = 0;
     this.take             = 0;
     this.where            = null;
     this.intoIndex        = -1;
     this.into             = new List <object>();
     return(this);
 }
コード例 #6
0
 public string UnionKeyword(SqlUnionType unionType)
 {
     throw new NotImplementedException();
 }