1

I am trying to create a .Net core console application with can use different database connections. currently, i am writing the application to use SQL and in future if i want to use Oracle or any other connection then i should be able to easily achieve this. So, i am using dependency injection for this purpose.

I am exploring the below option using ServiceCollection

IConfiguration config = new ConfigurationBuilder()
                       .AddJsonFile("appsettings.json", true, true)
                       .Build();
var sqlconnectionstring = config.GetConnectionString("SQLConnectionString");
var serviceProvider = new ServiceCollection()
                       .AddLogging()
                       .AddSingleton<IChannel, Email>()
                       .AddTransient<IDBObjectManager>(s => new SQLDBObject(sqlconnectionstring))

Here the idea is, I have created a SQLDBObject class which will have SQL related functionalities. In future, I will create one for some other db.

I am seeing many articles around this with Entity Framework but at this point I am checking to make this functionality work with my SQL connection class.

I don't know if i am using the DI correctly here. Can someone advise?

Improve this question
3
  • 1
    check this answer: stackoverflow.com/a/43088581/261560 Commented Sep 28, 2018 at 12:17
  • 1
    Sure, you can have an ADO.NET based repository system. Just code them to a common interface, and have their constructors depend on an object that describes how to connect to the database. Exactly like you've shown. I will suggest you use Dapper within your repositories, as it takes out a lot of the boiler plate. Commented Sep 28, 2018 at 12:25
  • Thank You Prashant and mason for your answers. I was not aware of the options pattern and the answer helped me in understanding better. Also, I will try to implement dapper and refine the code. Thanks again! Commented Oct 3, 2018 at 6:46
Related questions
0
ASP.NET Core database configuration with dependency injection issue
1
Connect to database .net core
1
Understanding Dependency Injection for database connections in Dot Net Core
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.