Build The Lanes - CSc 174 Group Project
To Rebuild the whole database do the following
-
Delete the files in the Migrations directory
dotnet ef migrations remove
-
Delete the entire remote database webapp.
dotnet ef database drop
-
Adds a new migration with the name Initial.
dotnet ef migrations add Initial
-
To autogenerate the sql file/script.
dotnet ef migrations script -o initial.sql
-
Updates the database to the last migration or to a specified migration.
dotnet ef database update
Donators.js EngineerCertifications.js EngineerDegrees.js Projects.js Responsibilities.js Staffs.js ApplicableStandards.js Donates
Scaffold Database
Scaffold-DbContext "<ConnectionString>" Microsoft.EntityFrameworkCore.SqlServer -t <tablename> -f
dotnet ef dbcontext scaffold "Data Source=build-the-lanes-0.cz837oegnsiw.us-west-1.rds.amazonaws.com,1433;Initial Catalog=webapp;User id=admin;Password=test1234" Microsoft.EntityFrameworkCore.SqlServer --context-dir Helpers --output-dir Models -t Donates -t ApplicableStandards -f
Reverse Engineer the Database maybe? Will have to try maybe
This could be an answer to my prayers. I could possible take the whole data model from the SQL Marina and Hecotr write
dotnet ef dbcontext scaffold "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=Chinook" Microsoft.EntityFrameworkCore.SqlServer