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

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

Thank you for quick response.

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

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.

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?

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.

How can we get the beta?

Hi,

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

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

Hi,

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

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

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

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.

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.