C
C#•2y ago
alkasel#159

EF Core 6 - Create table if not exists by means of Add-Migration

Hi, Let's say I've a database with tables A, B and C. When from packet manager console I issue 
Add-Migration mig1
Update-Database
Add-Migration mig1
Update-Database
The database is correctly created. Howerver, if later on I add a table D to my DbContext, remove previously created migrations and I run 
Add-Migration mig2
Update-Database
Add-Migration mig2
Update-Database
The second command fails with error message 
relation "A" already exists
relation "A" already exists
Is there a way to only add not-existing tables (i.e. create if not exists) using migrations?
2 Replies
Unknown User
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
alkasel#159
alkasel#159•2y ago
Thanks, it worked! it was so simple and I wasted about a day after it... 🤦‍♂️
Want results from more Discord servers?
Add your server
More Posts
Value data not being updated when duplicate version foundCould someone please look through my code? I'm not sure why the program doesn't replace the data of Channel DiscordHi, ID Channel discord or ID message?How Do I add a Xaml Namespace inside another xamlJust adding a using namespace in classes, how do I do that with Xaml? x:Class=Fuire"2._0.AppSheim trying to code a 4 digit password crackerHey! im new to coding i watched a 4 hour course and tried to code my first project but i dont know How to save Checboxes values into single column?I have a view which has a few checkboxes in mvc. i designed them in html inside view. Now I require ReadKey() input question [Answered]```do { Console.ReadKey(); points++; Console.WriteLine(points); } while (Console.ReadKe