SqlIdentifier.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 / DLinq / Dlinq / SqlClient / Query / SqlIdentifier.cs / 1 / SqlIdentifier.cs
                        

                        
                            using System; 
using System.Collections.Generic;
using System.Data;
using System.Data.Linq.Mapping;
using System.Data.Linq.Provider; 
using System.Data.SqlClient;
using System.Globalization; 
using System.Linq; 
using System.Text;
using System.Text.RegularExpressions; 

namespace System.Data.Linq.SqlClient {

    internal static class SqlIdentifier 
    {
        private static SqlCommandBuilder builder = new SqlCommandBuilder(); 
 
        const string ParameterPrefix = "@";
        const string QuotePrefix = "["; 
        const string QuoteSuffix = "]";
        const string SchemaSeparator = ".";
        const char SchemaSeparatorChar = '.';
 
        private static bool IsQuoted(string s) {
            if (s == null) { 
                throw Error.ArgumentNull("s"); 
            }
 
            if (s.Length < 2) {
                return false;
            }
 
            return s.StartsWith(QuotePrefix, StringComparison.Ordinal)
                && s.EndsWith(QuoteSuffix, StringComparison.Ordinal); 
        } 

        // This is MSSQL-specific quoting. 
        // If the string begins and ends with [ and ], it will be assumed to already be quoted.
        // Otherwise periods are assumed to be namespace delimiters, and the string is split on each.
        // Each string from the split is then check to see if it is already quoted, and if
        // not, it is replaced with the result of SqlCommandBuilder.QuoteIdentifier. 
        // Then the set of strings is rejoined with periods.
        internal static string QuoteCompoundIdentifier(string s) { 
            if (s == null) { 
                throw Error.ArgumentNull("s");
            } 

            // if it starts with @, then return unprocessed
            if (s.StartsWith(ParameterPrefix, StringComparison.Ordinal)) {
                return s; 
            } else if (IsQuoted(s)) {
                return s; 
            } 
            else if (!s.StartsWith(QuotePrefix, StringComparison.Ordinal) && s.EndsWith(QuoteSuffix, StringComparison.Ordinal)) {
                //A.[B] => [A].[B] 
                int splitPosition = s.IndexOf(SchemaSeparatorChar);
                if (splitPosition < 0){ //no . in the string
                    return builder.QuoteIdentifier(s);
                } 
                string left = s.Substring(0, splitPosition);
                string right = s.Substring(splitPosition + 1, s.Length - splitPosition - 1); 
                if (!IsQuoted(right)) { 
                    right = builder.QuoteIdentifier(right);
                } 
                return String.Concat(QuoteCompoundIdentifier(left), SchemaSeparatorChar + right);
            }
            else if (s.StartsWith(QuotePrefix, StringComparison.Ordinal) && !s.EndsWith(QuoteSuffix, StringComparison.Ordinal)) {
                //[A].B => [A].[B] 
                int splitPosition = s.LastIndexOf(SchemaSeparatorChar);
                if (splitPosition < 0){ //no . in the string 
                    return builder.QuoteIdentifier(s); 
                }
                string left = s.Substring(0, splitPosition); 
                if (!IsQuoted(left)) {
                    left = builder.QuoteIdentifier(left);
                }
                string right = s.Substring(splitPosition + 1, s.Length - splitPosition - 1); 
                return String.Concat(left + SchemaSeparatorChar, QuoteCompoundIdentifier(right));
            } 
            else { 
                int splitPosition = s.IndexOf(SchemaSeparatorChar);
                if (splitPosition < 0) { //no . in the string 
                    //A => [A]
                    return builder.QuoteIdentifier(s);
                }
                string left = s.Substring(0, splitPosition); 
                string right = s.Substring(splitPosition + 1, s.Length - splitPosition - 1);
                return String.Concat(QuoteCompoundIdentifier(left) + SchemaSeparatorChar, QuoteCompoundIdentifier(right)); 
            } 
        }
 
        // This is MSSQL-specific quoting.
        // This is the same as above, but it doesn't consider anything compound.
        internal static string QuoteIdentifier(string s) {
            if (s == null) { 
                throw Error.ArgumentNull("s");
            } 
 
            // if it starts with @, then return unprocessed
            if (s.StartsWith(ParameterPrefix, StringComparison.Ordinal)) { 
                return s;
            } else if (IsQuoted(s)) {
                return s;
            } else { 
                return builder.QuoteIdentifier(s);
            } 
        } 

        // turns "[ABC].[PQR].[XYZ]" into {"[ABC]", "[PQR]", "[XYZ]"} 
        internal static IEnumerable GetCompoundIdentifierParts(string s) {
            if (s == null) {
                throw Error.ArgumentNull("s");
            } 

            // can't do this to parameters 
            if (s.StartsWith(ParameterPrefix, StringComparison.Ordinal)) { 
                throw Error.ArgumentWrongValue("s");
            } 

            string quotedS = QuoteCompoundIdentifier(s);
            string pattern = @"^(?\[([^\]]|\]\])*\])(\.(?\[([^\]]|\]\])*\]))*$";
 
            // This pattern matches "."-delimited quoted SQL identifiers. Here's how:
            // 
            // 1. It is wrapped in "^" and "$", which match the begining and end of text, so it will match 
            //    only the entire text and not any sub-part.
            // 2. The group "(?\[([^\]]|\]\])*\])" captures a single quoted segment of the text. 
            //    It's a literal "[" followed by any number of non-"]" characters or "]]" strings, followed
            //    by a literal "]". The "?" bit names the capture so we can refer to it.
            // 3. After the first component, we will allow any number of groups which consist of a literal
            //    "." followed by a component (and the component part is a repeat of the part described in 2). 

            Match m = Regex.Match(quotedS, pattern); 
            if (!m.Success) 
            {
                throw Error.ArgumentWrongValue("s"); 
            }

            foreach (Capture cap in m.Groups["component"].Captures)
            { 
                yield return cap.Value;
            } 
        } 
    }
} 

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
// Copyright (c) Microsoft Corporation. All rights reserved.
using System; 
using System.Collections.Generic;
using System.Data;
using System.Data.Linq.Mapping;
using System.Data.Linq.Provider; 
using System.Data.SqlClient;
using System.Globalization; 
using System.Linq; 
using System.Text;
using System.Text.RegularExpressions; 

namespace System.Data.Linq.SqlClient {

    internal static class SqlIdentifier 
    {
        private static SqlCommandBuilder builder = new SqlCommandBuilder(); 
 
        const string ParameterPrefix = "@";
        const string QuotePrefix = "["; 
        const string QuoteSuffix = "]";
        const string SchemaSeparator = ".";
        const char SchemaSeparatorChar = '.';
 
        private static bool IsQuoted(string s) {
            if (s == null) { 
                throw Error.ArgumentNull("s"); 
            }
 
            if (s.Length < 2) {
                return false;
            }
 
            return s.StartsWith(QuotePrefix, StringComparison.Ordinal)
                && s.EndsWith(QuoteSuffix, StringComparison.Ordinal); 
        } 

