1
Answer

How can i select specific records from database in asp MVC?

Amit Kumar

Amit Kumar

7y
180
1
In the following code, I want to retrieve all those records whose Q_ID equals to the ID.
Currently, I Select whole records instead of few.
 
Please help me to solve this problem.
  1. public ActionResult Solution(int ID)  
  2. {  
  3. Answers ans_obj = new Answers();  
  4. List<Ans_Table> dbobj= db.Ans_Table.ToList();  
  5. List<Answers> ansobj = dbobj.Select(x => new Answers  
  6. {  
  7. Answer = x.Answer,  
  8. Q_ID=x.Q_ID,  
  9. U_ID=x.U_ID  
  10. }).ToList();  
  11. return View();  
  12. }
Answers (1)
0
Manas Mohapatra

Manas Mohapatra

NA 29.3k 3.3m 7y
var is a keyword which is anonymous type and was introduced in C# 3.0. var is used to declare implicitly typed local variable means it tells the compiler to figure out the type of the variable at compilation time. A var variable must be initialized at the time of declaration which decide data type.
 
It is mostly helpful when you write LINQ statements and you need customised results, follow below snippets: 
  1. var empQuery =   
  2.     from emp in employees  
  3.     select new { prod.Name, prod.Qual};  
  4.   
  5. foreach (var v in empQuery)  
  6. {  
  7.     Console.WriteLine("Name={0}, Price={1}", v.Name, v.Qual);  
  8. }