TopClause.cs source code in C# .NET

                        Code:
                         / 4.0 / 4.0 / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / DataEntity / System / Data / SqlClient / SqlGen / TopClause.cs / 1305376 / TopClause.cs
                        
                        
                            //---------------------------------------------------------------------- 
// 
//      Copyright (c) Microsoft Corporation.  All rights reserved.
// 
// 
// @owner  [....]
// @backupOwner [....] 
//--------------------------------------------------------------------- 

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  [....]
// @backupOwner [....] 
//--------------------------------------------------------------------- 

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
