New View is not created in database build in Azure Devops

Question

I created a new View in my database project and I am able to publish locally. When I look at the database script that is created I see the 'CREATE VIEW ...' code

When the build is made on Azure Devops, the changes are always reflected in the database by running the build database step.

However, this time the changes only for that new View don't seem to be published. I checked .dacpac artifacts for the build from Azure and the view doesn't exist in model.xml. In addition, I made changes in a different view in that same commit and those changes show up in model.xml. How do I create that new View to show up in Devops?

In addition, the code generated by EF database first approach pulled in the new views locally and created classes for them.

Answer 1

I had to delete the view and add => new item in visual studio. I think the error was caused because I copied another view and pasted in the same folder inside visual studio, then updated the file. This didn't update the database project file for whatever reason. I'm not sure why locally everything worked fine

Answer 2

Devops / TFS is not currently supported here on QnA. The product group for Azure DevOps / TFS actively monitors questions over at
https://developercommunity.visualstudio.com/spaces/21/index.html
https://developercommunity.visualstudio.com/spaces/22/index.html

--please don't forget to Accept as answer if the reply is helpful--