Use Dependency Injector "Ninject" to dynamically choose between ORM's (Entity Framework or Dapper) and Databases (SQL Server or Oracle Database)

Sreekanth Mothukuru

Rate me:

4.96/5 (23 votes)

30 Nov 2015CPOL10 min read

47.8K

1.5K

The idea is to use Dependency Injector (DI) framework Ninject to dynamically target our application to SQL Server or Oracle database either by using Entity framework (EF) or Dapper ORM using global settings

DI.zip
- DI
  - DataAccess
    - Abstract
      - DapperRepositoryBase.cs
      - EfRepositoryBase.cs
    - App.config
    - bin
      - Debug
        
        Dapper.dll
        
        Dapper.pdb
        
        Dapper.xml
        
        DataAccess.dll
        
        DataAccess.dll.config
        
        DataAccess.pdb
        
        EntityFramework.dll
        
        EntityFramework.SqlServer.dll
        
        EntityFramework.SqlServer.xml
        
        EntityFramework.xml
        
        EntityModel.dll
        
        EntityModel.pdb
      - Release
    - DataAccess.csproj
    - Interface
      - ICompanyRepository.cs
      - IRepositoryBase.cs
    - obj
      - Debug
        
        DataAccess.csproj.FileListAbsolute.txt
        
        DataAccess.csprojResolveAssemblyReference.cache
        
        DataAccess.dll
        
        DataAccess.pdb
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
        
        TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
        
        TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
        
        TempPE
    - packages.config
    - Properties
      - AssemblyInfo.cs
    - Repository
      - Dapper
        
        MSSQL
        
        CompanySqlRepository.cs
        
        ORA
        
        CompanyOraRepository.cs
      - EF
        
        CompanyEfRepository.cs
  - DI.sln
  - DI.v12.suo
  - EntityModel
    - App.config
    - bin
      - Debug
        
        EntityFramework.dll
        
        EntityFramework.SqlServer.dll
        
        EntityFramework.SqlServer.xml
        
        EntityFramework.xml
        
        EntityModel.dll
        
        EntityModel.dll.config
        
        EntityModel.pdb
      - Release
    - DomainModel
      - Company.cs
      - DiContext.cs
    - EntityModel.csproj
    - obj
      - Debug
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        EntityModel.csproj.FileListAbsolute.txt
        
        EntityModel.csprojResolveAssemblyReference.cache
        
        EntityModel.dll
        
        EntityModel.pdb
        
        TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
        
        TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
        
        TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
        
        TempPE
    - packages.config
    - Properties
      - AssemblyInfo.cs
  - packages
  - UI
    - App_Data
    - App_Start
      - BundleConfig.cs
      - FilterConfig.cs
      - NinjectWebCommon.cs
      - RouteConfig.cs
    - bin
      - Antlr3.Runtime.dll
      - Antlr3.Runtime.pdb
      - Dapper.dll
      - Dapper.pdb
      - Dapper.xml
      - DataAccess.dll
      - DataAccess.pdb
      - EntityFramework.dll
      - EntityFramework.SqlServer.dll
      - EntityFramework.SqlServer.xml
      - EntityFramework.xml
      - EntityModel.dll
      - EntityModel.pdb
      - Microsoft.Web.Infrastructure.dll
      - Newtonsoft.Json.dll
      - Newtonsoft.Json.xml
      - Ninject.dll
      - Ninject.Web.Common.dll
      - Ninject.Web.Common.xml
      - Ninject.Web.Mvc.dll
      - Ninject.Web.Mvc.xml
      - Ninject.xml
      - System.Web.Helpers.dll
      - System.Web.Helpers.xml
      - System.Web.Mvc.dll
      - System.Web.Mvc.xml
      - System.Web.Optimization.dll
      - System.Web.Optimization.xml
      - System.Web.Razor.dll
      - System.Web.Razor.xml
      - System.Web.WebPages.Deployment.dll
      - System.Web.WebPages.Deployment.xml
      - System.Web.WebPages.dll
      - System.Web.WebPages.Razor.dll
      - System.Web.WebPages.Razor.xml
      - System.Web.WebPages.xml
      - UI.dll
      - UI.dll.config
      - UI.pdb
      - WebActivatorEx.dll
      - WebGrease.dll
    - Content
      - bootstrap.css
      - bootstrap.min.css
      - Site.css
    - Controllers
      - CompanyController.cs
    - favicon.ico
    - fonts
      - glyphicons-halflings-regular.eot
      - glyphicons-halflings-regular.svg
      - glyphicons-halflings-regular.ttf
      - glyphicons-halflings-regular.woff
    - Global.asax
    - Global.asax.cs
    - Models
    - obj
      - Debug
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs
        
        TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs
        
        TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs
        
        TempPE
        
        UI.csproj.FileListAbsolute.txt
        
        UI.csprojResolveAssemblyReference.cache
        
        UI.dll
        
        UI.pdb
    - packages.config
    - Project_Readme.html
    - Properties
      - AssemblyInfo.cs
    - Scripts
      - _references.js
      - bootstrap.js
      - bootstrap.min.js
      - jquery.validate.js
      - jquery.validate.min.js
      - jquery.validate.unobtrusive.js
      - jquery.validate.unobtrusive.min.js
      - jquery.validate-vsdoc.js
      - jquery-1.10.2.intellisense.js
      - jquery-1.10.2.js
      - jquery-1.10.2.min.js
      - jquery-1.10.2.min.map
      - modernizr-2.6.2.js
      - respond.js
      - respond.min.js
    - UI.csproj
    - UI.csproj.user
    - Views
      - _ViewStart.cshtml
      - Company
        
        CompanyDetails.cshtml
        
        GetCompanies.cshtml
        
        InsertCompany.cshtml
        
        UpdateCompany.cshtml
      - Shared
        
        _Layout.cshtml
        
        Error.cshtml
      - Web.config
    - Web.config
    - Web.Debug.config
    - Web.Release.config
DI_DB.zip
- SP_Script.txt
- Table_Create_Stript.txt

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Sreekanth Mothukuru

Technical Lead

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Use Dependency Injector "Ninject" to dynamically choose between ORM's (Entity Framework or Dapper) and Databases (SQL Server or Oracle Database)

License

Comments and Discussions