Програми для обліку

using Microsoft.Data.SqlClient;

namespace HelloApp
{
    class Program
    {
        static async Task Main(string[] args)
        {
            string connectionString = "Data Source=localhost\\test;Integrated Security=True;Encrypt=True;TrustServerCertificate=True";
            using (SqlConnection connection = new(connectionString))
            {
                await connection.OpenAsync();
                connection.ChangeDatabase("MyDataBase");

                SqlCommand command = connection.CreateCommand();
                command.CommandText = @"SELECT ID FROM Table";
                using (SqlDataReader reader = await command.ExecuteReaderAsync())
                    while (await reader.ReadAsync())
                    {
                        var id = reader["ID"];
                        Console.WriteLine(id);
                    }
            }
            Console.Read();
        }
    }
}

<Project Sdk="Microsoft.NET.Sdk">

  <PropertyGroup>
    <OutputType>WinExe</OutputType>
    <TargetFramework>net10.0</TargetFramework>
    <ImplicitUsings>enable</ImplicitUsings>
    <Nullable>enable</Nullable>
  </PropertyGroup>

  <ItemGroup>
    <PackageReference Include="Microsoft.Data.SqlClient" Version="6.1.3" />
  </ItemGroup>

</Project>