.netdatabasepublishdatabase-projectdacpac
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":
- Length of substring matched by culture-sensitive String.IndexOf method
- Converting GUID to Integer and Back
- Split "Path Variable" string in a Dictionary in c#
- How to use the Task.ContinueWith, to avoid closing the console window?
- How do I run EF Core ExecuteUpdateAsync and add a new entity as part of that update?
- What is the best data type to use for money in C#?
- How to suppress warning for all derived types?
- Azure AD, AuthenticationTicket Claims
- What's the deal with char.GetNumericValue?
- C# fastest intersection of 2 sets of sorted numbers
- Saving an ArrayList of custom objects to user settings
- Code Folding with custom Lexer (ScintillaNET)
- How to compare two Json objects using C#
- System.IO.FileInfo and Relative Paths
- Manually prevent new rows in WPF DataGrid
- How does a race condition occur?
- Does the .net framework have a build-in method to convert from degrees to radians?
- Why .NET Core introduced Autofac since it has dependency control system?
- How do I check if a filename matches some wildcard pattern?
- Token Request Failing and Returning error invalid grant
- Bug in .NET MAUI Custom ScrollView for iOS
- IIS server error .Server Error in '/' Application
- How to iterate over ReadOnlySpan in F#?
- Shared AssemblyInfo for uniform versioning across the solution
- Adding classes to Blazor(Razor) Validation
- Correct way to link lssl and lcrypto for a static lib
- dotnet publish --self-contained -> running the app still asks for .net installation
- DataTable already belongs to another DataSet
- Read connection string from web.config
- Split String into smaller Strings by length variable