Hi,
I've succesfully deployed my application (Asp.Net MVC 5 and jQuery) to Azure. After adding new properties to an object e.g. Product and adding migration and update database I keep getting following error.
Column names in each table must be unique. Column name '' in table 'dbo.FProducts' is specified more than once.
I have never added the property in the past to the object so it can never occur more than once. How can I fix this problem.
Thanks in advance.
3 Answer(s)
-
0
Hi,
What happens when you change your connection string and apply migrations to a new database ? Can you try it in your local environment ?
-
0
Hi,
When I do that locally everything works fine.
-
0
Hi,
Can you share your database schema script deployed in azure and migration which causes problem ? You can send it to <a href="mailto:[email protected]">[email protected]</a>.
In the mean time you can try to compare schemas of azure and local databases using a schema copmarison tool. Visual Studio has one and it is good.
Thanks.