MySQL, Oracle Question

Posts   
 
    
TML
User
Posts: 1
Joined: 26-May-2009
# Posted on: 26-May-2009 16:01:28   

I'm starting a new .NET project that requires the ability to use a MySQL database or an Oracle database. So, I've just begun to investigate O/R mapping tools. Using LLBLGen and assuming both DB's have the same schema, would it be as simple as changing the connection string within the 'web.config' to switch between the two databases.

Thanks,

TML

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39797
Joined: 17-Aug-2003
# Posted on: 26-May-2009 17:30:38   

PLease see threads like: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=14176 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=12171

It's not as easy as changing the connection string, as that's in general not really possible: databases often have different types so you have to make sure things are converted to the right type with type converters.

Frans Bouma | Lead developer LLBLGen Pro