        // This is MSSQL-specific quoting. 
        // If the string begins and ends with [ and ], it will be assumed to already be quoted.
        // Otherwise periods are assumed to be namespace delimiters, and the string is split on each.
        // Each string from the split is then check to see if it is already quoted, and if
        // not, it is replaced with the result of SqlCommandBuilder.QuoteIdentifier. 
        // Then the set of strings is rejoined with periods.
        internal static string QuoteCompoundIdentifier(string s) { 
            if (s == null) { 
                throw Error.ArgumentNull("s");
            } 

            // if it starts with @, then return unprocessed
            if (s.StartsWith(ParameterPrefix, StringComparison.Ordinal)) {
                return s; 
            } else if (IsQuoted(s)) {
                return s; 
            } 
            else if (!s.StartsWith(QuotePrefix, StringComparison.Ordinal) && s.EndsWith(QuoteSuffix, StringComparison.Ordinal)) {
                //A.[B] => [A].[B] 
                int splitPosition = s.IndexOf(SchemaSeparatorChar);
                if (splitPosition < 0){ //no . in the string
                    return builder.QuoteIdentifier(s);
                } 
                string left = s.Substring(0, splitPosition);
                string right = s.Substring(splitPosition + 1, s.Length - splitPosition - 1); 
                if (!IsQuoted(right)) { 
                    right = builder.QuoteIdentifier(right);
                } 
                return String.Concat(QuoteCompoundIdentifier(left), SchemaSeparatorChar + right);
            }
            else if (s.StartsWith(QuotePrefix, StringComparison.Ordinal) && !s.EndsWith(QuoteSuffix, StringComparison.Ordinal)) {
                //[A].B => [A].[B] 
                int splitPosition = s.LastIndexOf(SchemaSeparatorChar);
                if (splitPosition < 0){ //no . in the string 
                    return builder.QuoteIdentifier(s); 
                }
                string left = s.Substring(0, splitPosition); 
                if (!IsQuoted(left)) {
                    left = builder.QuoteIdentifier(left);
                }
                string right = s.Substring(splitPosition + 1, s.Length - splitPosition - 1); 
                return String.Concat(left + SchemaSeparatorChar, QuoteCompoundIdentifier(right));
            } 
            else { 
                int splitPosition = s.IndexOf(SchemaSeparatorChar);
                if (splitPosition < 0) { //no . in the string 
                    //A => [A]
                    return builder.QuoteIdentifier(s);
                }
                string left = s.Substring(0, splitPosition); 
                string right = s.Substring(splitPosition + 1, s.Length - splitPosition - 1);
                return String.Concat(QuoteCompoundIdentifier(left) + SchemaSeparatorChar, QuoteCompoundIdentifier(right)); 
            } 
        }
 
        // This is MSSQL-specific quoting.
        // This is the same as above, but it doesn't consider anything compound.
        internal static string QuoteIdentifier(string s) {
            if (s == null) { 
                throw Error.ArgumentNull("s");
            } 
 
            // if it starts with @, then return unprocessed
            if (s.StartsWith(ParameterPrefix, StringComparison.Ordinal)) { 
                return s;
            } else if (IsQuoted(s)) {
                return s;
            } else { 
                return builder.QuoteIdentifier(s);
            } 
        } 

        // turns "[ABC].[PQR].[XYZ]" into {"[ABC]", "[PQR]", "[XYZ]"} 
        internal static IEnumerable GetCompoundIdentifierParts(string s) {
            if (s == null) {
                throw Error.ArgumentNull("s");
            } 

            // can't do this to parameters 
            if (s.StartsWith(ParameterPrefix, StringComparison.Ordinal)) { 
                throw Error.ArgumentWrongValue("s");
            } 

            string quotedS = QuoteCompoundIdentifier(s);
            string pattern = @"^(?\[([^\]]|\]\])*\])(\.(?\[([^\]]|\]\])*\]))*$";
 
            // This pattern matches "."-delimited quoted SQL identifiers. Here's how:
            // 
            // 1. It is wrapped in "^" and "$", which match the begining and end of text, so it will match 
            //    only the entire text and not any sub-part.
            // 2. The group "(?\[([^\]]|\]\])*\])" captures a single quoted segment of the text. 
            //    It's a literal "[" followed by any number of non-"]" characters or "]]" strings, followed
            //    by a literal "]". The "?" bit names the capture so we can refer to it.
            // 3. After the first component, we will allow any number of groups which consist of a literal
            //    "." followed by a component (and the component part is a repeat of the part described in 2). 

            Match m = Regex.Match(quotedS, pattern); 
            if (!m.Success) 
            {
                throw Error.ArgumentWrongValue("s"); 
            }

            foreach (Capture cap in m.Groups["component"].Captures)
            { 
                yield return cap.Value;
            } 
        } 
    }
} 

