AutoMigration : can't ALTER table or column name error

JaySoni 1910 6 Reputation points
2021-03-22T10:44:15.787+00:00

I have some issued in auto-migration approach which is given by M.S. Docs (link is below):
https://learn.microsoft.com/en-us/ef/core/managing-schemas/migrations/applying?tabs=dotnet-core-cli

( My Code )

   var host = CreateHostBuilder(args).Build();  
   using (var scope = host.Services.CreateScope())  
   {  
       var db = scope.ServiceProvider.GetRequiredService<UserInformationContext>();  
       db.Database.Migrate();  
   }  
   host.Run();  

Here using this approach I can't alter my table name and column name or even my column datatype.
why am i faced such a problem ?? give me some ideas to solve me these problems.

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
697 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,375 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions
{count} vote