Skip to content

Instantly share code, notes, and snippets.

@saurabh500
Last active September 1, 2017 16:34
Show Gist options
  • Save saurabh500/011e90da4ac77d879ea74980fa6fcfae to your computer and use it in GitHub Desktop.
Save saurabh500/011e90da4ac77d879ea74980fa6fcfae to your computer and use it in GitHub Desktop.

Azure Specific Features. Feature port needed.

T:System.Data.SqlClient.PoolBlockingPeriod
P:System.Data.SqlClient.SqlConnectionStringBuilder.PoolBlockingPeriod

Federated auth https://github.com/dotnet/corefx/issues/8807

T:System.Data.SqlClient.SqlAuthenticationMethod
P:System.Data.SqlClient.SqlConnection.AccessToken
P:System.Data.SqlClient.SqlConnectionStringBuilder.Authentication

Always Encrypted support for Azure SQL. No ask yet.

P:System.Data.SqlClient.SqlConnection.ColumnEncryptionKeyCacheTtl
P:System.Data.SqlClient.SqlConnection.ColumnEncryptionQueryMetadataCacheEnabled
P:System.Data.SqlClient.SqlConnection.ColumnEncryptionTrustedMasterKeyPaths
T:System.Data.SqlClient.SqlConnectionColumnEncryptionSetting
M:System.Data.SqlClient.SqlConnection.RegisterColumnEncryptionKeyStoreProviders(System.Collections.Generic.IDictionary{System.String,System.Data.SqlClient.SqlColumnEncryptionKeyStoreProvider})
P:System.Data.SqlClient.SqlConnectionStringBuilder.ColumnEncryptionSetting
P:System.Data.SqlClient.SqlParameter.ForceColumnEncryption
T:System.Data.SqlClient.SqlCommandColumnEncryptionSetting
T:System.Data.SqlClient.SqlColumnEncryptionCertificateStoreProvider
T:System.Data.SqlClient.SqlColumnEncryptionCngProvider
T:System.Data.SqlClient.SqlColumnEncryptionCspProvider
T:System.Data.SqlClient.SqlColumnEncryptionKeyStoreProvider
P:System.Data.SqlClient.SqlCommand.ColumnEncryptionSetting
F:System.Data.SqlClient.SqlBulkCopyOptions.AllowEncryptedValueModifications

SqlDependency or Query Notifications https://github.com/dotnet/corefx/issues/8188

T:System.Data.SqlClient.OnChangeEventHandler
T:System.Data.SqlClient.SqlDependency
T:System.Data.SqlClient.SqlNotificationEventArgs
T:System.Data.SqlClient.SqlNotificationInfo
T:System.Data.SqlClient.SqlNotificationSource
T:System.Data.SqlClient.SqlNotificationType
P:System.Data.SqlClient.SqlCommand.Notification
P:System.Data.SqlClient.SqlCommand.NotificationAutoEnlist

SqlConnection.GetSchema https://github.com/dotnet/corefx/issues/19797 dotnet/corefx#19937

T:System.Data.SqlClient.SqlClientMetaDataCollectionNames

SqlCommand old Async operations. No ask yet.

M:System.Data.SqlClient.SqlCommand.BeginExecuteNonQuery
M:System.Data.SqlClient.SqlCommand.BeginExecuteNonQuery(System.AsyncCallback,System.Object)
M:System.Data.SqlClient.SqlCommand.BeginExecuteReader
M:System.Data.SqlClient.SqlCommand.BeginExecuteReader(System.AsyncCallback,System.Object)
M:System.Data.SqlClient.SqlCommand.BeginExecuteReader(System.AsyncCallback,System.Object,System.Data.CommandBehavior)
M:System.Data.SqlClient.SqlCommand.BeginExecuteReader(System.Data.CommandBehavior)
M:System.Data.SqlClient.SqlCommand.BeginExecuteXmlReader
M:System.Data.SqlClient.SqlCommand.BeginExecuteXmlReader(System.AsyncCallback,System.Object)
M:System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(System.IAsyncResult)
M:System.Data.SqlClient.SqlCommand.EndExecuteReader(System.IAsyncResult)
M:System.Data.SqlClient.SqlCommand.EndExecuteXmlReader(System.IAsyncResult)

Ambient Transactions support https://github.com/dotnet/corefx/issues/12534

M:System.Data.SqlClient.SqlConnection.EnlistDistributedTransaction(System.EnterpriseServices.ITransaction)
P:System.Data.SqlClient.SqlConnectionStringBuilder.Enlist
P:System.Data.SqlClient.SqlConnectionStringBuilder.TransactionBinding

SqlParameter Misc

M:System.Data.SqlClient.SqlParameter.#ctor(System.String,System.Data.SqlDbType,System.Int32,System.Data.ParameterDirection,System.Boolean,System.Byte,System.Byte,System.String,System.Data.DataRowVersion,System.Object)
M:System.Data.SqlClient.SqlParameter.#ctor(System.String,System.Data.SqlDbType,System.Int32,System.Data.ParameterDirection,System.Byte,System.Byte,System.String,System.Data.DataRowVersion,System.Boolean,System.Object,System.String,System.String,System.String)
P:System.Data.SqlClient.SqlParameter.UdtTypeName

Not added yet. Tacked https://github.com/dotnet/corefx/issues/5501

T:System.Data.SqlClient.SqlCommandBuilder

