microsoft / microsoft/DacFx

SDK-style SQL database project does not include assembly in dacpac although building with .NET Framework

Open
#785 6 comments 0 reactions 1 assignee Claimed by @allancascante View on GitHub
area: build sdk bug
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

- SqlPackage or DacFx Version: Microsoft.Build.Sql 2.1.0
- .NET Framework (Windows-only) or .NET Core: both
- Environment (local platform and source/target platforms): local windows

[The documentation states](https://learn.microsoft.com/en-us/sql/tools/sql-database-projects/sql-database-projects#original-projects-vs-sdk-style-projects) that SQLCLR objects are supported when building the project with .NET Framework. However this doesn't seem to work.

**Steps to Reproduce:**

1. Create an SSDT project in Visual Studio.
2. Add an SQLCLR object

Image

3. Build and find the assembly included in the dacpac
4. [Convert to SDK-style project following the manual](https://learn.microsoft.com/en-us/sql/tools/sql-database-projects/howto/convert-original-sql-project)
5. Build with .NET Framework (MSBuild.exe) and find the assembly not included in the dacpac anymore.

**Did this occur in prior versions? If not - which version(s) did it work in?** Don't know.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.