Use Oracle View Objects in MVC Application by Dapper

Jimit Bhatt

10y1.5k.NET

I am building an application in ASP.NET MVC 5 and using Dapper ORM.

I am actually stuck at the point.

I had made one view(* Not MVC View) in Oracle DB so as to reduce the query length in application. Now I want to use that View MVC Application to get the data.

DataAnnonations.Schema doesn't contain the definitions of View as it is for Table, Column etc.

like [Dapper.Table("TableName")]

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jimit Bhatt10y ago
That's Okay.

But my concern is that how do I call that view?
For Table we create Model and using dapper function:

Query.Execute() we retrieve the data.
But how can we retrieve for View(Oracle Object ).

Can we write Model as :

[Dapper.View["ViewObjectName"]]
public class Name
{
// View Object Columns
}

And use it in Dapper Query.

I don't think so? So anyhow I have to do multiple joins only , Isn't it?
0
Saineshwar Bageri10y ago
In controller you can call this that method which gets this data from database .then pass this model to View and this Column must be a String .

On View to display that Column write @Html.Raw( Add Column)

Or You Can Store View in ViewData["Temp"] and display on View() @Html.Raw(ViewData["Temp"])
0
Jimit Bhatt10y ago
Ya sure.

I have created a View in Oracle Database in order to relief from large number of "join tables queries".

Now I have created a ViewModel in which I want to access that view of Oracle Database. How would I Access it?
0
Saineshwar Bageri10y ago
Can explain in details regarding your Issue !
0