entity - typedview relation

Posts   
 
    
Mates
User
Posts: 2
Joined: 28-Feb-2005
# Posted on: 28-Feb-2005 11:13:31   

Hello,

I would like to ask, if there is a possibility to create relation between entity and typed view.

I mean to do something like: filter.Relations.Add(OrderEntity.Relations.CustomerEntityUsingCustomerID);

but join typedView instead of other entity

Thank you for hints

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 28-Feb-2005 11:39:17   

entities based on views will be added in 1.0.2004.2, which goes beta (hopefully) this week.

Frans Bouma | Lead developer LLBLGen Pro
Mates
User
Posts: 2
Joined: 28-Feb-2005
# Posted on: 28-Feb-2005 11:44:28   

Thank you for quick response.

Fishy avatar
Fishy
User
Posts: 392
Joined: 15-Apr-2004
# Posted on: 28-Feb-2005 19:47:54   

Otis wrote:

entities based on views will be added in 1.0.2004.2, which goes beta (hopefully) this week.

Will it support updating the underlying data in the view if the view allows it?

Thanks,

Fishy

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 28-Feb-2005 20:17:10   

Fishy wrote:

Otis wrote:

entities based on views will be added in 1.0.2004.2, which goes beta (hopefully) this week.

Will it support updating the underlying data in the view if the view allows it?

Thanks,

Fishy

Full support, if the db doesn't support it, you'll see that at runtime when you call Save(). I can't check if a save will work or not, as for example Sqlserver and oracle save single table rows only in a multi-row view.

Frans Bouma | Lead developer LLBLGen Pro
Posts: 134
Joined: 04-Mar-2005
# Posted on: 05-Apr-2005 17:21:29   

Do you have any update on the full release of 1.0.2004.2? I would also like to create relationships between views and tables, which means, reading into your previous replies, that I need to create an entity based on a view, rather than a table?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 05-Apr-2005 17:57:51   

ChicagoKiwi wrote:

Do you have any update on the full release of 1.0.2004.2? I would also like to create relationships between views and tables, which means, reading into your previous replies, that I need to create an entity based on a view, rather than a table?

In 1.0.2004.2 you can add entities mapped on views, which then allow you to create a relation between a table and a view using a custom relation created in the designer. 1.0.2004.2 is now in beta.

Frans Bouma | Lead developer LLBLGen Pro
ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 02-Apr-2007 14:39:26   

How can we get the beta?

Aurelien avatar
Aurelien
Support Team
Posts: 162
Joined: 28-Jun-2006
# Posted on: 02-Apr-2007 14:53:44   

Hi,

The 1.0.2004.2 version has been released on october 2005, i guess the beta is over wink

ianvink
User
Posts: 393
Joined: 15-Dec-2006
# Posted on: 02-Apr-2007 14:59:36   

Ah. I think I am a bit confused on the versioning. We bought a set of v2 licenses and have the March 19th 2007 bits installed.

Where in the designer can I add a relation from a table entity to a Typed View entity?

Thanks, Ian

Aurelien avatar
Aurelien
Support Team
Posts: 162
Joined: 28-Jun-2006
# Posted on: 02-Apr-2007 15:33:35   

Hi,

I guess you can't add relations to a typed view as you can't add relations to a view.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 02-Apr-2007 15:39:04   

Aurelien wrote:

Hi,

I guess you can't add relations to a typed view as you can't add relations to a view.

Correct. You first have to map an entity onto the view, THEN create the relation between your entity and that new entity simple_smile

Frans Bouma | Lead developer LLBLGen Pro
Anthony
User
Posts: 155
Joined: 04-Oct-2006
# Posted on: 07-Apr-2008 06:10:12   

Using UltraGrid and wish to show hiearachical data.

I have view called "calls" with a relation to "activity"

Can you guide me on how to create joins between 2 typedviews? Is this best way?

Using dotnet2,vs2005, llblgen v2.5

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 07-Apr-2008 09:56:01   

I have view called "calls" with a relation to "activity"

Can you guide me on how to create joins between 2 typedviews? Is this best way?

To define a relation between database views, you have to map them as entities. Then you can define a custom relation between these entities.

vairam2008
User
Posts: 86
Joined: 11-Mar-2008
# Posted on: 07-Apr-2008 20:04:37   

just to add this thread info useful, add the primary key for the entity so it will generate ctor's & if required can add relations to other entities in this table's relations tab.