Need Microsoft.Net.Sdk.Sql

[ahdung]

Traditional sqlproj is less and less supported by tools, some issues: https://developercommunity.visualstudio.com/t/Cant-drag-file-into-solution-explorer/1603986 https://youtrack.jetbrains.com/issue/RSRP-487192

But sqlclr is still alive, right? so we need a also alive database project, I think that is Microsoft.Net.Sdk.Sql.

[CZEMacLeod]

@ahdung Perhaps have a look at https://github.com/rr-wfm/MSBuild.Sdk.SqlProj/ ? I think that covers other features of sqlproj, but perhaps it could be used as a jumping off point, or be expanded to cover sql server assemblies.

[ahdung]

@CZEMacLeod Thank you for your recommendation, I know this repository, I hope there is an official thing.

[CZEMacLeod]

@ahdung It was featured in a YouTube video posted on the dotNET channel, so I think it has, at least, been acknowledged, if not officially adopted by Microsoft. It would certainly be good to see it formally adopted, and perhaps expanded by the MS team, but I'm sure there is limited availability and they have to choose what to put their efforts into.

[ahdung]

@CZEMacLeod This repository exists or not exists, I hope there is an official sql sdk, and support sqlclr. sqlclr alive, project alive. MS shouldn't forget this development scenario.

[jeffkl]

There is a team at Microsoft who owns the SQL project system that would be working on this. Unfortunately, I do not know more about it at the moment but I think there is ongoing work to improve it.

[gfody]

https://github.com/microsoft/DacFx/tree/main/src/Microsoft.Build.Sql