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":
- How to determine if a property is required?
- .NET 4.5 changing how Response.IsRequestBeingRedirected behaves on Ajax calls - why?
- CancellationToken with async Dapper methods?
- How to check if a number is a power of 2
- How to stop Visual Studio from adding IIS Express to launchsettings
- How do I create a generic converter for units of measurement in C#?
- WinUI 3 Community Toolkit: Undefined namespace XAML
- The constraint reference 'string' could not be resolved to a type. (netcoreapp3.0)
- "File Not Found" while trying to compile an RC file (probably dumb mistake)
- Using Snyk Build Task in Azure DevOps Pipeline Error for .Net 8 Project
- How to conditionally use the 'default' color in MAUI?
- Automatically Install Module/Extension in DNN (DotNetNuke)
- Can you explain difference between StrictMock and Partialmock?
- Stubbing a read only property with Rhino Mocks
- Retrieve the current view name in ASP.NET MVC?
- How to Use UnsafeAccessor to Check if Autofac.Core.Lifetime.LifetimeScope IsDisposed in .NET 8?
- How do I convert hexidecimal to decimal using C# & BigInt?
- How do I truncate a .NET string?
- KERNELBASE.dll Exception 0xe0434352 offset 0x000000000000a49d
- .NET MAUI Hybrid Blazor Copy to Clipboard
- How to bind the IsEnabled property to an OR of two values?
- error MSB3073: The command "npm install" exited with code 1
- CSharp Console - Account Login
- EF Core 9 .HasConversion
- How do strings work when shallow copying something in C#?
- How to set the target framework to v2.0 or v3.5 instead of 4.0 when compiling a program from a source file?
- How is it possible to see C# code after compilation/optimization?
- Start exe even with missing dependency dlls?
- Using Action(Of T...) over a custom delegate syntax for readability
- Is C# compiler not reporting all errors at once at each compile?