Working with views

[Dominik]

Hi,

Imagine there are these two tables in database:

[T_A]
A_ID
A_TYPE
B_ID

[T_B]
B_ID
B_NAME

I want to build a view in this way:

[V_A_B]
A_ID
A_TYPE
B_ID
B_NAME

And then add this view to my model. In this scenario, can I perform insert/update/delete operations against T_A table with Oracle provider?

Thanks in advance,

Dominik.

[AndreyR]

You will be able to perform CUD operations using the T_A entity. As for the V_A_B view, it will work in case this view is considered as updatable by your DBMS (for example, Microsoft SQL Server does not allow such updates).