How do I execute SQL commands in .NET?

How do I execute SQL commands in .NET?

You can execute SQL commands in .NET using ADO.NET. Do you want a code example?

Yes, please provide a code example for executing a SELECT statement.

Here's a simple example:

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlCommand command = new SqlCommand("SELECT * FROM Users", connection);
    SqlDataReader reader = command.ExecuteReader();
    while (reader.Read())
    {
        Console.WriteLine(reader["Name"]);
    }
}

What if I want to execute an INSERT command?

You can use a similar approach. Here's an example:

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    SqlCommand command = new SqlCommand("INSERT INTO Users (Name) VALUES (@Name)", connection);
    command.Parameters.AddWithValue("@Name", "John Doe");
    command.ExecuteNonQuery();
}