Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Architecture> Different database with the same Database Schema,llblgen pro v.5.3 with MySQL
 

Pages: 1
Architecture
Different database with the same Database Schema,llblgen pro v.5.3 with MySQL
Page:1/1 

  Print all messages in this thread  
Poster Message
alonsoChen
User



Location:
taiwan
Joined on:
27-Nov-2017 22:19:49
Posted:
30 posts
# Posted on: 02-Dec-2017 09:21:39.  
Using LLBLGen Pro v5.3 Runtime Framework.
Sorry for my mistake:replace firebird embedded with MySQL Server
I have a question about there is a database existed.
Sometimes the new database created by other software with the same schema.
How can I select the specific database?
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37316 posts
# Posted on: 02-Dec-2017 10:04:41.  
On the same server? When you sync the relational model data by using the Sync feature in the designer, and you connect to the server, you're presented with the relational model data and it should show the additional catalogs on the same server as well (if the user account has access to them of course)

Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
alonsoChen
User



Location:
taiwan
Joined on:
27-Nov-2017 22:19:49
Posted:
30 posts
# Posted on: 02-Dec-2017 10:17:33.  
Otis wrote:
On the same server? When you sync the relational model data by using the Sync feature in the designer, and you connect to the server, you're presented with the relational model data and it should show the additional catalogs on the same server as well (if the user account has access to them of course)

Yes,the same server .
Is there any way using the generated code without change from designer?
Like using the "select the database.table ..." t-sql cmd.
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37316 posts
# Posted on: 02-Dec-2017 13:08:23.  
Yes Regular Smiley Just use catalog name overwriting. https://www.llblgen.com/Documentation/5.3/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/Adapter/gencode_dataaccessadapter_adapter.htm#multi-tenancy-support-catalog-specific-persistence-info-sql-server-mysql

You can do this per call (as shown above) or once per application through configuration (in the configuration file (https://www.llblgen.com/Documentation/5.3/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_applicationconfiguration.htm#catalog-name-overwriting-sql-server-mysql) or through the RuntimeConfiguration class (https://www.llblgen.com/Documentation/5.3/LLBLGen%20Pro%20RTF/Using%20the%20generated%20code/gencode_runtimeconfiguration.htm#multi-tenancy-support-catalog-name-overwriting-sql-server-mysql) ). You want to do this per call or once?


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
alonsoChen
User



Location:
taiwan
Joined on:
27-Nov-2017 22:19:49
Posted:
30 posts
# Posted on: 02-Dec-2017 13:57:31.  
Per call .
  Top
Otis
LLBLGen Pro Team



Location:
The Hague, The Netherlands
Joined on:
17-Aug-2003 18:00:36
Posted:
37316 posts
# Posted on: 03-Dec-2017 09:41:40.  
alonsoChen wrote:
Per call .

Then use the per-call overwriting in Adapter, the first link above. There's an example in the docs at the link Regular Smiley


Frans Bouma
LLBLGen Pro / ORM Profiler Lead Developer | Blog | Twitter
 
Top
Pages: 1  


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

Version: 2.1.12172008 Final.