How to use federation in SQL Azure connection using NHibernate ?
For example I want a federation to split data using CustomerID, and i want to direct all session calls to be directed to a specific federation based on a configurable CustomerID.
In the Cloud Shell, sign in to SQL Database by using the SQLCMD command. Replace <server-name> with your server name, <db-name> with the database name your app uses, and <aad-user-name> and <aad-password> with your Azure AD user's credentials. <identity-name> is the name of the managed identity in Azure AD.
There are two phases to set up Windows Authentication for Azure SQL Managed Instance using Azure Active Directory (Azure AD) and Kerberos. One-time infrastructure setup. Synchronize Active Directory (AD) and Azure AD, if this hasn't already been done. Enable the modern interactive authentication flow, when available.
In this article. Windows Authentication for Azure AD principals on Azure SQL Managed Instance enables customers to move existing services to the cloud while maintaining a seamless user experience and provides the basis for security infrastructure modernization.
Created a blog post which explains in detail how to query federations using NHibernate: Accessing SQL Azure Federations using NHibernate
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With