I am doing some unit testing and noticed that if I click (or have multiple people clicking) the same filter very very fast (very precise I know;) eventually I get a
"The connection is already open." error. I know that one way to solve this is to open new individual connections for each query each time it's called but I wonder if doing so opens my app up to a security risk -perhaps an easier time of a DoS/DDos attack?
Also, the connection is closed once completed.
If this is a risk, how can I (how do others) solve this problem?