Recursively removing subtasks?

Question

ASP.NET

There is such a model

public class TaskModel
{
    public int Id { get; set; }
    public string Title { get; set; }
    public int ParentId { get; set; }
}

How to write a controller method to delete this task and all its subtasks?

[HttpDelete]
public ActionResult RemoveTask([FromBody] TaskModel taskData)
{
            // var tasksIds = GetChildrenIds(taskData.id);
            // Db::rawQuery($"DELETE FROM Tasks WHERE Id in {tasksIds}");
            // Db.SaveChanges();
 
            return Json(Db.Tasks);
}
private IEnumerable<int> GetChildrenIds(int parentId)
{
            return Db.Tasks
                .Where(task => task.Id == parentId)
                .Select(task => task.Id);
}

Answer 1

If it's sql then maybe just use cascade delete!?