如何在Visual Studio Code中添加App.Config? [英] How to add an App.Config in Visual Studio Code?

问题描述

如何在Visual Studio Code中使用连接字符串配置C#程序?

How to configure a C# program with a connection string in Visual Studio Code?

这是针对使用Visual Studio Code 1.34.0中的.Net Core SDK版本2.2.203的.Net Core 2.2

This is for .Net Core 2.2 using .Net Core SDK version 2.2.203 in Visual Studio Code 1.34.0

我试图将App.Config文件添加到项目中，但无法解决此问题.让我知道配置连接字符串的任何解决方案.

I have tried to add App.Config file to the project, but I'm not able to resolve this issue. Do let me know any solution to configure connection string.

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Linq;  
using System.Web;
using System.Configuration;
using System.Collections.Specialized;
using Dapper;

namespace Sample_Dapper
{
    class Program
    {
        static void Main(string[] args)
        {
            IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);

            var SqlString = "SELECT TOP 100 [CustomerID],[CustomerFirstName], 
                             [CustomerLastName],[IsActive] FROM [Customer]";
            var ourCustomers = (List<Customer>)db.Query<Customer>(SqlString);
        }
    }
}

推荐答案

安装Microsoft.Extensions.Configuration.Json

Install Microsoft.Extensions.Configuration.Json

然后将appsettings.json文件添加到项目中，然后在文件-properties上单击鼠标右键，然后选择副本"以将其输出为副本(如果较新)

Then add appsettings.json file to project and right click on file -properties and select copy to output as copy if newer

var builder = new ConfigurationBuilder()
            .SetBasePath(Directory.GetCurrentDirectory())
            .AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);

        IConfigurationRoot configuration = builder.Build();

        Console.WriteLine(configuration.GetConnectionString("Test"));

        Console.WriteLine(configuration.GetSection("SampleObj:AnyPropName").Value);

示例appsetting.json文件

sample appsetting.json file

 {
  "SampleObj": {
    "AnyPropName" :  "testProp" 
  } ,
  "ConnectionStrings": {
    "Test": "CONNECTION-STRING"
  }
}

这篇关于如何在Visual Studio Code中添加App.Config?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！