Use Oracle Form Authenticated Database in MVC3 Application

Question

I wrote a simple MVC3 application and followed a tutorial on setting up authenticated users. The tutorial used the SQL Server Express database.

Is it possible to use an Oracle database instead of a SQL server?

Is this just a case of changing the connection string in the web.config file to point to an Oracle database ... or is it deeper than this?

<connectionStrings> <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /> </connectionStrings> 

Answer 1

This is much deeper than changing the connection string in the web.config file.

• you need a provider for Oracle
• sqlServer supports Integrirty Authentication, which is harder to complete with Oracle

Answer 2

Here you can check the tutorial . It uses the ODP.NET driver.