blocks|key|2830198|text|本文简介：https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/migrations-and-deployment-with-the-entity-framework-in-an-asp-net-mvc-application#deploy-the-application-to-azure|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2830199|在"8.选择更新数据库“一节中，描述了如何在发布过程中设置数据库：|2830200|​|2830201|📷|atomic|2830202|2830203|如果你不想自动迁移，这里有一些高级场景：https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/migrations-and-deployment-with-the-entity-framework-in-an-asp-net-mvc-application#advanced-migrations-scenarios|2830204|如果你有EF核心，你也可以检查这个：EntityFramework+Core+automatic+migrations|2830205|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/migrations-and-deployment-with-the-entity-framework-in-an-asp-net-mvc-application#deploy-the-application-to-azure|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/15034f773b5376c9b2cff2d972816d89.png|imageAlt|2|https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/migrations-and-deployment-with-the-entity-framework-in-an-asp-net-mvc-application#advanced-migrations-scenarios|3|https://stackoverflow.com/questions/39526595/entityframework-core-automatic-migrations^0|5|60|0|0|0|0|0|1|1|0|0|K|5Y|2|0|I|15|3|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@$A|18|B|19|1|1A]]|C|$]]|$1|D|3|E|5|6|7|1B|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1C|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|1D|8|@]|9|@$A|1E|B|1F|1|1G]]|C|$]]|$1|K|3|G|5|6|7|1H|8|@]|9|@]|C|$]]|$1|L|3|M|5|6|7|1I|8|@]|9|@$A|1J|B|1K|1|1L]]|C|$]]|$1|N|3|O|5|6|7|1M|8|@]|9|@$A|1N|B|1O|1|1P]]|C|$]]|$1|P|3|-4|5|6|7|1Q|8|@]|9|@]|C|$]]]|Q|$R|$5|S|T|U|C|$V|W]]|X|$5|Y|T|Z|C|$10|11|12|-4]]|13|$5|S|T|U|C|$V|14]]|15|$5|S|T|U|C|$V|16]]]]

In this article:
<a href="https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/migrations-and-deployment-with-the-entity-framework-in-an-asp-net-mvc-application#deploy-the-application-to-azure" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/migrations-and-deployment-with-the-entity-framework-in-an-asp-net-mvc-application#deploy-the-application-to-azure</a>

In part "8. Select Update database.", it describes how can you set it up during publish:

<a href="https://i.stack.imgur.com/1Jgox.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1Jgox.png" alt="update database"></a>

If you don't want automatic migration here are the advanced scenarios:
<a href="https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/migrations-and-deployment-with-the-entity-framework-in-an-asp-net-mvc-application#advanced-migrations-scenarios" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/migrations-and-deployment-with-the-entity-framework-in-an-asp-net-mvc-application#advanced-migrations-scenarios</a>

If you have EF core, you can also check this:
<a href="https://stackoverflow.com/questions/39526595/entityframework-core-automatic-migrations">EntityFramework Core automatic migrations</a>

blocks|key|94446|text|理想情况下，有一个CI/CD管道用于传播更改(代码、数据库模式等)。上游环境(例如开发、测试、试运行、生产等)，包括BVT测试，以防止破坏。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|94447|找到以下几个选项来传播此更改：|94448|-选项1-|offset|length|style|BOLD|94449|一种方法是通过SSMS+(例如，SQL+Server+Management+Studio，版本17.2+)连接到Azure+SQL服务器/数据库，并运行如下例所示的T-SQL脚本(更改表名并调试打印)，其中将LogType列添加到名为dbo.Customer的现有表中。|94450|此外，通过导航到Azure+SQL数据库>查询编辑器(预览)并运行脚本，也可以在Azure门户中执行此脚本。|94451|IF+EXISTS(SELECT+*+FROM+sys.columns+WHERE+object_id+=+OBJECT_ID('dbo.Customer')+AND+name='LogType')
BEGIN
++++PRINT+'Column+LogType+already+exists+on+table+dbo.Customer+and+it+is+configured+properly.'
END
ELSE
BEGIN
++++PRINT+'Adding+column+LastName+to+table+dbo.Customer...'

