Creating ASP.NET MVC application against Oracle database pt. 1
1 minute read
This is a first in a series of posts, as I will try to build ASP.NET MVC application against Oracle XE database, but this example can be used for any Oracle database greater than 9i.
I will try to use Oracle ODAC.net the latest version that I can get from the Oracle Site.
With a little help from LILkillaBEE I created generic helpers that return IEnumerable<T> on which I can use LINQ and play with it.
First thing first, as I am creating a Contact manager application part by part, the first functionality i want to implement is getting the data from the Oracle XE database and working with it in MVC way. So i have created the table with personal data only in it.
After this, i have created the Person class in my project
And an interface that I will implement later in my repository
EDIT: After considering to finish this tutorial i finally gave up because there is no easy way of doing this and i kept hitting the wall a few times.