Unresolved reference to object in SQL project results in build warning instead of error
- Dominant language
- C#
- Stars
- 460
- Forks
- 29
- Avg merge
- 4d 9h
- Merged PRs (30d)
- 7
Description
- SqlPackage or DacFx Version: 162.1.x
- .NET Framework (Windows-only) or .NET Core: both
If I have a stored proc in the project that is just a select statement from a table - the stored proc can have unresolved references and the build still succeeds. (with a warning)
**Did this occur in prior versions? If not - which version(s) did it work in?**
As recently as 2017 (tbd about 2019), an unresolved object reference resulted in an error:
https://the.agilesql.club/2017/11/ssdt-how-to-fix-error-sql17502/

**A repro environment would be any SQL project with a single stored proc:**
```sql
CREATE PROCEDURE dbo.SomeProc
AS
BEGIN
SELECT * FROM dbo.TableDoesntExist
END
```
Contributor guide
Research direction
Reproduce the issue in a SQL project using the supplied dbo.SomeProc example and verify the behavior with SqlPackage or DacFx 162.1.x on both .NET Framework and .NET Core. Trace the SQL project build diagnostics, then confirm that the unresolved dbo.TableDoesntExist reference is reported as an error rather than a warning.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- build-system, database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100