call a stored procedure that takes in string values name, address and outputs a unique id in csharp

main.cs
using System.Data.SqlClient;  // Required for using SQL client classes

class Program {
    static void Main(string[] args) {
        // Connect to SQL Server instance
        SqlConnection conn = new SqlConnection("<your_connection_string>");
        conn.Open();  // Open the connection to the SQL Server

        // Create a new SQL command object
        SqlCommand cmd = new SqlCommand("sp_create_new_customer", conn);
        cmd.CommandType = CommandType.StoredProcedure;

        // Add input parameters to the command object
        cmd.Parameters.Add(new SqlParameter("@name", "John Doe"));
        cmd.Parameters.Add(new SqlParameter("@address", "123 Main St, Anytown USA"));

        // Add output parameter to the command object
        SqlParameter outputParam = new SqlParameter("@customer_id", SqlDbType.Int);
        outputParam.Direction = ParameterDirection.Output;  // Specify direction as output
        cmd.Parameters.Add(outputParam);

        // Execute the stored procedure and get the output value
        cmd.ExecuteNonQuery();  // Execute the stored proc
        int id = Convert.ToInt32(outputParam.Value);  // Get the value of the output parameter

        // Close the SQL connection
        conn.Close();
    }
}
1245 chars
30 lines