Select 'star' Views - Read / Write?

Posts   
 
    
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 04-Aug-2008 13:54:48   

A database with a view to a table in another database based on a select 'star' design is read/writable.

Is there a way to map an LLBL entity to that view and have it read/writable?

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 04-Aug-2008 16:08:04   

Whether the view is on a table on the same catalog or on a different catalog is abstracted by the database, i.e LLBLGen Pro will only deal with the view regardless.

As LLBLGen Pro will issue an INSERT INTO statement against the view, so if this works in Query Analyzer for example, then it should work here.

Would you please try to map the specified view to an entity?

An old thread, just for reference: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7530