Working with views

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Dominik
Posts: 29
Joined: Wed 19 May 2010 07:26

Working with views

Post by Dominik » Wed 30 Jun 2010 11:52

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 05 Jul 2010 09:39

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).

Post Reply