Use an Oracle database with forms authentication in an MVC3 application

Question

I've written a simple MVC3 application and followed a tutorial on how to set up authenticated users. The tutorial used a SQL server Express database.

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

Is it just a case of changing the connection string in the web.config to point at the Oracle database... or is it a bit more in-depth than that?

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

Darin Dimitrov · Accepted Answer · 2011-12-19 15:29:38Z

2

Here's a tutorial you may checkout. It uses the ODP.NET driver.

answered Dec 19, 2011 at 15:29

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

A.B.Cade · Accepted Answer · 2011-12-19 15:26:06Z

0

It's much more in-depth than changing the connection string in the web.config.

you need a provider for Oracle
sqlServer supports Integrirty Authentication which is harder to accomplish with Oracle

answered Dec 19, 2011 at 15:26

A.B.Cade

16.9k1 gold badge39 silver badges55 bronze badges

3 Comments

TeamWild Over a year ago

should I be looking at the standard ODP or the entity framework beta 3? oracle.com/technetwork/topics/dotnet/index-085163.html

A.B.Cade Over a year ago

Depends if your using the EntityFramework or not, if you do then you need the BETA version

TeamWild Over a year ago

I ended up writing a custom provider to work with either SQL or Oracle databases (the 2 we use at work).

Collectives™ on Stack Overflow

Use an Oracle database with forms authentication in an MVC3 application

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related