Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Azure Federation in NHibernate

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.

like image 337
Mohamed Abed Avatar asked Mar 03 '12 11:03

Mohamed Abed


People also ask

How do I connect to Azure SQL database from C# using Azure AD?

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.

How do I connect to Azure SQL database using Windows authentication?

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.

Does Azure SQL Server support Windows authentication?

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.


1 Answers

Created a blog post which explains in detail how to query federations using NHibernate: Accessing SQL Azure Federations using NHibernate

like image 98
Rohit Gupta Avatar answered Oct 06 '22 06:10

Rohit Gupta