Use Oracle View Objects in MVC Application by Dapper

Question

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")]

Jimit Bhatt · Answer

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?

Saineshwar Bageri · Answer

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

Jimit Bhatt · Answer

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?

Saineshwar Bageri · Answer

Can explain in details regarding your Issue !