New Posts New Posts RSS Feed: Multi database support in tenanted scenario
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Multi database support in tenanted scenario
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
sarmaad View Drop Down
Newbie
Newbie


Joined: 18-Jul-2010
Location: Sydney
Posts: 15 		Post Options Post Options   Quote sarmaad Quote  Post ReplyReply Direct Link To This Post Topic: Multi database support in tenanted scenario
    Posted: 19-Jul-2010 at 5:26pm
I have two databases.
the first database holds admin records including user authentication details. the second database(s) holds user specific data.

I have two EF Models for each database with the same manager name, tested and working properly. I have implemented (CustomDataSourceKeyResolver) to retrieve connection strings based on the extension keys from admin database.

what I need to achieve is...

1. instantiate the EntityManager without any extensions (since we don't know the user just yet)
2. login and retrieve the user's extension key.
3. re-instantiate the manager with the specific extention..

I have implemented the above, but my question is... is there a better way to do that. since I re-instantiate the manager, I need to re-login the user... also, I don't feel its done right since the client app need to pass the extension key... can we implement this at the server side, rather than the client?

ultimately, i only need to login the user from the client, and the data connection string will be passed to client for the second database...

thoughts...

thanks
Back to Top
GregD View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 374 		Post Options Post Options   Quote GregD Quote  Post ReplyReply Direct Link To This Post Posted: 21-Jul-2010 at 4:42pm
If you use one of the EM constructors that takes another EntityManager, you can avoid the redundant login, as the new EM will use the login credentials of the existing one.

It is the client app that is logging into the EntityService, so the EM needs to be instantiated (with the appropriate extension) client-side.
Back to Top
sarmaad View Drop Down
Newbie
Newbie


Joined: 18-Jul-2010
Location: Sydney
Posts: 15 		Post Options Post Options   Quote sarmaad Quote  Post ReplyReply Direct Link To This Post Posted: 21-Jul-2010 at 5:07pm
I have tried this before...

ok, let see if we have this right... 


var pm = new EntityManager();

if(pm.Login(loginCred))

{

    pm = new EntityManager(pm, true, "UserExtension", EntityServiceOption.UseDefaultService);

    var p = pm.Products.ToList();

}


I received an error "Padding is invalid and cannot be removed." when calling "Products.ToList()"
Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1391 		Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post Posted: 21-Jul-2010 at 5:34pm
The error you're seeing is due to a bug in version 6.0.3.1 with decrypting session bundles from another EnityServer.  There's an EntityServer for every data source extension, so the attempt to use the credentials from the first EntityManager/EntityServer fails with the second EntityManager/EntityServer for the new data source extension.   This problem was fixed in version 6.0.4.0, which should be available for download tomorrow.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down