error and solutions.txt

/*
Add Migration =>  add-migration 'migrationName'
Update Database =>  update-database
Add Migration Seed Only => add-migration SeedOnly

Scaffold-DbContext "Server=172.17.107.209; Database=SieveHR; User Id=sa; Password=123; Trusted_Connection=False; MultipleActiveResultSets=true;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models



some things should be copied from > Preclinic-Hospital-Bootstrap4-Admin

Krestal Server Error
------------------------------
SocketException: An attempt was made to access a socket in a way forbidden by its access permissions.

Solution
------------------------------
net stop hns
net start hns


View Problem
------------------------------

 public partial class createatestview : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.Sql(@"CREATE VIEW dbo.COMP_DEPT_SECT as select c.COMP_NAME,DEPT_NAME,SECT_NAME from dbo.HR_COMPANY c join dbo.HR_DEPARTMENT d on c.ID=d.COMP_ID join dbo.HR_SECTIONS s on d.ID=s.DEPT_ID");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.Sql(@"DROP VIEW dbo.COMP_DEPT_SECT");
        }
    }


*/