microsoft / microsoft/DacFx

v2.0.0 and VS2026 issue with NuGet auto-restore before build

Open
#738 2 comments 7 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

area: ssdt
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

- SqlPackage or DacFx Version: 170.2.70
- .NET Framework (Windows-only) or .NET Core: .NetCore (Net9.0)
- Environment (local platform and source/target platforms): Windows 10

**Steps to Reproduce:**

1. create a new sln
2. create a new SQLPROJ project
3. add content for tables/views or other db objects
4. run a bat file that deletes all `/bin` & `/obj` folders (uncommon but happens/helps)
5. run build from VS2026 project or solution context menu
6. get error: `01004: Assets file 'A:\source\repos\KCP\monitor\KCP.Monitor.SSDT\obj\project.assets.json' not found. Run a NuGet package restore to generate this file.`
**Workaround:**
manually navigate to the SSDT Project folder and run `dotnet restore` (creates the assets file), then use VS2026 to build.

**Did this occur in prior versions? If not - which version(s) did it work in?**
yes, Microsoft.Build.Sql/1.0.0

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Reproduce the SQLPROJ build in VS2026 after deleting the bin and obj folders, using the reported DacFx 170.2.70 and .NET 9 environment. Compare the failed build with the documented dotnet restore workaround; done means the VS2026 project or solution build automatically creates project.assets.json and succeeds.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
build-system, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
48/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.