---

using ConsoleApp3009;
using Microsoft.Data.SqlClient;
using System.Data.SqlTypes;
using System.Drawing;
using System.Text;
internal class Program
{
    private static void Main(string[] args)
    {
        Console.OutputEncoding = Encoding.UTF8;

        Console.WriteLine("Hello, World!");

        SqlConnection? connection = null;
        SqlCommand? command = null;
        SqlDataReader? reader = null;


        try
        {
            connection = Connection();
            SeedData(connection, out command, out reader);

            command = new SqlCommand("SELECT * FROM StudentAssesments", connection);
            reader = command.ExecuteReader();

            while (reader.Read())
            {
                Console.WriteLine(reader["FIO"]);
            }
            reader.Close();
        }
        catch (Exception ex)
        {
            ColorConsole.WriteLine(ConsoleColor.Red, $"Внимание! Ошибка! \n{ex.ToString()}\n\n");
        }
        finally
        {
            if (connection != null)
            {
                connection.Close();
            }
        }


    }

    private static void SeedData(SqlConnection? connection, out SqlCommand command, out SqlDataReader reader)
    {
        command = new SqlCommand("SELECT * FROM StudentAssesments", connection);
        reader = command.ExecuteReader();

        if (!reader.HasRows)
        {
            Random rnd = new Random();
            for (int i = 0; i < 10; i++)
            {
                string[] names = { "Иван", "Игнат", "Петр", "Сергей", "Макар", "Денис" };
                string[] surnames = { "Иванов", "Сапожников", "Петров", "Ершов", "Дыбенко", "Осадков" };
                string[] subject = { "Математика", "Физика", "Информатика", "Литератоура", "Русский язык", "ОБЖ" };
                string[] groupNames = { "rpo24/2", "rpo24/3", "rpo24/4", "rpo24/5", "rpo24/6", "rpo24/7" };

                string sqlQuery = $@"INSERT INTO SrudentAssesments(FIO, GroupName, MinAssesSubject, MaxAssesSubject, AvgAssesment) VALUES
                                (
                                    '{names[rnd.Next(6)]} {surnames[rnd.Next(6)]}',
                                    '{groupNames[rnd.Next(6)]}',
                                    '{subject[rnd.Next(6)]}',
                                    '{subject[rnd.Next(6)]}',
                                    {rnd.Next(6)}.{rnd.Next(10)})";

                command = new SqlCommand(sqlQuery, connection);
                command.ExecuteNonQuery();

            }

            
        }
        reader.Close();
    }

    private static SqlConnection Connection()
    {
        SqlConnection? connection;
        string connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=GossenPR1;Integrated Security=True;Connect Timeout=30;Encrypt=False;Trust Server Certificate=False;Application Intent=ReadWrite;Multi Subnet Failover=False";

        connection = new SqlConnection(connectionString);
        connection.Open();

        if (connection.State == System.Data.ConnectionState.Open)
        {
            ColorConsole.WriteLine(ConsoleColor.Green,
                $"Подключение установленно\n");
        }
        else
        {
            ColorConsole.WriteLine(ConsoleColor.Red,
                $"Подключение прервано\n");

        }

        return connection;
    }
}


__________________________________________________________________ 


using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp3009
{
    public static class ColorConsole
    {
        public static void Write(ConsoleColor color, string str)
        {
                Console.ForegroundColor = color;
                Console.Write(str);
                Console.ForegroundColor = ConsoleColor.Gray;
        }
        public static void WriteLine(ConsoleColor color, string str)
        {
            Write(color, str);
            Console.WriteLine();
        }
    }
}