transparent data access (ie using oracle and/or other db in dotnet) [message #126567] |
Tue, 05 July 2005 13:41 |
gdeconto
Messages: 41 Registered: June 2005 Location: Vancouver, British Columb...
|
Member |
|
|
first off, know this is a forum for oracle users and not a dotnet forum. the thing is, the ones who might have an answer will likely be in this forum.
my question is, have any of you oracle developers out there had any experience in creating dotnet applications that have transparent data access?? ie being able to specify via a simple toggle, to use EITHER oracle OR mysql OR ... database.
have seen some sample bits of code out there in dotnet forums but I was specifically interested in running oracle or something else (mysql, mssql, whatever) as the backend for some dotnet apps.
|
|
|
|
Re: transparent data access (ie using oracle and/or other db in dotnet) [message #126771 is a reply to message #126712] |
Wed, 06 July 2005 10:04 |
gdeconto
Messages: 41 Registered: June 2005 Location: Vancouver, British Columb...
|
Member |
|
|
thx for the response.
my question is not "how to do I write a dotnet program whose functions/procedures get data from oracle". thats essentially easy to do.
transparent data access is a fair bit more complex than that.
it is more "how to do I write a dotnet program, that doesnt need to be recoded or recompiled, who functions/procedures get data from oracle if flag=use_oracle OR from mssql if flag=use_mssql OR from mysql if flag=mysql OR ... etc
the dotnet crowd dont typically write for non-microsoft databases. I posted this message in this oracle forum because I thought that there must be oracle developers who have had to co-exist with mssql/access/etc and so might have had to deal with transparent data access.
|
|
|
|
|