How to retrieve table values from database one by one in mvc

Question

Hi i want to retrieve particular table values from database and need to assign each values to each variable in mvc5. My question is little tricky and maybe some times it will confuse you dudes. I will explain my issue clearly

This is my employee table and it contain 2 fields called EmployeeID and DisplayName . EmployeeID is primary key. What i need is i want to retrieve these tables values one by one and assign that values (Which i retrieve one by one from table ) to variables.

Eg

 var1 = yasin  var2 = rajan..

I tried one method . In that method i gave hardcode to find each Id one by one. But hardcode is not correct way for professional developer right.

I tried one method . In that method i gave hardcode to find each Id one by one. But hardcode is not correct way for professional developer right.

Eg:

 var yasinempid = (from emp in db.Employees where emp.DisplayName == "Yasin" select emp.EmployeeID).FirstOrDefault();

Now i want to find the ID of yasin employee.so i gave yasin value directly in the query. But this is not correct way because i have limited no of employees so i can able to find employee ID easily . But i have lot of employees means this hardcode value is not correct way and also it wont give correct solution right . So that i need alternate solution for this problem.

I tried my level best to explain this issue. Any one understand my issue and help me to resolve this problem.

Advance thanks.

Sneha Dhandapani · Answer

Select Count(VisitingID)As CountEmployee from View_VisitorsForm Group by Employee this is my query which i wrote in sql . can you tell how i write this query in front end of mvc I like to display this same thing so how i write grou query in controller and show that values using view

Francis · Answer

Howmany variablesyou will create?AFAIK you can't createthe variable dynamically in C#. Instead of that you can store the values inside an Hash table as Key/value pair and getit. Let me know your thought.

Sneha Dhandapani · Answer

Actually what i want is var 1= yasin var 2 = Rithubaran var3 = jagadesshwaran like that that is var 1 = yasinID(C19EF560-9BC2-490A-9E92-3D694EC9DC05) i need each Employee ID and i want to assing that each employee ID to each variable

Francis · Answer

I hopeyou want to loop thru theList of Employees and get the employees name andid. If so try the below: int EmpId; string EmpName; foreach (Employee emp in Employees) { EmpId=emp.EmployeeID; EmpName=emp.DisplayName; } Let me know if you need any thing more.