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

Abhinav Pal

11y2.1kLINQ

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhinav Pal11y ago
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 Kumar11y ago

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 Rao11y ago
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();
}