"Add New Entities..." Problem

Posts   
 
    
lsberman
User
Posts: 16
Joined: 22-Feb-2006
# Posted on: 21-Mar-2007 16:51:56   

Hi! I'm evaluating LLBLGenPro for purchase but I've run into an major issue. I've tried to "Add New Entities Mapped On Tables From Catalog(s)" but when I do so less than half of the tables in my database are found. What' could be causing this?

JimHugh
User
Posts: 191
Joined: 16-Nov-2005
# Posted on: 21-Mar-2007 17:47:42   

In order for LLBLGen to add entities, the tables must have a primary key.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 21-Mar-2007 17:55:50   

JimHugh wrote:

In order for LLBLGen to add entities, the tables must have a primary key.

That's not the case, Jim simple_smile , you can add entities mapped onto tables without a PK as you can set that later on. Thanks for answering though simple_smile .

What has to be the case though is that the tables are usable, i.e. if a table has a UDT which isn't resolvable (for example on Oracle) the table is ignored.

Frans Bouma | Lead developer LLBLGen Pro
JimHugh
User
Posts: 191
Joined: 16-Nov-2005
# Posted on: 21-Mar-2007 20:27:57   

Thanks for correcting me, sorry about that... wink

lsberman
User
Posts: 16
Joined: 22-Feb-2006
# Posted on: 26-Mar-2007 15:10:25   

What do you mean by a "UDT which isn't resolvable"? I do have a single UDT which is used in each of the missing tables (mystery solved!) but I am using SQL Server 2005 which supports UDTs. Unless I'm misreading your docs I thought you supports UDTs. Is that not correct or am I missing something here?