Setup Oracle DataSources & Connection String In AppSetting.json file in .net core 2.1

Question

I want to setup oracle database settings in appsetting.json file in my .netcore application my previous datasource structur like this in Asp.Net

<oracle.manageddataaccess.client>
    <version number="*">
      <dataSources>
        <dataSource alias="Test" descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=180.148.11.140)(PORT=1221))(CONNECT_DATA=(SERVICE_NAME=orcl))) "/>
      </dataSources>
    </version>
  </oracle.manageddataaccess.client>
  <connectionStrings>
    <add name="OracleDbContext" providerName="Oracle.ManagedDataAccess.Client"
      connectionString="User Id=Emp;Password=abc@123;Data Source=Emp"/>

  </connectionStrings>

Possible duplicate of [Store / Retrieve ConnectionString from appSettings.json in ASP.net Core 2 MVC app](https://stackoverflow.com/questions/50507382/store-retrieve-connectionstring-from-appsettings-json-in-asp-net-core-2-mvc-ap) — Panagiotis Kanavos, Sep 25 '18 at 13:43
I want to handle **dataSource** provided inside `` i all ready know how to get `` and access to dbcontaxt or other pages please try to understand my promble.@PanagiotisKanavos — Jay, Sep 25 '18 at 13:46
Those are just tags. Create the *same* sections in the JSON file and read them just like any other setting. There are no special paths or tags in .NET Core. Perhaps you wanted to ask something different, like how to have the Oracle client configure itself from those settings? — Panagiotis Kanavos, Sep 25 '18 at 13:48
That's a JSON question, not related to settings. You specify it the same way as any other object in JSON - as a dictionary whose keys are the property names, values are the property contents. Eg: `"version" : { "number" : "*"} ,...`. You *don't* have to follow the same structure though. Create a configuration class in the shape you want and write the JSON text in a way that matches it. An `OracleSettings` class with a Version, Alias and Descriptor string properties would be enough. That maps easily to an `"OracleSettings": { Version=*", Alias="Test", Descriptor="...."}` — Panagiotis Kanavos, Sep 25 '18 at 13:54

Setup Oracle DataSources & Connection String In AppSetting.json file in .net core 2.1

0 Answers0