How to generate Model class and DbContext from existing Data Base using .NET Core
Open the Nuget Manage and run the following command
Scaffold-DbContext Name=DBConnection Microsoft.EntityFrameworkCore.SqlServer -OutputDir Model -Tables KpiSMSLog
Which will only include the table name kpismslog
To specify Name Space
PM> Scaffold-DbContext Name=HostDB Microsoft.EntityFrameworkCore.SqlServer -Namespace ScheduleMonitor -ContextNamespace ScheduleMonitor.Business
Script migration Changes
Script-Migration -From 20200810134651_partyIdentifer_column -To 20201118122724_SAPuserIdColumn
How to reset the Identity column value using SQL
DBCC CHECKIDENT('Bookings', RESEED, 1)