C# Создайте однотабличную базу данных «Овощи и фрукты». Нужно хранить такую информацию: ■ Название; ■ Тип (овощ или фрукт); ■ Цвет; ■ Калорийность.

using System; using System.Data.SqlClient;

namespace VegetablesAndFruitsDatabase { class Program { static void Main(string[] args) { string connectionString = "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=VegetablesAndFruitsDB;Integrated Security=True";

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

            string createTableQuery = "CREATE TABLE VegetablesAndFruits (Id INT PRIMARY KEY IDENTITY, Name NVARCHAR(50), Type NVARCHAR(10), Color NVARCHAR(20), Calories INT)";
            SqlCommand createTableCommand = new SqlCommand(createTableQuery, connection);
            createTableCommand.ExecuteNonQuery();

            Console.WriteLine("Table 'VegetablesAndFruits' created successfully.");

            // Inserting sample data
            string insertDataQuery = "INSERT INTO VegetablesAndFruits (Name, Type, Color, Calories) VALUES " +
                "('Apple', 'Fruit', 'Red', 52), " +
                "('Carrot', 'Vegetable', 'Orange', 41), " +
                "('Banana', 'Fruit', 'Yellow', 89), " +
                "('Broccoli', 'Vegetable', 'Green', 34)";
            SqlCommand insertDataCommand = new SqlCommand(insertDataQuery, connection);
            insertDataCommand.ExecuteNonQuery();

            Console.WriteLine("Sample data inserted successfully.");

            connection.Close();
        }
    }
}

}