I'm making changes to an ASP.NET (VB.Net) Website, for change requests that require few column addition to an existing SQL table.
Everything works fine from Visual Studio and also when the website is hosted to local IIS. However when the same is published to UAT and tested, it throws DB exception saying Invalid column (for the one which i added new).
All the environments (VS, LOCAL IIS and the UAT) are pointing to the same SQL database.
Any help to resolve this is much appreciated