Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > LLBLGen Pro Runtime Framework> Azure EDCL
 

Pages: 1
LLBLGen Pro Runtime Framework
Azure EDCL
Page:1/1 

  Print all messages in this thread  
Poster Message
obzekt
User



Location:

Joined on:
29-Apr-2004 18:18:59
Posted:
49 posts
# Posted on: 18-Feb-2019 16:36:36.  
Hello. I'm researching the Elastic Database Client Library to use for a multi-tenant app in Azure, and would like to know if there are any known caveats with LLBLGen. Specifically, if it's possible/easy to get the DataAccessAdapter work with the SqlConnections and pooling provided by the Shard Map Manager. Is there any sample code?
Thanks.
  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14449 posts
# Posted on: 18-Feb-2019 20:50:13.  
Are you doing Data-Dependent Routing?
Or just using a ShardManager to get the Shard Location?


  Top
obzekt
User



Location:

Joined on:
29-Apr-2004 18:18:59
Posted:
49 posts
# Posted on: 19-Feb-2019 09:28:14.  
I'm not sure yet. Our sharding pattern initially will be single-tenant, so I guess I could use the Shard Map Manager to get the DB location for a given tenant id. Where 'location' indicates the shard connection string, which I can then provide to an LLBL adapter.

I also assume that the Shard Map Manager would take care of caching these locations for quick access, and I wouldn't worry about changes to the map at runtime.

However, if we later evolve the app to multi-tenant and need to use Data Dependent Routing, would that be an issue with LLBLGen?
  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14449 posts
# Posted on: 19-Feb-2019 18:37:54.  
I haven't tried this before, but theoretically I don't see an issue.

With Data Dependent Routing, I believe you need to derive from the DataAccessAdapter and override CreateNewPhysicalConnection(), so you can call the OpenConnectionForKey() with the designated key to get an open sqlConnection.


  Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.