TopClause.cs source code in C# .NET

                        Code:
                         / Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / Orcas / QFE / ndp / fx / src / DataEntity / System / Data / SqlClient / SqlGen / TopClause.cs / 1 / TopClause.cs
                        
                        
                            //---------------------------------------------------------------------- 
// 
//      Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// 
// @owner  [....], [....]
//--------------------------------------------------------------------- 
 
using System;
using System.Collections.Generic; 
using System.Diagnostics;
using System.Globalization;
using System.IO;
using System.Text; 
using System.Data.SqlClient;
using System.Data.Metadata.Edm; 
using System.Data.Common.CommandTrees; 

namespace System.Data.SqlClient.SqlGen 
{
    /// 
    /// TopClause represents the a TOP expression in a SqlSelectStatement.
    /// It has a count property, which indicates how many TOP rows should be selected and a 
    /// boolen WithTies property.
    ///  
    class TopClause : ISqlFragment 
    {
        ISqlFragment topCount; 
        bool withTies;

        /// 
        /// Do we need to add a WITH_TIES to the top statement 
        /// 
        internal bool WithTies 
        { 
            get { return withTies; }
        } 

        /// 
        /// How many top rows should be selected.
        ///  
        internal ISqlFragment TopCount
        { 
            get { return topCount; } 
        }
 
        /// 
        /// Creates a TopClause with the given topCount and withTies.
        /// 
        ///  
        /// 
        internal TopClause(ISqlFragment topCount, bool withTies) 
        { 
            this.topCount = topCount;
            this.withTies = withTies; 
        }

        /// 
        /// Creates a TopClause with the given topCount and withTies. 
        /// 
        ///  
        ///  
        internal TopClause(int topCount, bool withTies)
        { 
            SqlBuilder sqlBuilder = new SqlBuilder();
            sqlBuilder.Append(topCount.ToString(CultureInfo.InvariantCulture));
            this.topCount = sqlBuilder;
            this.withTies = withTies; 
        }
 
        #region ISqlFragment Members 

        ///  
        /// Write out the TOP part of sql select statement
        /// It basically writes TOP (X) [WITH TIES].
        /// The brackets around X are ommited for Sql8.
        ///  
        /// 
        ///  
        public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator) 
        {
            writer.Write("TOP "); 

            if (sqlGenerator.SqlVersion != SqlVersion.Sql8)
            {
                writer.Write("("); 
            }
 
            this.TopCount.WriteSql(writer, sqlGenerator); 

            if (sqlGenerator.SqlVersion != SqlVersion.Sql8) 
            {
                writer.Write(")");
            }
 
            writer.Write(" ");
 
            if (this.WithTies) 
            {
                writer.Write("WITH TIES "); 
            }
        }

        #endregion 
    }
} 

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
//---------------------------------------------------------------------- 
// 
//      Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// 
// @owner  [....], [....]
//--------------------------------------------------------------------- 
 
using System;
using System.Collections.Generic; 
using System.Diagnostics;
using System.Globalization;
using System.IO;
using System.Text; 
using System.Data.SqlClient;
using System.Data.Metadata.Edm; 
using System.Data.Common.CommandTrees; 

namespace System.Data.SqlClient.SqlGen 
{
    /// 
    /// TopClause represents the a TOP expression in a SqlSelectStatement.
    /// It has a count property, which indicates how many TOP rows should be selected and a 
    /// boolen WithTies property.
    ///  
    class TopClause : ISqlFragment 
    {
        ISqlFragment topCount; 
        bool withTies;

        /// 
        /// Do we need to add a WITH_TIES to the top statement 
        /// 
        internal bool WithTies 
        { 
            get { return withTies; }
        } 

        /// 
        /// How many top rows should be selected.
        ///  
        internal ISqlFragment TopCount
        { 
            get { return topCount; } 
        }
 
        /// 
        /// Creates a TopClause with the given topCount and withTies.
        /// 
        ///  
        /// 
        internal TopClause(ISqlFragment topCount, bool withTies) 
        { 
            this.topCount = topCount;
            this.withTies = withTies; 
        }

        /// 
        /// Creates a TopClause with the given topCount and withTies. 
        /// 
        ///  
        ///  
        internal TopClause(int topCount, bool withTies)
        { 
            SqlBuilder sqlBuilder = new SqlBuilder();
            sqlBuilder.Append(topCount.ToString(CultureInfo.InvariantCulture));
            this.topCount = sqlBuilder;
            this.withTies = withTies; 
        }
 
        #region ISqlFragment Members 

        ///  
        /// Write out the TOP part of sql select statement
        /// It basically writes TOP (X) [WITH TIES].
        /// The brackets around X are ommited for Sql8.
        ///  
        /// 
        ///  
        public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator) 
        {
            writer.Write("TOP "); 

            if (sqlGenerator.SqlVersion != SqlVersion.Sql8)
            {
                writer.Write("("); 
            }
 
            this.TopCount.WriteSql(writer, sqlGenerator); 

            if (sqlGenerator.SqlVersion != SqlVersion.Sql8) 
            {
                writer.Write(")");
            }
 
            writer.Write(" ");
 
            if (this.WithTies) 
            {
                writer.Write("WITH TIES "); 
            }
        }

        #endregion 
    }
} 

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
Link Menu

Network programming in C#, Network Programming in VB.NET, Network Programming in .NET
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
TopClause.cs source code in C# .NET

Source code for the .NET framework in C#

Code:

Link Menu
