How to work with mvc3 asp.net application using oracle database?

[raghurocks]

Hi all

I need to develop a mvc3 asp.net web application.
I need to use oracle as database.
Can anyone explain me the steps.

Thanks in advance

[India777]

Added the Connection String using Oracle Provider Name(providerNa me="Oracle.Data Access.Client") in WebConfig File. Then added the other key-value pair for Connection string.

For Mvc3 you need to install it on your system.

Sample is Below to connect Oracle DB:

<add name="LiveConnectionString" connectionString="Data Source=DT040;Database=Timelive;UID=sa;PWD=admin@123;" providerName="Oracle.DataAccess.Client"/>

[raghurocks]

Hey I am not asking about the connection string yar..I need to know the process

[India777]

What Process? How the mvc app and Oracle could be join?
Ask Question to be clear.......... ..!

[raghurocks]

How the application can access oracle database...I know how to get and insert the values into SQL server..but how can I in oracle?

[India777]

Like sqlserver process , Oracle do the Same. Query's only different for those. You knew how to write query in Oracle right?

[raghurocks]

Not like that.....after creating a project what is the next step??

If it is SQL server, I can go to app_data, right click on that and select add existing item and I can select my mdf file...but how can i in oracle?

[India777]

Get the Connection through ConnectionStrin g in WebConfig. it can be very Easy.

[India777]

I know What you say. In my point of view, it's not the Good way to include db primary file in the App Data. Use ConnectionStrin g or Define it in the AppConfig is the Best way used by the Many of the developers.

[Frinavale]

This question sounds like it has nothing to do with MVC but is rather a question about how to connect to, and use an oracle database.

Please check out the MSDN article called Connecting to an Oracle Data Source Using ADO.NET and follow the links to learn about this topic.