How the data is retrieved from database using linq in entity framework
The following question is asked in an interview and i don't know the answer.How the data is retrieved from database using linq in entity framework
Any help is appreciated
You must Sign In to post a response.
Category: ASP.Net MVC
How the data is retrieved from database using linq in entity framework
Any help is appreciated
#767741
Hai Rajan,
Entity Framework supports Table, View and Stored Procedure to convert in to classes, members and Methods/Functions.
So once you get the converted C# objects from the database objects, you can use the DataContext class to get the data.
For e.g. There is a table with the name 'Employee' in the database. This table contains EmpId, FirstName and LastName, Salary fields/columns.
Once you convert this table using Entity Framework, the C# class with the name Employee and the public properties with the name EmpId, FirstName, LastName and Salary will get created automatically.
Now to retrieve the data from this Employee table, you just need DataContext class:
This will give the list of employees from the database.
Hope it will be helpful to you.
Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com
Entity Framework supports Table, View and Stored Procedure to convert in to classes, members and Methods/Functions.
So once you get the converted C# objects from the database objects, you can use the DataContext class to get the data.
For e.g. There is a table with the name 'Employee' in the database. This table contains EmpId, FirstName and LastName, Salary fields/columns.
Once you convert this table using Entity Framework, the C# class with the name Employee and the public properties with the name EmpId, FirstName, LastName and Salary will get created automatically.
public class Employee
{
public int EmpId {get; set;}
public string FirstName {get; set;}
public string LastName {get; set;}
public double Salary {get; set;}
}
Now to retrieve the data from this Employee table, you just need DataContext class:
DataContext dc= new DataContext();
List<Employee> employeeList = dc.Employees.ToList();
This will give the list of employees from the database.
Hope it will be helpful to you.
Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com
Return to Return to Discussion Forum