[vsCode C# API]データベースから取得してレスポンスするwebAPIコントローラを作る

var builder = WebApplication.CreateBuilder(args);

builder.Services.AddControllers();
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();

var app = builder.Build();

// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.UseHttpsRedirection();
app.MapControllers();
app.Run();

using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace プロジェクト名.Models
{
    [Table("test")]
    public class Test
    {
        public string Title { get; set; } = "";
    }
}

using プロジェクト名.Models;
using Microsoft.AspNetCore.Mvc;

[ApiController]
    [Route("test")]
    public class TestController : ControllerBase
    {
        [HttpGet]
        public Test Get()
        {
            return new Test(){Title="test"};
        }
    }

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "ConnectionStrings": {
    "MsSQLConnection": "Data Source=localhost,1433; Initial Catalog=DB名;Connect Timeout=5000;Persist Security Info=True; User ID=sa;Password=パスワード;"
  },
  "AllowedHosts": "*"
}

    public class TestController : ControllerBase
    {
        private IConfiguration _configuration;

        public TestController(IConfiguration configuration)
        {
            _configuration = configuration;
        }

        [HttpGet]
        public Test Get()
        {
            ;
            return new Test(){Title=_configuration.GetConnectionString("MsSQLConnection")??""};
        }
    }

dotnet add package Microsoft.data.SqlClient
dotnet add package Dapper

using Dapper;
using プロジェクト名.Models;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Data.SqlClient;

[ApiController]
    [Route("test")]
    public class TestController : ControllerBase
    {
        private IConfiguration _configuration;

        public TestController(IConfiguration configuration)
        {
            _configuration = configuration;
        }

        [HttpGet]
        public Test Get()
        {
          try{
            string connectionString = _configuration.GetConnectionString("MsSQLConnection")??"";
            if(string.IsNullOrEmpty(connectionString))
              throw new NotImplementedException("接続文字列エラー");

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                var items = connection.Query<Test>("select * from test");
                if(items.Count() >= 1)
                  return items.ToList()[0];
                else
                  throw new NotImplementedException("取得エラー");
            }
          }
          catch(Exception)
          {
            //ログ処理
            throw;
          }
        }
    }

例外が発生しました: CLR/System.Globalization.CultureNotFoundException
型 'System.Globalization.CultureNotFoundException' の例外が LobieApi.dll で発生しましたが、
ユーザー コード内ではハンドルされませんでした: 
'Only the invariant culture is supported in globalization-invariant mode. 
See https://aka.ms/GlobalizationInvariantMode for more information.'

    <InvariantGlobalization>false</InvariantGlobalization>

--falseに変更する。

'A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 
(provider: TCP Provider, error: 35 - An internal exception was caught)'

"...;TrustServerCertificate=True"