Delete table in database project
I am working on a .NET project which includes a database project (Dacpac).
I am attempting to delete a table, but when I publish the database project, the table is not deleted in the destination database.
I deleted the table in the database project, and as expected result, the table should have been deleted in the destination. However, the result was not as expected.
Solution
If you want the table to be deleted in the destination you need to configure your publish profile to "Drop objects in target but not in source" option. Here where you can activate it.
After selecting 'Publish' on your database project you need to go to the 'Advanced' settings :
Then go to the 'Drop' tab, and check "Drop objects in target but not in source":
- ASP.NET MVC Dynamic Forms
- Where located MAUI iOS *.app builded with VS on Windows
- How do I find the installed .NET versions?
- How do I get the RabbitMQ connectionString in Aspire.NET setup during bootstraping
- Logger message + Serilog = performance issues?
- How to save value into JSON configuration file using Microsoft.Extensions.Configuration?
- ExecuteReader requires an open and available Connection. The connection's current state is Connecting
- How to set large string inside HttpContent when using HttpClient?
- Should .net comments start with a capital letter and end with a period?
- Asp.Net Core Swagger Sort Tags Alphabetically
- powershell - extract file name and extension
- Adding a button to a ComboBox and resizing the inner TextBox editing control
- Change property in async method in WinUI3 project will throw COMException
- IEqualityComparer<T> that uses ReferenceEquals
- Docker-compose with .NET Core unreachable
- How to change column header's background color when using WPF datagrid
- What are the "OEM" keys in the System.Windows.Forms.Keys enumeration?
- Could not load file or assembly 'System.Web.Mvc' . How to use the correct reference?
- How to get all possible AppServicePlan configurations from an Azure subscription?
- Within Windows, what explicitly happens when I double-click on a file in Windows Explorer?
- Only Select A Specific Fingerprint
- Extract Embedded Image Object in RTF
- Numerical formatting using String.Format
- How to make .NET Framework Test Adapter follow Binding Redirects
- How to Compare Variables in the Azure Library-Variable Group
- ASP.NET Core 8 TypedResults.File with ETag always returning result from browser disk cache
- TraceRoute and Ping in C#
- Expected semicolon inside if statement
- ASP.Net error: "The type 'foo' exists in both "temp1.dll" and "temp2.dll"
- How can I customize category sorting on a PropertyGrid?