while creating list for both tables user and user address I m getting the below error for both the tables Code Description Project File Line Suppression State Error CS0029 Cannot implicitly convert type 'System.Collections.Generic.List ' to 'System.Collections.Generic.List ' controller: public ActionResult Dashboard() { nsrouteEntities obj = new nsrouteEntities(); List userlist = obj.Users.ToList(); List useraddresslist = obj.UserAddresses.ToList(); getting error in this bold text return View(); } can anyone tell me on how to display data from multiple tables in a single table of a view in mvc5

Your error says the solution itself, There are two classes defined in your project with the name UserAddress and Users , first in the DataAccess folder (where you have generated your entity) second Perhaps in the root folder directly Chcek the namespace of user in List , here this User is pointing to other User class than to your User entity in DataAccess folder. you can do something like below var users= Obj.Users.ToList(); List userList= new List (); { foreach (var item in users){ User user= new User() // this is in your model/ viewModel / idk directly in project user.prop1=item.Prop1; ----- userList .Add(user); } YourViewModel vm= new ViewModel(); vm.Users= userList ; return view(vm) }

Answer

getting error in list while displaying data in a single view

yash patel

451

while creating list for both tables user and user address I m getting the below error for both the tables

Code Description Project File Line Suppression State Error CS0029 Cannot implicitly convert type 'System.Collections.Generic.List<nsroute.DataAccess.UserAddress>' to 'System.Collections.Generic.List<nsroute.UserAddress>'

controller: