VS2022.NET8 + PostgreSql 数据库使用入门指南

 <ItemGroup>
   <PackageReference Include="Npgsql" Version="8.0.4" />
   <PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="8.0.4" />
 </ItemGroup>

// 连接字符串
var connectionString = "Host=localhost;Username=postgres;Password=123456;Database=CSFrameworkV6_Normal";

using var connection = new NpgsqlConnection(connectionString);
connection.Open();

// 执行查询
using var cmd = new NpgsqlCommand("SELECT * FROM \"Test\"", connection);
var obj = cmd.ExecuteScalar();