SQL server database project and Migration to net6

Question

In my mvc core solution I have SQL server database project which is targeting to framework .Net framework 4.5.
After I updated all projects to. Net 6 this project didn't allow me to update it. But after merging, build failed due to error:
The reference assemblies for .NETFramework,Version=v4.5 were not found.

Is still compatible or supported sql server database project in. Net 6?

Answer 1

I assume you have a CLR component in the database project. Sql CLR does not support .net core. also CLR projects do not support .net standard class libraries. I believe you can use the portable library, but this is not supported by core after core 2.0

you can upgrade your database project to 4.8

if you are trying to share code between the core projects and CLR, then create a multi-target project that builds a .netstandard and a net48 library.

the shared code will be limited to C# 7.3

note: SSIS script packages do not support .net core.

Answer 2

This might be interesting for anyone who finds themselves here. You can build a .dacpac from database project with modern .net frameworks.

Answer 3

With .Net 5 it worked well but now this project failed during build. I use it just to keep structure of database and changes.