setp 1 :::::: 

Scaffold-DbContext "Data Source=.;Initial Catalog=CMS;Persist Security Info=True;User ID=swera;Password=1122333;" Microsoft.EntityFrameworkCore.SqlServer   -Context NWContext  -OutputDir Models/DB -ContextDir Models/Context  -Tables Account

setp 2 :::::: 

Update existing models

 Scaffold-DbContext "Data Source=.;Initial Catalog=CMS;Persist Security Info=True;User ID=swera;Password=1122333;"  -Provider Microsoft.EntityFrameworkCore.SqlServer   -Context NWContext  -OutputDir Models/DB -ContextDir Models/Context -Tables Aaa,Account  -Force

setp 3  ::::::  Add class CMSContextExt :::::: 

   public partial class CMSContext : DbContext

    {

    public virtual DbSet<MySPModel> MySP { get; set; } // your new DbQuery

    }

Sep 4  :::::: Call Proc 

  var mLoginUser = new SqlParameter("User", "admin");

    var mLoginPassword = new SqlParameter("Password", "admin");

            var empRecord = _logCMS.SpGetbyLogin.FromSqlRaw("EXEC dbo.SpGetbyLogin @User, @Password", new SqlParameter[] { mLoginUser, mLoginPassword }).ToList();

To Download  from  Click here

Step 2 

private readonly StudentContext _logger1;

  public WeatherForecastController(ILogger<WeatherForecastController> logger, StudentContext logger1 = null)

        {

            _logger = logger;

            _logger1 = logger1;

        }

 [HttpGet]

        public IEnumerable<WeatherForecast> Get()

        {

            var rng = new Random();

            var ss= _logger1.Cities.ToList();

            var ss1 =  _logger1.GetProcedures().SpGet_AccountAsync().Result.ToArray();

           // var ss1 =  _logger1.GetProcedures().SpGetbyLogin_Student_UsersAsync("admin","123").Result.ToArray();

            return Enumerable.Range(1, 5).Select(index => new WeatherForecast

            {

                Date = DateTime.Now.AddDays(index),

                TemperatureC = rng.Next(-20, 55),

                Summary = Summaries[rng.Next(Summaries.Length)]

            })

            .ToArray();

        }