Last post Jun 13, 2017 11:00 AM by Eric Du
Jun 12, 2017 11:10 PM|gunderj|LINK
I have a web app using DbContext with the connection string in web.config that connects to SQL Server successfully and the web app works great. I have built the database in oracle with the exact same schema tables, views, etc. I use MVC Model classes that
will fit the oracle result sets. I do not use EF.
Now I want to change the connection entry in web.config from SQL Server to oracle. I do have ADO.NET installed and working with my oracle schema for VS 2013.
Does anyone have a sample connection entry for wegb.config DbContext I could use for this? Ultimately my app will be flipping the same DbContext between SQL Server and oracle according to back-end requirements.
Jun 13, 2017 11:00 AM|Eric Du|LINK
According to your description, as far as I know, you want to use two Data Access Layer in your project, I found two tutorials about how to implement it, please check:
The Data Access Application Block:
Implementing a Database Factory Pattern in C# ASP .NET: