How to access members of your model to your Controller?

Guest User

6y1.1k.NET

// Index.cshtml
@{
ViewBag.Title = "EventManagement List";
}
EventManagement List
"EventManagementTable" class="display">
@*Semantic UI*@
@*"employeeTable" class="ui celled table">*@
@*Bootstrap*@
@*"employeeTable" class="table table-striped table-bordered">*@
TrainingID
TrainingType
TrainingDescription
Price
Venue
Facilitator
WhoAttend
RSVP
TrainingID
TrainingType
TrainingDescription
Price
Venue
Facilitator
WhoAttend
RSVP
"stylesheet" type="text/css" href="https://cdn.datatables.net/v/dt/dt-1.10.20/datatables.min.css" />
"//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css" rel="stylesheet" />
"https://cdn.datatables.net/1.10.15/css/dataTables.jqueryui.min.css" rel="stylesheet" />
"//cdnjs.cloudflare.com/ajax/libs/semantic-ui/2.2.6/semantic.min.css" rel="stylesheet" />
"https://cdn.datatables.net/1.10.15/css/dataTables.semanticui.min.css" rel="stylesheet" />
"https://cdn.datatables.net/1.10.15/css/dataTables.bootstrap4.min.css" rel="stylesheet" />
@section scripts{
"//cdn.datatables.net/1.10.15/js/jquery.dataTables.min.js">
"https://cdn.datatables.net/1.10.15/js/dataTables.jqueryui.min.js">
"https://cdn.datatables.net/1.10.15/js/dataTables.semanticui.min.js">
"//cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0.0-alpha.6/css/bootstrap.css" rel="stylesheet"/>
"https://cdn.datatables.net/1.10.15/js/dataTables.bootstrap4.min.js">
}

Hi Team

I want to find a way to access my members of model class to my Controller class, when using ApplicationDbContext. The database is attached to my App_Data and has table to it, and want to find a way to access those fields in my Controller class using ApplicationDbContext, can anyone help me if there is a way. Below is my logic so far and screen shot showing what i am aiming to achieve.

//Controller class
using System.Web;
using System.Web.Mvc;
using ContentManagementSystem.Filters;
using ContentManagementSystem.Models;
using Microsoft.AspNet.Identity.EntityFramework;
namespace ContentManagementSystem.Controllers
{
public class DashboardController : Controller
{
public ActionResult _Index()
{
return View();
}
public ActionResult GetList()
{
using(ApplicationDbContext db = new ApplicationDbContext())
{
var emptList = db.Users.
return Json(new { data = emp })
}
}
}
}
// Model class
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Microsoft.AspNet.Identity.EntityFramework;
namespace ContentManagementSystem.Models
{
public class ApplicationUser:IdentityUser
{
public string Email { get; set; }
public bool ConfirmedEmail { get; set; }
}
public class ApplicationDbContext: IdentityDbContext
{
public ApplicationDbContext()
: base("eNtsaOnlineRegistrationDB")
{
}
}
}

16 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User6y ago
Hi Mate

I got this link from CodeProject, had to follow the documentation from step 2 step, missing update of the package seemed relevant and had to re do the command putting -OutputDir Models all were executed well no error. After the update though for the Install-Package Microsoft.EntityFrameworkCore.Tools.

https://docs.microsoft.com/en-us/ef/core/miscellaneous/cli/powershell
Guest User6y ago
2. "eNtsaOnlineRegistrationDB" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\eNtsaOnlineRegistrationDB.mdf;Initial Catalog=master; Integrated Security=True" providerName="System.Data.SqlClient" />
Hi Gupta
I did that was missing an package, of which is i am now getting Keyword not supported 'catalog'. Busy looking at this issue,dont know if my connectionString is correct
Ashutosh Gupta6y ago
i think, it is case sensitive, make sure you type correctly S is captial in Scaffold

Scaffold-DbContext
Guest User6y ago
I got rid of this error, but the problem im still unable to see new Model class under my folder. How i fix it its below install-package Microsoft.EntityFramework.Tools v 3.1.1
Guest User6y ago
Hi Mate
No there is unfortunately please see below for more information. After following Github still no luck even if i try to use this special command scaffold-DBContext "Data Source=(LocalDb)\MSSQLLocalDB; Catalog=eNtsaOnlineRegistrationDB;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer-Verbose it does not compile successfully. Ok i Re ran the command putting the space after SqlServer and got this error, scaffold-DBContext : Exception calling "Start" with "1" argument(s): "The system cannot find the file specified".
PM> scaffold-DBContext "Data Source=(LocalDb)\MSSQLLocalDB; Catalog=eNtsaOnlineRegistrationDB;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer -Verbose
Ashutosh Gupta6y ago
i think there is no Models folder under your solution, create one with name Models and try.
Guest User6y ago
Hi Mates

I ran this new command, i was getting an error, please assist me thanks. Had to look at stackoverflow for these error and did some Install-Packges like EntityFrameworksTools and SqlServer. I had now new error while re -running same command.
Ashutosh Gupta6y ago
scaffold-DBContext "Data Source=(LocalDb)\MSSQLLocalDB; Catalog=eNtsaOnlineRegistrationDB;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer-OutputDir Models

there was one extra ", check with this. it should be excuted without any error..
Guest User6y ago
1. scaffold-DBContext "Data Source="(LocalDb)\MSSQLLocalDB; Catalog=eNtsaOnlineRegistrationDB;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer-OutputDir Models
2. >>
Hi Gupta
I am unable to see from the project folder under Model, my new DbContext. Have i done something wrong on my command? please assist, thanks.
Ashutosh Gupta6y ago
you should be having new DBcontext and models classes generated in your solution.

verify Models folder in your solution if the below command was successfully executed.
Guest User6y ago
1. PM> scaffold-DBContext "Data Source="(LocalDb)\MSSQLLocalDB; Catalog=eNtsaOnlineRegistrationDB;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer-OutputDir Models
How do i then check the naming of my model?
Ashutosh Gupta6y ago
yes nuget package manager console
Guest User6y ago
Hi Gupta

Do i need to use this command via nuget on the console?
Ashutosh Gupta6y ago
Gcobani,

what you are showing is your connection string. you need to use the below command to generate models using this connection string. scaffold-DBContext .............. command will generate all tables into c# class and DBcontext class which will have respective properties etc.
Guest User6y ago
2. "eNtsaOnlineRegistrationDB" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\eNtsaOnlineRegistrationDB.mdf;Initial Catalog=eNtsaOnlineRegistration; Integrated Security=True" providerName="System.Data.SqlClient" />
Hi Gupta

But then how do you see model name once this is executed?

scaffold-DBContext "Data Source="(LocalDb)\MSSQLLocalDB; Catalog=eNtsaOnlineRegistrationDB;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer-OutputDir Models
Ashutosh Gupta6y ago
generate ApplicationDbContext with all model properties. you can execute below command to generate that

scaffold-DBContext "Data Source="give your data source name path";Initial Catalog=dbname;Integrated Security=True" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

this will help you to generate all models classes with your context class. then you will be able to use context.users etc etc

How to access members of your model to your Controller?

EventManagement List