Multi-tenant in SQL Azure using federation

[Mike]

I'm doing some experiments on using SQL Azure federations to enable muti-tenancy in a web app with Openaccess. The main thing I'm trying to accomplish is making sure to run

string federationCmdText = String.Format(@"USE FEDERATION FED_1 (TenantID={0}) WITH FILTERING=ON, RESET", tenantID);
context.ExecuteNonQuery(federationCmdText);
on every connection, before any subsequent queries on that connection are executed.
How can I accomplish this with Openaccess?

Thanks,
Mike

[Jan Blessenohl]

Hello Mike,
You can set SQL statements that are executed whenever we open a new connection. The list is bound to the backend configuration in your generated context class.

Please add a partial class to your generated context class, override OnDatabaseOpen and add your string to

backendConfiguration.ConnectionPool.InitSQL.Add("...");

Greetings,
Jan Blessenohl
the Telerik team

[Mike]

Worked great thank you. This is what I ended up doing:

public partial class EntitiesModel
    {

        Guid tenantID;

        public EntitiesModel(Guid TenantID)
            : base(connectionStringName, backend, metadataSource)
        {
            this.tenantID = TenantID;
        }

        protected override void OnDatabaseOpen(Telerik.OpenAccess.BackendConfiguration backendConfiguration, Telerik.OpenAccess.Metadata.MetadataContainer metadataContainer)
        {

            string federationCmdText = String.Format(@"USE FEDERATION FED_1 (TenantID='{0}') WITH FILTERING=ON, RESET", tenantID.ToString());
            backendConfiguration.ConnectionPool.InitSQL.Add(federationCmdText);

            base.OnDatabaseOpen(backendConfiguration, metadataContainer);

        }

    }