Ssdt annotations

[JordanMarr]

Proposed Changes

• Added new Type Annotation feature that allows annotating types for view columns via in-line comments (added as a work-around since the .dacpac can't resolve computed columns).
• Added column descriptions that indicate if a view column has a type annotation (or if it needs one).
• Fixed confusing error message when the SsdtPath was invalid (which said it was looking for it in the .nuget global cache folder)
• Updated SSDT docs with new Type Annotation features
• Updated SSDT docs with more information on setting the SsdtPath for design-time and for deployment.
• Added support for table computed columns so that they now exist with a type of obj. (Unfortunately, it looks like the .dacpac doesn't let me query comments on tables the same way it does for views, so I'm not yet sure how to do inline comment type annotations for computed table columns yet.)
• Added Type Annotations for computed table columns.

Types of changes

What types of changes does your code introduce to SQLProvider? Put an x in the boxes that apply

• [x] Bugfix (non-breaking change which fixes an issue)
• [x] New feature (non-breaking change which adds functionality)
• [ ] Breaking change (fix or feature that would cause existing functionality to not work as expected)

Checklist

Put an x in the boxes that apply. You can also fill these out after creating the PR. If you're unsure about any of them, don't hesitate to ask. We're here to help! This is simply a reminder of what we are going to look for before merging your code.

• [ ] Build and tests pass locally
• [x] I have added tests that prove my fix is effective or that my feature works (if appropriate)
• [ ] I have added necessary documentation (if appropriate)

[JordanMarr]

Actually it looks like the .dacpac will include the comment for a computed table column, but only if the comment is contained within the parenthesis (which can easily be documented). So hold off on merging this until I can implement annotations for computed table columns.

[JordanMarr]

I think this PR is now ready! I'll fix the stored procs issue later.

[Thorium]

Thanks! Released in 1.1.99