-
Notifications
You must be signed in to change notification settings - Fork 3
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Use Microsoft.Data.SqlClient to allow Azure Active Directory connections #15
Comments
I forked the repo and updated the dbup-sqlserver project to use Microsoft.Data.SqlClient and this resolved the issue. |
When will the support for Microsoft.Data.SqlClient be added? |
@Hooch180 For one reason or another it seems like PRs are not being accepted here in a timely fashion. You're welcome to use my fork https://github.com/chriswill/DbUpReboot if you need Microsoft.Data.SqlClient support. |
@chriswill, many thanks, just grabbed your 'DbUp.Reboot' package and it works a charm using the newer connection string format for Azure Sql |
@chriswill - Good to see someone out there picking up a reboot for DbUp! Thank you. Let me know if I can help. Thanks for pointing out the new connection string |
@TroyWitthoeft good luck with your project! |
+1 for this request - I'm getting an error after upgrading to .NET 6.0 (which has resulted in having to add Any update from the maintainers would be appreciated. Happy to contribute if there is anything I can do to help?
|
I wonder why this is still open? It seems to work fine now (tested net60 + dbup-sqlserver 5.0.8) |
@osexpert Thank you for the feedback. I will test it in the next days and then close the issue. |
The latest version still does not work for passwordless Managed Identities. Code:
throws an error: The same connection string can be used to connect successfully using the Microsoft.Data.SqlClient. |
Hi everyone. Do you have any updates on it? The package |
@kAleksei The SqlServer provider already uses version |
Resolved by #17 |
Referencing this post.
I want to use a SQL connection string like
Server=myserver.database.windows.net,1433;Database=mydatabase;UID=a;Authentication=Active Directory Interactive
but the app fails with a Keyword not supported: 'authentication' exception. This is because System.Data.SqlClient doesn't understand the new authentication schemes supported in Microsoft.Data.SqlClient that support Sql Azure.
Upgrading to Microsoft.Data.SqlClient is a relatively painless process and would resolve this issue. Would you accept a PR for this?
Note: I applied the overloads to .SqlDatabase suggested in #7 but this did not help.
The text was updated successfully, but these errors were encountered: