Loading

Get controller action linq query for complex binding model

Get controller action linq query for complex binding model

ribha shakoor

6y806.NET

I need to convert static query of complex model binding to the dynamic LINQ query in controller action to get data from database through EF

This is my Model

public class DepartmentViewModel
{
public int DepartmentId { get; set; }
public string Name {get; set;}
public List stdList { get; set; }
public DepartmentViewModel()
{
stdList = new List();
}
}
public class StdListModel
{
public int ID { get; set; }
public string Name { get; set; }
}

and controller is as:

public ActionResult Index()
{
List list = new List();
DepartmentViewModel dept = new DepartmentViewModel();
dept.DepartmentId = 1;
dept.Name = "Department 1";
dept.stdList.Add(new StdListModel() { ID = 1, Name = "Some Name" });
dept.stdList.Add(new StdListModel() { ID = 2, Name = "Another Name" });
list.Add(dept);
return View(list);
}

i need to change this controller action static list to dynamic linq query to get data from database EF and bind to Model.

3 Replies

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

Ashutosh Gupta6y ago
Ifirst create your EF and scafold your EF to create all models.then create new controller map with your model.
private readonly EFDBContext _context;
public YourController(EFDBContext context)
{
_context = context;
}
public async Task Index()
{
return View(await _context.DBtables.ToListAsync());
}
[HttpPost]
public async Task Create(DBtable table)
{
if (ModelState.IsValid)
{
_context.Add(table);
await _context.SaveChangesAsync();
return RedirectToAction(nameof(Index));
}
return View(table);
}
ribha shakoor6y ago
I pass it through Ajax. Thanks
Jenith Thakkar6y ago
Hi
Have you got the answer or still finding it?