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.

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

Answers (3)