Upgrade Azure.Identity dependency to version 1.8.0

[scottaddie]

In v1.8.0 of the Azure Identity library for .NET (Azure.Identity), token caching was added for the ManagedIdentityCredential type. Token lifetime and refreshing is handled automatically. See https://github.com/Azure/azure-sdk-for-net/blob/main/sdk/identity/Azure.Identity/CHANGELOG.md#180-beta1-2022-10-13. Under the hood, MSAL's in-memory cache is used. This dependency upgrade will help mitigate Azure AD throttling issues that occur from calling it too frequently.

For Java customers, this issue has already been addressed as of the latest stable JDBC driver release. See microsoft/mssql-jdbc#1930.

/cc: @David-Engel

[ErikEJ]

@scottaddie So an explicit update to 1.8.0 will also add automagic caching?

[lcheunglci]

Thanks @scottaddie for making the suggestion. I do believe by upgrading this dependency it would also resolve #1900 and we can consider upgrading it in our next release and I'll bring it up to the team and get back to you soon.

[scottaddie]

@scottaddie So an explicit update to 1.8.0 will also add automagic caching?

That's correct, @ErikEJ. Caching is enabled by default. No app code changes are required to use it.

[lcheunglci]

Thanks @scottaddie for the suggestion and Azure Identity 1.8.0 would be included in the 5.2 release.

[scottaddie]

@lcheunglci The following issue should also be resolved with this dependency upgrade: #1495