M:System.Data.SqlClient.SqlBulkCopyColumnMappingCollection.Clear
M:System.Data.SqlClient.SqlBulkCopyColumnMappingCollection.RemoveAt(System.Int32)
M:System.Data.SqlClient.SqlClientFactory.System#IServiceProvider#GetService(System.Type)
  No plan to bring this in.

M:System.Data.SqlClient.SqlCommand.ResetCommandTimeout
  
M:System.Data.SqlClient.SqlConnection.#ctor(System.String,System.Data.SqlClient.SqlCredential)
  Support wasn't added. I think it was missing due to missing SecureString. 
P:System.Data.SqlClient.SqlConnection.Credential
  Support wasn't added. I think it was missing due to missing SecureString. 
M:System.Data.SqlClient.SqlConnection.ChangePassword(System.String,System.Data.SqlClient.SqlCredential,System.Security.SecureString)
  Support wasn't added. I think it was missing due to missing SecureString. 
M:System.Data.SqlClient.SqlConnection.ChangePassword(System.String,System.String)
  Support wasn't added. I think it was missing due to missing SecureString. 
 
P:System.Data.SqlClient.SqlConnectionStringBuilder.AsynchronousProcessing
  Not brought back yet

  
P:System.Data.SqlClient.SqlConnectionStringBuilder.ConnectionReset
  Not added
P:System.Data.SqlClient.SqlConnectionStringBuilder.ContextConnection
  Not Added
P:System.Data.SqlClient.SqlConnectionStringBuilder.NetworkLibrary
  Not added. This is a no-op kind of attribute now.

  
P:System.Data.SqlClient.SqlConnectionStringBuilder.TransparentNetworkIPResolution
  Connection feature. Algo change for SqlClient
T:System.Data.SqlClient.SqlCredential
  Not added back
M:System.Data.SqlClient.SqlDataReader.IsCommandBehavior(System.Data.CommandBehavior)
  Not Added
M:System.Data.SqlClient.SqlDataReader.System#Data#IDataRecord#GetData(System.Int32)
  Not Added
T:System.Data.SqlClient.SQLDebugging
  Based on MSDN, this class shouldn't be used by applications. https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldebugging(v=vs.110).aspx


M:System.Data.SqlClient.SqlParameterCollection.Add(System.String,System.Object)
  Obsolete according to MSDN https://msdn.microsoft.com/en-us/library/9dd8zze1(v=vs.110).aspx
M:System.Data.SqlClient.SqlParameterCollection.Add(System.String,System.Data.SqlDbType,System.Int32,System.String)
  
P:System.Data.SqlClient.SqlClientFactory.CanCreateDataSourceEnumerator
M:System.Data.SqlClient.SqlClientFactory.CreateCommandBuilder
M:System.Data.SqlClient.SqlClientFactory.CreateDataSourceEnumerator
M:System.Data.SqlClient.SqlClientFactory.CreatePermission(System.Security.Permissions.PermissionState)
M:System.Data.SqlClient.SqlClientPermission.Add(System.String,System.String,System.Data.KeyRestrictionBehavior)
M:System.Data.SqlClient.SqlClientPermission.Copy
M:System.Data.SqlClient.SqlClientPermissionAttribute.CreatePermission
M:System.Data.SqlClient.SqlColumnEncryptionCertificateStoreProvider.DecryptColumnEncryptionKey(System.String,System.String,System.Byte[])
M:System.Data.SqlClient.SqlColumnEncryptionCertificateStoreProvider.EncryptColumnEncryptionKey(System.String,System.String,System.Byte[])
M:System.Data.SqlClient.SqlColumnEncryptionCngProvider.DecryptColumnEncryptionKey(System.String,System.String,System.Byte[])
M:System.Data.SqlClient.SqlColumnEncryptionCngProvider.EncryptColumnEncryptionKey(System.String,System.String,System.Byte[])
M:System.Data.SqlClient.SqlColumnEncryptionCspProvider.DecryptColumnEncryptionKey(System.String,System.String,System.Byte[])
M:System.Data.SqlClient.SqlColumnEncryptionCspProvider.EncryptColumnEncryptionKey(System.String,System.String,System.Byte[])
P:System.Data.SqlClient.SqlCommandBuilder.CatalogLocation
P:System.Data.SqlClient.SqlCommandBuilder.CatalogSeparator
P:System.Data.SqlClient.SqlCommandBuilder.QuotePrefix
P:System.Data.SqlClient.SqlCommandBuilder.QuoteSuffix
P:System.Data.SqlClient.SqlCommandBuilder.SchemaSeparator
M:System.Data.SqlClient.SqlCommandBuilder.QuoteIdentifier(System.String)
M:System.Data.SqlClient.SqlCommandBuilder.UnquoteIdentifier(System.String)
M:System.Data.SqlClient.SqlConnection.GetSchema
M:System.Data.SqlClient.SqlConnection.GetSchema(System.String)
M:System.Data.SqlClient.SqlConnection.GetSchema(System.String,System.String[])
P:System.Data.SqlClient.SqlConnectionStringBuilder.IsFixedSize
P:System.Data.SqlClient.SqlDataAdapter.UpdateBatchSize
M:System.Data.SqlClient.SqlDataReader.Close
M:System.Data.SqlClient.SqlDataReader.GetSchemaTable
@evil-shrike
Copy link

Please add SqlFileStream, it's aslso missing in .NET Core

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment