100 Tables, Same Schema -> 1 Entity?

Posts   
 
    
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 07-Nov-2007 19:08:54   

We have a 100 or so tables with the exact same schema. The number of tables changes daily.

Is there a way to 'fool' LLBL 2.5 generated code into allowing us to map a single Entity to a table and as needed change the table that it edits runtime? As the number of tables is fluid, we can't generate a project against it continuously.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39908
Joined: 17-Aug-2003
# Posted on: 07-Nov-2007 20:30:38   

Are these tables related to other tables? Because if not, you could manipulate the final query by deriving a class from DataAccessAdapter, and then overriding the OnSaveEntity, OnFetchEntity etc. methods which receive the final query.

Frans Bouma | Lead developer LLBLGen Pro
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 07-Nov-2007 20:49:52   

They are stand alone tables. (Picker info basically for a large enterprise)

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 08-Nov-2007 11:28:12   

I think Frans solution is the best to be done in this case. For other ideas (mainly for read-only lookups), please check the following thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=5528

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39908
Joined: 17-Aug-2003
# Posted on: 08-Nov-2007 18:07:22   
Frans Bouma | Lead developer LLBLGen Pro