Store Table data in "GET & SET" properties using C# and LinQ

Question

Hello Everyone,

 

I have a table in database with some data. i have created "get & set" properties for that table in C# in a class. I wish to get the whole data from database and store that data first in my properties what i created.

 

Ex-: Have table with four columns EmployeeId, EmployeeName, EmployeeDepartment,Employee Salary. Now I created properties in C# for that table using Get & Set method.Now i wish to store that table data in our properties. Using GetAll() method. 

 

Technology-: Asp.Net, C#, LinQ, EntityFramework, Sql Server 2008.