Code:
/ Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / whidbey / NetFXspW7 / ndp / fx / src / Data / System / Data / SqlClient / TdsParserHelperClasses.cs / 1 / TdsParserHelperClasses.cs
//------------------------------------------------------------------------------ //// Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //----------------------------------------------------------------------------- namespace System.Data.SqlClient { using System; using System.Collections.Generic; using System.Data; using System.Data.Common; using System.Data.ProviderBase; using System.Data.Sql; using System.Data.SqlTypes; using System.Diagnostics; using System.Reflection; using System.Text; using System.Threading; using Microsoft.SqlServer.Server; // for SMI metadata internal enum CallbackType { Read = 0, Write = 1 } internal enum EncryptionOptions { OFF, ON, NOT_SUP, REQ, LOGIN } internal enum PreLoginHandshakeStatus { Successful, SphinxFailure, InstanceFailure } internal enum PreLoginOptions { VERSION, ENCRYPT, INSTANCE, THREADID, MARS, NUMOPT, LASTOPT = 255 } internal enum RunBehavior { UntilDone = 1, // 0001 binary ReturnImmediately = 2, // 0010 binary Clean = 5, // 0101 binary - Clean AND UntilDone Attention = 13 // 1101 binary - Clean AND UntilDone AND Attention } internal enum TdsParserState { Closed, OpenNotLoggedIn, OpenLoggedIn, Broken, } sealed internal class SqlCollation { // First 20 bits of info field represent the lcid, bits 21-25 are compare options private const uint IgnoreCase = 1 << 20; // bit 21 - IgnoreCase private const uint IgnoreNonSpace = 1 << 21; // bit 22 - IgnoreNonSpace / IgnoreAccent private const uint IgnoreWidth = 1 << 22; // bit 23 - IgnoreWidth private const uint IgnoreKanaType = 1 << 23; // bit 24 - IgnoreKanaType private const uint BinarySort = 1 << 24; // bit 25 - BinarySort internal const uint MaskLcid = 0xfffff; private const uint MaskCompareOpt = IgnoreCase|IgnoreNonSpace|IgnoreWidth|IgnoreKanaType|BinarySort; internal uint info; internal byte sortId; internal int LCID { // First 20 bits of info field represent the lcid get { return unchecked((int)(info & MaskLcid)); } set { Debug.Assert((value & MaskLcid) == value, "invalid set_LCID value"); info = ((info & MaskCompareOpt) | (unchecked((uint)value) & MaskLcid)); } } internal SqlCompareOptions SqlCompareOptions { get { SqlCompareOptions options = SqlCompareOptions.None; if (0 != (info & IgnoreCase)) options |= SqlCompareOptions.IgnoreCase; if (0 != (info & IgnoreNonSpace)) options |= SqlCompareOptions.IgnoreNonSpace; if (0 != (info & IgnoreWidth)) options |= SqlCompareOptions.IgnoreWidth; if (0 != (info & IgnoreKanaType)) options |= SqlCompareOptions.IgnoreKanaType; if (0 != (info & BinarySort)) options |= SqlCompareOptions.BinarySort; return options; } set { Debug.Assert((value & SqlString.x_iValidSqlCompareOptionMask) == value, "invalid set_SqlCompareOptions value"); uint tmp = 0; if (0 != (value & SqlCompareOptions.IgnoreCase)) tmp |= IgnoreCase; if (0 != (value & SqlCompareOptions.IgnoreNonSpace)) tmp |= IgnoreNonSpace; if (0 != (value & SqlCompareOptions.IgnoreWidth)) tmp |= IgnoreWidth; if (0 != (value & SqlCompareOptions.IgnoreKanaType)) tmp |= IgnoreKanaType; if (0 != (value & SqlCompareOptions.BinarySort)) tmp |= BinarySort; info = (info & MaskLcid) | tmp; } } internal string TraceString() { return String.Format(/*IFormatProvider*/ null, "(LCID={0}, Opts={1})", this.LCID, (int)this.SqlCompareOptions); } } sealed internal class SqlEnvChange { internal byte type; internal byte oldLength; internal int newLength; // 7206 TDS changes makes this length an int internal int length; internal string newValue; internal string oldValue; internal byte[] newBinValue; internal byte[] oldBinValue; internal long newLongValue; internal long oldLongValue; internal SqlCollation newCollation; internal SqlCollation oldCollation; } sealed internal class SqlLogin { internal int timeout; // login timeout internal bool userInstance = false; // user instance internal string hostName = ""; // client machine name internal string userName = ""; // user id internal string password = ""; // password internal string applicationName = ""; // application name internal string serverName = ""; // server name internal string language = ""; // initial language internal string database = ""; // initial database internal string attachDBFilename = ""; // DB filename to be attached internal string newPassword = ""; // new password for reset password internal bool useReplication = false; // user login for replication internal bool useSSPI = false; // use integrated security internal int packetSize = SqlConnectionString.DEFAULT.Packet_Size; // packet size } sealed internal class SqlLoginAck { internal string programName; internal byte majorVersion; internal byte minorVersion; internal short buildNum; internal bool isVersion8; } sealed internal class _SqlMetaData : SqlMetaDataPriv { internal string column; internal string baseColumn; internal MultiPartTableName multiPartTableName; internal readonly int ordinal; internal byte updatability; // two bit field (0 is read only, 1 is updatable, 2 is updatability unknown) internal byte tableNum; internal bool isDifferentName; internal bool isKey; internal bool isHidden; internal bool isExpression; internal bool isIdentity; internal bool isColumnSet; internal byte op; // for altrow-columns only internal ushort operand; // for altrow-columns only internal _SqlMetaData(int ordinal) : base() { this.ordinal = ordinal; } internal string serverName { get { return multiPartTableName.ServerName; } } internal string catalogName { get { return multiPartTableName.CatalogName; } } internal string schemaName { get { return multiPartTableName.SchemaName; } } internal string tableName { get { return multiPartTableName.TableName; } } internal bool IsNewKatmaiDateTimeType { get { return SqlDbType.Date == type || SqlDbType.Time == type || SqlDbType.DateTime2 == type || SqlDbType.DateTimeOffset == type; } } internal bool IsLargeUdt { get { return type == SqlDbType.Udt && length == Int32.MaxValue; } } } sealed internal class _SqlMetaDataSet { internal ushort id; // for altrow-columns only internal int[] indexMap; internal int visibleColumns; internal DataTable schemaTable; private readonly _SqlMetaData[] metaDataArray; internal _SqlMetaDataSet(int count) { metaDataArray = new _SqlMetaData[count]; for(int i = 0; i < metaDataArray.Length; ++i) { metaDataArray[i] = new _SqlMetaData(i); } } internal int Length { get { return metaDataArray.Length; } } internal _SqlMetaData this [int index] { get { return metaDataArray[index]; } set { Debug.Assert(null == value, "used only by SqlBulkCopy"); metaDataArray[index] = value; } } } sealed internal class _SqlMetaDataSetCollection { private readonly List<_SqlMetaDataSet> altMetaDataSetArray; internal _SqlMetaDataSet metaDataSet; internal _SqlMetaDataSetCollection () { altMetaDataSetArray = new List<_SqlMetaDataSet>(); } internal void Add(_SqlMetaDataSet altMetaDataSet) { altMetaDataSetArray.Add(altMetaDataSet); } internal _SqlMetaDataSet this[int id] { get { foreach (_SqlMetaDataSet altMetaDataSet in altMetaDataSetArray) { if (altMetaDataSet.id == id) { return altMetaDataSet; } } Debug.Assert (false, "Can't match up altMetaDataSet with given id"); return null; } } } internal class SqlMetaDataPriv { internal SqlDbType type; // SqlDbType enum value internal byte tdsType; // underlying tds type internal byte precision = TdsEnums.UNKNOWN_PRECISION_SCALE; // give default of unknown (-1) internal byte scale = TdsEnums.UNKNOWN_PRECISION_SCALE; // give default of unknown (-1) internal int length; internal SqlCollation collation; internal int codePage; internal Encoding encoding; internal bool isNullable; internal bool isMultiValued = false; // UDT specific metadata // server metadata info // additional temporary UDT meta data internal string udtDatabaseName; internal string udtSchemaName; internal string udtTypeName; internal string udtAssemblyQualifiedName; // on demand internal Type udtType; // Xml specific metadata internal string xmlSchemaCollectionDatabase; internal string xmlSchemaCollectionOwningSchema; internal string xmlSchemaCollectionName; internal MetaType metaType; // cached metaType // Structured type-specific metadata internal string structuredTypeDatabaseName; internal string structuredTypeSchemaName; internal string structuredTypeName; internal IListstructuredFields; internal SqlMetaDataPriv() { } } sealed internal class _SqlRPC { internal string rpcName; internal string databaseName; // Used for UDTs internal ushort ProcID; // Used instead of name internal ushort options; internal SqlParameter[] parameters; internal byte[] paramoptions; internal int? recordsAffected; internal int cumulativeRecordsAffected; internal int errorsIndexStart; internal int errorsIndexEnd; internal SqlErrorCollection errors; internal int warningsIndexStart; internal int warningsIndexEnd; internal SqlErrorCollection warnings; } sealed internal class SqlReturnValue : SqlMetaDataPriv { internal ushort parmIndex; //Yukon or later only internal string parameter; internal readonly SqlBuffer value; internal SqlReturnValue() : base() { value = new SqlBuffer(); } } internal struct MultiPartTableName { private string _multipartName; private string _serverName; private string _catalogName; private string _schemaName; private string _tableName; internal MultiPartTableName(string[] parts) { _multipartName = null; _serverName = parts[0]; _catalogName = parts[1]; _schemaName = parts[2]; _tableName = parts[3]; } internal MultiPartTableName(string multipartName) { _multipartName = multipartName; _serverName = null; _catalogName = null; _schemaName = null; _tableName = null; } internal string ServerName { get { ParseMultipartName(); return _serverName; } set { _serverName = value; } } internal string CatalogName { get { ParseMultipartName(); return _catalogName; } set { _catalogName = value; } } internal string SchemaName { get { ParseMultipartName(); return _schemaName; } set { _schemaName = value; } } internal string TableName { get { ParseMultipartName(); return _tableName; } set { _tableName = value; } } private void ParseMultipartName() { if (null != _multipartName) { string[] parts = MultipartIdentifier.ParseMultipartIdentifier(_multipartName, "[\"", "]\"", Res.SQL_TDSParserTableName, false); _serverName = parts[0]; _catalogName = parts[1]; _schemaName = parts[2]; _tableName = parts[3]; _multipartName = null; } } internal static readonly MultiPartTableName Null = new MultiPartTableName(new string[] {null, null, null, null}); } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. //------------------------------------------------------------------------------ // // Copyright (c) Microsoft Corporation. All rights reserved. // //[....] //[....] //----------------------------------------------------------------------------- namespace System.Data.SqlClient { using System; using System.Collections.Generic; using System.Data; using System.Data.Common; using System.Data.ProviderBase; using System.Data.Sql; using System.Data.SqlTypes; using System.Diagnostics; using System.Reflection; using System.Text; using System.Threading; using Microsoft.SqlServer.Server; // for SMI metadata internal enum CallbackType { Read = 0, Write = 1 } internal enum EncryptionOptions { OFF, ON, NOT_SUP, REQ, LOGIN } internal enum PreLoginHandshakeStatus { Successful, SphinxFailure, InstanceFailure } internal enum PreLoginOptions { VERSION, ENCRYPT, INSTANCE, THREADID, MARS, NUMOPT, LASTOPT = 255 } internal enum RunBehavior { UntilDone = 1, // 0001 binary ReturnImmediately = 2, // 0010 binary Clean = 5, // 0101 binary - Clean AND UntilDone Attention = 13 // 1101 binary - Clean AND UntilDone AND Attention } internal enum TdsParserState { Closed, OpenNotLoggedIn, OpenLoggedIn, Broken, } sealed internal class SqlCollation { // First 20 bits of info field represent the lcid, bits 21-25 are compare options private const uint IgnoreCase = 1 << 20; // bit 21 - IgnoreCase private const uint IgnoreNonSpace = 1 << 21; // bit 22 - IgnoreNonSpace / IgnoreAccent private const uint IgnoreWidth = 1 << 22; // bit 23 - IgnoreWidth private const uint IgnoreKanaType = 1 << 23; // bit 24 - IgnoreKanaType private const uint BinarySort = 1 << 24; // bit 25 - BinarySort internal const uint MaskLcid = 0xfffff; private const uint MaskCompareOpt = IgnoreCase|IgnoreNonSpace|IgnoreWidth|IgnoreKanaType|BinarySort; internal uint info; internal byte sortId; internal int LCID { // First 20 bits of info field represent the lcid get { return unchecked((int)(info & MaskLcid)); } set { Debug.Assert((value & MaskLcid) == value, "invalid set_LCID value"); info = ((info & MaskCompareOpt) | (unchecked((uint)value) & MaskLcid)); } } internal SqlCompareOptions SqlCompareOptions { get { SqlCompareOptions options = SqlCompareOptions.None; if (0 != (info & IgnoreCase)) options |= SqlCompareOptions.IgnoreCase; if (0 != (info & IgnoreNonSpace)) options |= SqlCompareOptions.IgnoreNonSpace; if (0 != (info & IgnoreWidth)) options |= SqlCompareOptions.IgnoreWidth; if (0 != (info & IgnoreKanaType)) options |= SqlCompareOptions.IgnoreKanaType; if (0 != (info & BinarySort)) options |= SqlCompareOptions.BinarySort; return options; } set { Debug.Assert((value & SqlString.x_iValidSqlCompareOptionMask) == value, "invalid set_SqlCompareOptions value"); uint tmp = 0; if (0 != (value & SqlCompareOptions.IgnoreCase)) tmp |= IgnoreCase; if (0 != (value & SqlCompareOptions.IgnoreNonSpace)) tmp |= IgnoreNonSpace; if (0 != (value & SqlCompareOptions.IgnoreWidth)) tmp |= IgnoreWidth; if (0 != (value & SqlCompareOptions.IgnoreKanaType)) tmp |= IgnoreKanaType; if (0 != (value & SqlCompareOptions.BinarySort)) tmp |= BinarySort; info = (info & MaskLcid) | tmp; } } internal string TraceString() { return String.Format(/*IFormatProvider*/ null, "(LCID={0}, Opts={1})", this.LCID, (int)this.SqlCompareOptions); } } sealed internal class SqlEnvChange { internal byte type; internal byte oldLength; internal int newLength; // 7206 TDS changes makes this length an int internal int length; internal string newValue; internal string oldValue; internal byte[] newBinValue; internal byte[] oldBinValue; internal long newLongValue; internal long oldLongValue; internal SqlCollation newCollation; internal SqlCollation oldCollation; } sealed internal class SqlLogin { internal int timeout; // login timeout internal bool userInstance = false; // user instance internal string hostName = ""; // client machine name internal string userName = ""; // user id internal string password = ""; // password internal string applicationName = ""; // application name internal string serverName = ""; // server name internal string language = ""; // initial language internal string database = ""; // initial database internal string attachDBFilename = ""; // DB filename to be attached internal string newPassword = ""; // new password for reset password internal bool useReplication = false; // user login for replication internal bool useSSPI = false; // use integrated security internal int packetSize = SqlConnectionString.DEFAULT.Packet_Size; // packet size } sealed internal class SqlLoginAck { internal string programName; internal byte majorVersion; internal byte minorVersion; internal short buildNum; internal bool isVersion8; } sealed internal class _SqlMetaData : SqlMetaDataPriv { internal string column; internal string baseColumn; internal MultiPartTableName multiPartTableName; internal readonly int ordinal; internal byte updatability; // two bit field (0 is read only, 1 is updatable, 2 is updatability unknown) internal byte tableNum; internal bool isDifferentName; internal bool isKey; internal bool isHidden; internal bool isExpression; internal bool isIdentity; internal bool isColumnSet; internal byte op; // for altrow-columns only internal ushort operand; // for altrow-columns only internal _SqlMetaData(int ordinal) : base() { this.ordinal = ordinal; } internal string serverName { get { return multiPartTableName.ServerName; } } internal string catalogName { get { return multiPartTableName.CatalogName; } } internal string schemaName { get { return multiPartTableName.SchemaName; } } internal string tableName { get { return multiPartTableName.TableName; } } internal bool IsNewKatmaiDateTimeType { get { return SqlDbType.Date == type || SqlDbType.Time == type || SqlDbType.DateTime2 == type || SqlDbType.DateTimeOffset == type; } } internal bool IsLargeUdt { get { return type == SqlDbType.Udt && length == Int32.MaxValue; } } } sealed internal class _SqlMetaDataSet { internal ushort id; // for altrow-columns only internal int[] indexMap; internal int visibleColumns; internal DataTable schemaTable; private readonly _SqlMetaData[] metaDataArray; internal _SqlMetaDataSet(int count) { metaDataArray = new _SqlMetaData[count]; for(int i = 0; i < metaDataArray.Length; ++i) { metaDataArray[i] = new _SqlMetaData(i); } } internal int Length { get { return metaDataArray.Length; } } internal _SqlMetaData this [int index] { get { return metaDataArray[index]; } set { Debug.Assert(null == value, "used only by SqlBulkCopy"); metaDataArray[index] = value; } } } sealed internal class _SqlMetaDataSetCollection { private readonly List<_SqlMetaDataSet> altMetaDataSetArray; internal _SqlMetaDataSet metaDataSet; internal _SqlMetaDataSetCollection () { altMetaDataSetArray = new List<_SqlMetaDataSet>(); } internal void Add(_SqlMetaDataSet altMetaDataSet) { altMetaDataSetArray.Add(altMetaDataSet); } internal _SqlMetaDataSet this[int id] { get { foreach (_SqlMetaDataSet altMetaDataSet in altMetaDataSetArray) { if (altMetaDataSet.id == id) { return altMetaDataSet; } } Debug.Assert (false, "Can't match up altMetaDataSet with given id"); return null; } } } internal class SqlMetaDataPriv { internal SqlDbType type; // SqlDbType enum value internal byte tdsType; // underlying tds type internal byte precision = TdsEnums.UNKNOWN_PRECISION_SCALE; // give default of unknown (-1) internal byte scale = TdsEnums.UNKNOWN_PRECISION_SCALE; // give default of unknown (-1) internal int length; internal SqlCollation collation; internal int codePage; internal Encoding encoding; internal bool isNullable; internal bool isMultiValued = false; // UDT specific metadata // server metadata info // additional temporary UDT meta data internal string udtDatabaseName; internal string udtSchemaName; internal string udtTypeName; internal string udtAssemblyQualifiedName; // on demand internal Type udtType; // Xml specific metadata internal string xmlSchemaCollectionDatabase; internal string xmlSchemaCollectionOwningSchema; internal string xmlSchemaCollectionName; internal MetaType metaType; // cached metaType // Structured type-specific metadata internal string structuredTypeDatabaseName; internal string structuredTypeSchemaName; internal string structuredTypeName; internal IListstructuredFields; internal SqlMetaDataPriv() { } } sealed internal class _SqlRPC { internal string rpcName; internal string databaseName; // Used for UDTs internal ushort ProcID; // Used instead of name internal ushort options; internal SqlParameter[] parameters; internal byte[] paramoptions; internal int? recordsAffected; internal int cumulativeRecordsAffected; internal int errorsIndexStart; internal int errorsIndexEnd; internal SqlErrorCollection errors; internal int warningsIndexStart; internal int warningsIndexEnd; internal SqlErrorCollection warnings; } sealed internal class SqlReturnValue : SqlMetaDataPriv { internal ushort parmIndex; //Yukon or later only internal string parameter; internal readonly SqlBuffer value; internal SqlReturnValue() : base() { value = new SqlBuffer(); } } internal struct MultiPartTableName { private string _multipartName; private string _serverName; private string _catalogName; private string _schemaName; private string _tableName; internal MultiPartTableName(string[] parts) { _multipartName = null; _serverName = parts[0]; _catalogName = parts[1]; _schemaName = parts[2]; _tableName = parts[3]; } internal MultiPartTableName(string multipartName) { _multipartName = multipartName; _serverName = null; _catalogName = null; _schemaName = null; _tableName = null; } internal string ServerName { get { ParseMultipartName(); return _serverName; } set { _serverName = value; } } internal string CatalogName { get { ParseMultipartName(); return _catalogName; } set { _catalogName = value; } } internal string SchemaName { get { ParseMultipartName(); return _schemaName; } set { _schemaName = value; } } internal string TableName { get { ParseMultipartName(); return _tableName; } set { _tableName = value; } } private void ParseMultipartName() { if (null != _multipartName) { string[] parts = MultipartIdentifier.ParseMultipartIdentifier(_multipartName, "[\"", "]\"", Res.SQL_TDSParserTableName, false); _serverName = parts[0]; _catalogName = parts[1]; _schemaName = parts[2]; _tableName = parts[3]; _multipartName = null; } } internal static readonly MultiPartTableName Null = new MultiPartTableName(new string[] {null, null, null, null}); } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- CharEntityEncoderFallback.cs
- OdbcException.cs
- ResourcePool.cs
- MarkupExtensionParser.cs
- Span.cs
- XmlDataSource.cs
- ExpressionPrefixAttribute.cs
- NominalTypeEliminator.cs
- InternalControlCollection.cs
- BrushValueSerializer.cs
- SmtpSection.cs
- GenericTextProperties.cs
- HyperLinkStyle.cs
- transactioncontext.cs
- TextSelectionProcessor.cs
- XamlToRtfParser.cs
- ObjectStateEntryDbUpdatableDataRecord.cs
- StreamingContext.cs
- CaseInsensitiveHashCodeProvider.cs
- HostedTcpTransportManager.cs
- Image.cs
- sqlinternaltransaction.cs
- ArcSegment.cs
- FloaterParaClient.cs
- InfocardExtendedInformationCollection.cs
- SmiGettersStream.cs
- SmtpException.cs
- WeakEventManager.cs
- SecurityContextKeyIdentifierClause.cs
- UpdatePanelControlTrigger.cs
- SemaphoreFullException.cs
- DefaultEventAttribute.cs
- StreamInfo.cs
- XmlIlVisitor.cs
- BamlTreeUpdater.cs
- FilterableAttribute.cs
- DependencyObjectType.cs
- AppearanceEditorPart.cs
- ViewBase.cs
- EventWaitHandleSecurity.cs
- CalendarBlackoutDatesCollection.cs
- BaseComponentEditor.cs
- RectKeyFrameCollection.cs
- AppearanceEditorPart.cs
- SQLInt16.cs
- SqlMethods.cs
- AvTrace.cs
- SqlBuilder.cs
- XmlBindingWorker.cs
- GacUtil.cs
- DataGridViewButtonColumn.cs
- SafeRightsManagementHandle.cs
- CellTreeNode.cs
- SoapReflectionImporter.cs
- SQLInt32.cs
- DoubleCollectionConverter.cs
- ImageField.cs
- OdbcDataReader.cs
- GridViewHeaderRowPresenter.cs
- Utils.cs
- ChannelManagerService.cs
- StreamWithDictionary.cs
- CodeCommentStatement.cs
- PathBox.cs
- WebBrowserUriTypeConverter.cs
- FramingDecoders.cs
- invalidudtexception.cs
- RoleGroupCollection.cs
- WebBrowser.cs
- StylusPlugInCollection.cs
- InputLanguage.cs
- XmlConverter.cs
- graph.cs
- Attachment.cs
- InlineCollection.cs
- X509Utils.cs
- XmlSerializationGeneratedCode.cs
- Rijndael.cs
- WorkflowOperationAsyncResult.cs
- DocumentReferenceCollection.cs
- FormsAuthenticationCredentials.cs
- EntityContainer.cs
- PrimitiveXmlSerializers.cs
- UshortList2.cs
- FixedTextBuilder.cs
- CodeEntryPointMethod.cs
- XPathSelectionIterator.cs
- PageParser.cs
- PathSegment.cs
- HelpKeywordAttribute.cs
- SslStream.cs
- InlineObject.cs
- ScriptingProfileServiceSection.cs
- XmlProcessingInstruction.cs
- DataGridSortingEventArgs.cs
- HitTestResult.cs
- ProfileServiceManager.cs
- DescriptionAttribute.cs
- SessionSymmetricMessageSecurityProtocolFactory.cs
- SessionEndingEventArgs.cs