New View is not created in database build in Azure Devops

raj p lartians 101 Reputation points
2021-02-25T03:23:01.023+00:00

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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,056 questions
0 comments No comments
{count} votes

Accepted answer
  1. raj p lartians 101 Reputation points
    2021-02-25T18:30:12.88+00:00

    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

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Dave Patrick 426.3K Reputation points MVP
    2021-02-25T03:34:23.273+00:00

    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--

    0 comments No comments