Full Scale180’s guys called Cloud Ninja released Multi-tenant SQL Azure Federations Sample to CodePlex.
“The Cloud Ninja – SQL Azure Federations Project is a sample demonstrating the use of SQL Azure Federations in creating multi-tenant solutions. SQL Azure Federations can be a useful tool for migrating existing single tenant solutions to multi-tenant cloud solutions, as well as building new multi-tenant internet scale solutions. In this project we demonstrate the migration of an existing solution to SQL Azure Federations and further leveraging SQL Azure Federation features in our multi-tenant solutions,” reads the description.
“The Cloud Ninja Multi-tenant task application makes use of SQL Azure Federations filtered connections in working with tenant data. A connection is opened to a SQL Azure Federations database, the initial connection is opened on the root database. We can then use the “USE FEDERATIONS” statement to route our connection to the correct federation member containing the tenant data, and enable filtering, which will scope our connection to an individual automic unit (unique tenant in our case). We can use the “USE FEDERATIONS” statement to easily route our connection to the root and any federation member as needed.”
can be downloaded over at CodePlex.