Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Store & use Two different Types of database in asp.net MVC

Home
Forums
.NET

Store & use Two different Types of database in asp.net MVC

Mark Tabor

5yAsked May 1, 2021, 8:53 AM703.NET

Hi I have a requirement I am making asp.NEt mvc application , the requirement is that I need to store the data in both SQL SERVER & ORACLE database at the same time is there any reference example what is the best approach to do that ?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Mark Tabor5y ago
Thanks Sachin can you explain how i can use dependency injection here.
0
Sachin Singh5y ago
I don't know the best approach, but I would have created an IDAL , inheriting two different concrete DAL
public Interface IDAL
{
public IEnumerable Get();
public T GetById(Object Id);
.....
..... other method signature
}

public class SqlDAL:IDAL
{
// define all method with Sql connection string
}

public class OracleDAL:IDAL
{
// define all method with Oracle connection string
}
Now in the application use the interface and point whichever DAL you want to point
IDAL sqldb= new SqlDAL();
sqldb.Insert(parameters);

IDAL ordb= new OracleDAL();
ordb.Insert(parameters);
better is to use dependency injection either constructor or third party , i just gave you and idea.
0