Page 1 of 1

Working with views

Posted: Wed 30 Jun 2010 11:52
by 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.

Posted: Mon 05 Jul 2010 09:39
by 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).