---

using System;
using System.Data.SqlClient;

class Program
{
    static string connectionString =
        @"Server=.\SQLEXPRESS;Database=CarsDB;Trusted_Connection=True;";

    static void AddBrand()
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            string query =
                "INSERT INTO Brands(Name, Country) VALUES('Toyota', 'Japan')";

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

            Console.WriteLine("Данные добавлены");
        }
    }

    static void ReadBrands()
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            string query = "SELECT * FROM Brands";

            SqlCommand command = new SqlCommand(query, connection);
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                Console.WriteLine(
                    reader["Id"] + " " +
                    reader["Name"] + " " +
                    reader["Country"]);
            }
        }
    }

    static void Main()
    {
        AddBrand();
        ReadBrands();
    }
}