---

using System.Data.SqlClient;

internal class Program
{
    static void Main(string[] args)
    {
        Console.WriteLine("работа с базой данных Library\n");
        AddAuthor("еае", "шгоа");
        AddAuthor("efoef", "ffkf");
        AddAuthor("frit", "hjkj");
        ReadAuthors();
        DeleteAuthors(1);
        Console.WriteLine("\nНажмите любую клавишу длявыхода...");
        Console.ReadKey();
    }
    static void AddAuthor(string firstName, string lastName)
    {
        string connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Library;Integrated Security=True";
        string sql = "INSERT INTO Authors (FirstName, LastName) VALUES (@FirstName, @LastName)";
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            conn.Open();
            Console.WriteLine("Подключение открыто");
            using (SqlCommand cmd = new SqlCommand(sql, conn))
            {
                cmd.Parameters.AddWithValue("@FirstName", firstName);
                cmd.Parameters.AddWithValue("@lastName", lastName);
                int rows = cmd.ExecuteNonQuery();
                Console.WriteLine($"Добавлено строк: {rows}");

            }

        }

    }
    static void ReadAuthors()
    {
        string connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Library;Integrated Security=True";

        string sql = "SELECT id,FirstName, LastName FROM Authors";

        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            conn.Open();
            Console.WriteLine("Подключение открыто");

            using (SqlCommand cmd = new SqlCommand(sql, conn))
            {
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    Console.WriteLine("\nСписок авторов:");

                    while (reader.Read())
                    {
                        int id = reader.GetInt32(0);
                        string firstName = reader.GetString(1);
                        string lastName = reader.GetString(2);

                        Console.WriteLine($"{id}. {firstName} {lastName}");
                    }
                }

            }
        }
    }
    static void DeleteAuthors(int AuthorsId)
    {

        string connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Library;Integrated Security=True";
        string sql = "DELETE FROM Authors WHERE Id = @id";
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            conn.Open();

            using (SqlCommand cmd = new SqlCommand(sql, conn))
            {
                cmd.Parameters.AddWithValue("@Id", AuthorsId); 
                int rows = cmd.ExecuteNonQuery();
                Console.WriteLine($"Удаление строк: {rows}");
            }

        }
    }
}