Add 'cancel' function on Request class

[tvrprasad]

Currently 'cancel' is on Connection. This works fine since we only have a single Request per connection right now. It belongs on Request class logically though as it's the Request that's being cancelled.

We should mark the cancel function on Connection class deprecated so we can remove it in a later release.

[chdh]

Some additional info to justify this:

• In the upper level driver node-mssql, the cancel() method is a member of the Request class.
• In the .NET API, the Cancel() method ist a member of the SqlCommand class.

When cancel() is called on a Request object, the implementation must check whether the Request object really represents the currently active request.

[arthurschreiber]

Yeah, this definately feels like it should be on the Request and not the Connection, long term.

We can deprecate this somewhere in the 2.x releases and drop it in 3.0.

[arthurschreiber]

This will be added via #846. 😬

[arthurschreiber]

🎉 This issue has been resolved in version 5.0.0 🎉

The release is available on:

• npm package (@next dist-tag)
• GitHub release

Your semantic-release bot 📦🚀