Prev Next

Delete Operation using SqlClient

The Delete operation removes records from a database. This example demonstrates deleting an employee record using SqlCommand.

Key Topics

Delete Example

Example

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Server=localhost;Database=MyDatabase;User Id=myUser;Password=myPassword;";
        string query = "DELETE FROM Employees WHERE Name = @Name";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            command.Parameters.AddWithValue("@Name", "John Doe");

            connection.Open();
            int rowsAffected = command.ExecuteNonQuery();
            Console.WriteLine(rowsAffected + " row(s) deleted.");
        }
    }
}

Explanation: This example uses SqlCommand to delete a specific employee record securely using parameters.

Key Takeaways

  • Use ExecuteNonQuery for delete operations.
  • Always confirm that parameters are used to prevent accidental or malicious deletions.
Prev Next