<value>1</value>

</AlwaysBlock>

<NeverBlock>

<summary>Blocking period OFF forAzure SQL servers,but ON for all other SQL servers.</summary>

<summary>Blocking period OFF forall SQL servers,including Azure SQL servers.</summary>

<value>2</value>

</NeverBlock>

</members>

<membersname="SqlAuthenticationInitializer">

<SqlAuthenticationInitializer>

<summary>

Calledfrom constructors in derived classes to initializethe <seecref="T:Microsoft.Data.SqlClient.SqlAuthenticationInitializer" />class.

Calledduring instantiation ofthefirst<seecref="T:Microsoft.Data.SqlClient.SqlConnection" />instance.

</summary>

</SqlAuthenticationInitializer>

<ctor>

<summary>

DefaultConstructor toinitialize the <seecref="T:Microsoft.Data.SqlClient.SqlAuthenticationInitializer" /> class.

Defaultconstructor toinstantiate the <seecref="T:Microsoft.Data.SqlClient.SqlAuthenticationInitializer" /> class.

</summary>

</ctor>

<Initialize>

<summary>

When overridden in a derived class, initializes the authentication initializer. This method is calledbythe <seecref="M:Microsoft.Data.SqlClient.SqlAuthenticationInitializer.#ctor" /> constructor duringstartup.

When overridden in a derived class, initializes the authentication initializer. This method is calledimmediately afterthe <seecref="M:Microsoft.Data.SqlClient.SqlAuthenticationInitializer.#ctor" /> constructor duringinstantiation of the first <seecref="T:Microsoft.Data.SqlClient.SqlConnection" /> instance.

</summary>

</Initialize>

</members>

<docs>

<membersname="SqlAuthenticationMethod">

<SqlAuthenticationMethod>

<summary>Describes the different SQL authentication methods that can be used by a client connecting to Azure SQL Database. For details, see <seehref="https://docs.microsoft.com/azure/sql-database/sql-database-aad-authentication">Connecting to SQL Database By Using Azure Active Directory Authentication</see>.</summary>

<summary>Describes the different SQL authentication methods that can be used by a client connecting to Azure SQL Database. For details, see <seehref="https://learn.microsoft.com/azure/azure-sql/database/authentication-aad-overview">Use Microsoft Entra Authentication</see>.</summary>

</SqlAuthenticationMethod>

<NotSpecified>

<summary>The authentication method is not specified.</summary>

<value>0</value>

</NotSpecified>

<SqlPassword>

<summary>The authentication methodis Sql Password.</summary>

<summary>The authentication methoduses Sql Password. Use Sql Password to connect to a SQL Database using SQL Server authentication.</summary>

<value>1</value>

</SqlPassword>

<ActiveDirectoryPassword>

<summary>The authentication method uses Active Directory Password. Use Active Directory Password to connect to a SQL Database usingan Azure AD principal name and password.</summary>

<summary>The authentication method uses Active Directory Password. Use Active Directory Password to connect to a SQL Database usinga Microsoft Entra principal name and password.</summary>

<value>2</value>

</ActiveDirectoryPassword>

<ActiveDirectoryIntegrated>

{

public override async Task&lt;SqlAuthenticationToken&gt; AcquireTokenAsync(SqlAuthenticationParameters parameters)

{

stringclientId = "my-client-id";

stringclientName = "My Application Name";

strings_defaultScopeSuffix = "/.default";

string[] scopes =new string[] {parameters.Resource.EndsWith(s_defaultScopeSuffix) ? parameters.Resource : parameters.Resource +s_defaultScopeSuffix };

IPublicClientApplication app = PublicClientApplicationBuilder.Create(clientId)

conststringClientId = "my-client-id";

conststringClientName = "My Application Name";

conststringDefaultScopeSuffix = "/.default";

string[] scopes =[parameters.Resource.EndsWith(DefaultScopeSuffix) ? parameters.Resource : parameters.Resource +DefaultScopeSuffix ];

IPublicClientApplication app = PublicClientApplicationBuilder.Create(ClientId)

.WithAuthority(parameters.Authority)

.WithClientName(clientName)

.WithClientName(ClientName)

.WithRedirectUri("https://login.microsoftonline.com/common/oauth2/nativeclient")

.Build();

AuthenticationResult result = await app.AcquireTokenWithDeviceCode(scopes,

deviceCodeResult => CustomDeviceFlowCallback(deviceCodeResult)).ExecuteAsync();

using CancellationTokenSource connectionTimeoutCancellation = new CancellationTokenSource(TimeSpan.FromSeconds(parameters.ConnectionTimeout));

AuthenticationResult result = await app.AcquireTokenWithDeviceCode(scopes, CustomDeviceFlowCallback)

.ExecuteAsync(connectionTimeoutCancellation.Token);

return new SqlAuthenticationToken(result.AccessToken, result.ExpiresOn);

}

public override bool IsSupported(SqlAuthenticationMethod authenticationMethod) =>

authenticationMethod.Equals(SqlAuthenticationMethod.ActiveDirectoryDeviceCodeFlow);

private Task CustomDeviceFlowCallback(DeviceCodeResult result)

{

Console.WriteLine(result.Message);

return Task.FromResult(0);

return Task.CompletedTask;

}

}

public class Program

{

public static void Main()

</SetProvider>

<BeforeLoad>

<paramname="authenticationMethod">The authentication method.</param>

<summary>This method is called immediately before the provider is added to SQLdrivers registry.</summary>

<summary>This method is called immediately before the provider is added to SQLauthentication provider registry.</summary>

<remarks>

Avoid performing long-waiting tasks in this method, since it can block other threads from accessing the provider registry.

</remarks>

</BeforeLoad>

<BeforeUnload>

<paramname="authenticationMethod">The authentication method.</param>

<summary>This method is called immediately before the provider is removed from the SQLdrivers registry.</summary>

<summary>This method is called immediately before the provider is removed from the SQLauthentication provider registry.</summary>

<remarks>

For example, this method is called when a different provider with the same authentication method overrides this provider in the SQLdrivers registry. Avoid performing long-waiting task in this method, since it can block other threads from accessing the provider registry.

For example, this method is called when a different provider with the same authentication method overrides this provider in the SQLauthentication provider registry. Avoid performing long-waiting task in this method, since it can block other threads from accessing the provider registry.

</remarks>

</BeforeUnload>

<IsSupported>

<docs>

<membersname="SqlAuthenticationToken">

<SqlAuthenticationToken>

<summary>Represents anADauthentication token.</summary>

<summary>Represents an authentication token.</summary>

</SqlAuthenticationToken>

<ctor>

<paramname="accessToken">The access token.</param>

using var connection = new SqlConnection(connString);

connection.Open();

var batch = new SqlBatch(connection);

usingvar batch = new SqlBatch(connection);

const int count = 10;

const string parameterName = "parameter";

batch.BatchCommands.Add(batchCommand);

}

// Optionally Prepare

batch.Prepare();

var results = new List&lt;int&gt;(count);

using (SqlDataReader reader = batch.ExecuteReader())

{

</BatchCommands>

<Commands>

<summary>

The list of commands contained in the batch in a <seecref="T:System.Collections.IList" /> of <seecref="T:Microsoft.Data.SqlClient.SqlBatchCommand" /> objects.

The list of commands contained in the batch in a <seecref="T:System.Collections.Generic.List{Microsoft.Data.SqlClient.SqlBatchCommand}" />.

</summary>

</Commands>

<ExecuteReader>

using var connection = new SqlConnection(connString);

connection.Open();

var batch = new SqlBatch(connection);

usingvar batch = new SqlBatch(connection);

const int count = 10;

const string parameterName = "parameter";

batch.BatchCommands.Add(batchCommand);

}

// Optionally Prepare

batch.Prepare();

var results = new List&lt;int&gt;(count);

using (SqlDataReader reader = batch.ExecuteReader())

{