Net472_SQL_ADALConnectivity.cs

Net472_SQL_ADALConnectivity.cs

class Program
    {
     static void Test()
      {
        // Instantiate the provider.
           var provider = new ActiveDirectoryAuthProvider();

        // Register the provider to auth methods. This only needs to be done once per process. 
        //This sample shows existing and new keywords. You can use few of these depending on your scenario.
          SqlAuthenticationProvider.SetProvider(SqlAuthenticationMethod.ActiveDirectoryIntegrated, provider);
          SqlAuthenticationProvider.SetProvider(SqlAuthenticationMethod.ActiveDirectoryInteractive, provider);
          SqlAuthenticationProvider.SetProvider(SqlAuthenticationMethod.ActiveDirectoryPassword, provider);
        
        // Start connections.
          using (SqlConnection connection = new SqlConnection("test conn string..."))
              {
                 connection.Open();
        // query
      }
}

// An auth provider implementation that supports all three AD auth methods
class ActiveDirectoryAuthProvider : SqlAuthenticationProvide
{
  private readonly string _clientId = "clientId";
  private readonly Uri _redirectUri = new Uri("redirect uri");
  public override async Task<SqlAuthenticationToken> AcquireTokenAsync(SqlAuthenticationParameters
  parameters)
       {
               AuthenticationContext authContext = new AuthenticationContext(parameters.Authority);
               authContext.CorrelationId = parameters.ConnectionId;
               AuthenticationResult result;
                switch (parameters.AuthenticationMethod)
            {
                 case SqlAuthenticationMethod.ActiveDirectoryInteractive:
                 result = await authContext.AcquireTokenAsync(parameters.Resource, _clientId,
                 _redirectUri, new PlatformParameters(PromptBehavior.Auto), 
                 new UserIdentifier(parameters.UserId, UserIdentifierType.RequiredDisplayableId));
                 break;
                 case SqlAuthenticationMethod.ActiveDirectoryIntegrated:
                 result = await authContext.AcquireTokenAsync(parameters.Resource, _clientId,
                 new UserCredential());
                 break;
                
                  case SqlAuthenticationMethod.ActiveDirectoryPassword:
                  result = await authContext.AcquireTokenAsync(parameters.Resource, _clientId,
                  new UserPasswordCredential(parameters.UserId, parameters.Password));
                  break;
                  default: throw new InvalidOperationException();
                }
                return new SqlAuthenticationToken(result.AccessToken, result.ExpiresOn);
            }
            public override bool IsSupported(SqlAuthenticationMethod authenticationMethod)
            {
                return authenticationMethod == SqlAuthenticationMethod.ActiveDirectoryIntegrated
                    || authenticationMethod == SqlAuthenticationMethod.ActiveDirectoryInteractive
                    || authenticationMethod == SqlAuthenticationMethod.ActiveDirectoryPassword;
            }
        }
    }

SqlAuthenticationProvide should be SqlAuthenticationProvider