// File provided for Reference Use Only by Microsoft Corporation (c) 2007.
// Copyright (c) Microsoft Corporation. All rights reserved.
                        

                        

                        
                        

Link Menu

This book is available now!
Buy at Amazon US or
Buy at Amazon UK

• DictionaryEditChange.cs
• StyleCollectionEditor.cs
• WorkflowMarkupSerializationManager.cs
• Material.cs
• TableLayoutPanelDesigner.cs
• SemanticResultKey.cs
• ContextBase.cs
• InstancePersistenceCommand.cs
• HashSetDebugView.cs
• StringOutput.cs
• ZipIOExtraFieldElement.cs
• CanExecuteRoutedEventArgs.cs
• DisplayNameAttribute.cs
• CultureTableRecord.cs
• ContextQuery.cs
• IUnknownConstantAttribute.cs
• SelectionProviderWrapper.cs
• ToolStripDropDown.cs
• VSDExceptions.cs
• WebBrowserNavigatingEventHandler.cs
• GridViewRowCollection.cs
• ValueType.cs
• MSHTMLHost.cs
• SqlProvider.cs
• HttpCacheParams.cs
• XPathNodePointer.cs
• InputEventArgs.cs
• Binding.cs
• DesignerVerb.cs
• Repeater.cs
• OrderedDictionaryStateHelper.cs
• DrawingGroup.cs
• TypeConstant.cs
• StringCollectionEditor.cs
• FormViewAutoFormat.cs
• RemotingServices.cs
• AuthenticationManager.cs
• DynamicExpression.cs
• SymmetricAlgorithm.cs
• SystemInformation.cs
• bindurihelper.cs
• ListItemCollection.cs
• SecurityProtocol.cs
• DependencyPropertyValueSerializer.cs
• WmlPhoneCallAdapter.cs
• TemplateField.cs
• CalendarData.cs
• Vector.cs
• DateTimeConverter.cs
• CodeObject.cs
• Function.cs
• RotateTransform.cs
• Helper.cs
• SortedDictionary.cs
• KeyTime.cs
• DataGridViewColumnDividerDoubleClickEventArgs.cs
• Asn1IntegerConverter.cs
• RichTextBox.cs
• EnumBuilder.cs
• CodeNamespaceImportCollection.cs
• PersonalizationEntry.cs
• bidPrivateBase.cs
• OleDbReferenceCollection.cs
• SortableBindingList.cs
• MimeMultiPart.cs
• TrustLevelCollection.cs
• XmlSchemaAll.cs
• OperationResponse.cs
• SqlFunctionAttribute.cs
• DiscoveryDocumentReference.cs
• SiteMapDataSource.cs
• SqlTriggerAttribute.cs
• TextContainerHelper.cs
• RemoteWebConfigurationHostServer.cs
• TableCellCollection.cs
• EmbeddedObject.cs
• InstanceKey.cs
• SubqueryRules.cs
• WebPartDisplayModeEventArgs.cs
• NamedPermissionSet.cs
• EncoderReplacementFallback.cs
• DataGridViewDataErrorEventArgs.cs
• DesignerDataTable.cs
• WebMessageFormatHelper.cs
• TranslateTransform.cs
• CompressEmulationStream.cs
• IPGlobalProperties.cs
• WebPartDescriptionCollection.cs
• Utils.cs
• AppDomainProtocolHandler.cs
• PropertyBuilder.cs
• WebException.cs
• EastAsianLunisolarCalendar.cs
• HashMembershipCondition.cs
• XPathDocument.cs
• DataGridViewSelectedRowCollection.cs
• PageSettings.cs
• TableRowGroup.cs
• EntityDataSourceChangingEventArgs.cs
• WebServiceHandlerFactory.cs