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 EmployeeDepartmentEmployee 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.

Abhinav Pal · Answer

Hello Sir Thanks for showing interest.Sir First of all I am not uploading data through XML and not even providing data with static binding. I am fetching data through database using LinQ  ASP.Net C#.Net. Problem I am Stuck in when i pick the whole table data i.e is not storing in my C# get & set properties. I am able to do this with using Iqueriable but this is not working in web Services.

Mukesh Kumar · Answer

Hi You can return the class object or you can get the record and bind it to Employee properties one by one using foreach loop. or try like the using linq public static Person ReadPerson ( xmlpath ) { XDocument xd = XDocument . Load ( xmlpath ); XElement element = xd . Descendants ( person ). First (); return new Person { FirstName = element . Element ( firstname ). value  LastName = element . Element ( lastname ). value }); } Hope this will help you. thanks

Srinivas Rao · Answer

class employee{ public int eid(get; set;} public string ename {get; set;} public string edept{get; set;} public int ename {get; set;} } class program { static void main(string[] as) { employee obj1=new employee() { eno=1001 ename=john edept=clerk salary=3000}; employee obj1=new employee() { eno=1002 ename=mark edept=manager salary=5000 }; employee[] emparray=new employee(2); emparray[0]=obj1; emparray[1]=obj2; for(int i=0; i { employee e = emparray[i]; if(e.salary>5000) { console.WritLine(e.eid +e.name+ +e.salary+ +e.dept); console.WriteLine(-----------------------); } } console.readkey(); }

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