public bool DeleteAccount(string name)
{
string queryString =
"DELETE FROM[dbo].comments " +
"WHERE name = @name; " +
"DELETE FROM[dbo].[accounts] " +
"WHERE accounts.[login] = @name;";
using (SqlConnection connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
command.Parameters.AddWithValue("name", name);
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
return true;
}
}