++++ALTER+TABLE+dbo.Customer
++++ADD+LogType+VARCHAR(100)+NOT+NULL
END
PRINT+'---+DONE+---'
GO|code-block|syntax|javascript|94452|94453|-选项2-|94454|另一个选项是手动将LogType列添加到表中，这可以通过使用SSMS连接到Azure+SQL服务器/数据库来完成，右击表名并选择。然后，添加新列。|94455|entityMap^0|0|0|0|5|0|7|1A|2W|7|39|C|0|0|0|0|0|5|0|9|7|U|4|1S|9|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|11|8|@$F|12|G|13|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|14|8|@$F|15|G|16|H|I]|$F|17|G|18|H|I]|$F|19|G|1A|H|I]]|9|@]|A|$]]|$1|L|3|M|5|6|7|1B|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|1C|8|@]|9|@]|A|$Q|R]]|$1|S|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1E|8|@$F|1F|G|1G|H|I]]|9|@]|A|$]]|$1|V|3|W|5|6|7|1H|8|@$F|1I|G|1J|H|I]|$F|1K|G|1L|H|I]|$F|1M|G|1N|H|I]]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1O|8|@]|9|@]|A|$]]]|Y|$]]

Ideally, there is a CI/CD pipeline in place to propagate changes (code, database schema, etc.) upstream the environments (e.g. development, test, staging, production, etc.), including BVT tests, to prevent breaking things.

Find below a couple of options to propagate this change:

--- Option 1 ---

One approach would be connecting to the Azure SQL server/database via SSMS (SQL Server Management Studio, version 17.2 for example) and running a T-SQL script such as the example below (change the table name and debug prints), where it is adding the LogType column to an existing table named dbo.Customer.

Moreover, this script can be executed in the Azure Portal as well by navigating to the Azure SQL database > Query editor (Preview) and running the script.

<pre><code>IF EXISTS(SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('dbo.Customer') AND name='LogType')
BEGIN
 PRINT 'Column LogType already exists on table dbo.Customer and it is configured properly.'
END
ELSE
BEGIN
 PRINT 'Adding column LastName to table dbo.Customer...'

 ALTER TABLE dbo.Customer
 ADD LogType VARCHAR(100) NOT NULL
END
PRINT '--- DONE ---'
GO
</code></pre>

<hr>

--- Option 2 ---

Another option would be manually adding the LogType column to the table, which can be accomplished by connecting to the Azure SQL server/database using SSMS, right-click the table name and choosing design. Then, adding the new column.

I'm developing an ASP.NET Core MVC web application using C#. I've deployed my application only once to Azure and used an Azure SQL Database to store the application's data. I made local changes to the database (by adding an extra column called <code>LogType</code> to a table called <code>Logs</code> in the database) and applied migration, and everything workes just fine, locally. I redeployed my application to Azure and it was successful with no errors. However, I keep getting an Sql exception when I browse to the website:

<blockquote>
 SqlException: Invalid column name 'LogType'.
</blockquote>

So I'm asking how can I apply the migration and update the Azure SQL database to reflect my local changes?

Azure SQL database column not updated after redeployment of ASP.NET Core MVC Website

SQL数据库

SQL Server

数据库

服务器

我正在使用C#开发一个ASP.NET核心MVC web应用程序。我只将我的应用程序部署到Azure一次，并使用Azure SQL数据库来存储应用程序的数据。我对数据库进行了本地更改(向数据库中名为Logs的表中添加了一个名为LogType的额外列)，并应用了迁移，一切在本地都运行得很好。我将我的应用程序重新部署到Azu...

问在重新部署ASP.NET核心MVC网站后，Azure SQL数据库列未更新
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在重新部署ASP.NET核心MVC网站后，Azure SQL数据库列未更新EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在重新部署ASP.NET核心MVC网站后，Azure SQL数据库列未更新
EN