WCF Data Services with SQL Azure Federation RRS feed

  • Question

  • Is it possible to use WCF Data Services with data stored using SQL Azure Federation?

    Is there an interception point where it would be appropriate to issue the "USE FEDERATION" command to configure the database connection to the correct federation member?

    For instance, assuming the database model used in the SQL Azure Federation Hands-on Lab, where there is an Orders table federated by Customer Id, could I use WCF Data Services to publish a service over the Orders entity and, depending on the value of the Customer property (obtained from the security principal or from the query filter) issue the USE FEDERATION command to connect to the appropriate federation member?

    Fernando Correia
    Tuesday, January 17, 2012 4:32 PM

All replies