How to Implement LINQ Queries in Collection Data

Ratings:
(4)
Views:0
Banner-Img
  • Share this blog:

Implementing LINQ  Queries on Collection Data

Create  a new Console Application   (CA Sample 2)  àAdd a new class (Name) à Employee Write the following code using Auto implemented properties.

Name Space CA Sample 2
{
Class Employee
{
Public Int PEMP ID {set; get;}
Public String PE name  {set; get ;}
Public String Designation  {set; get ;}
Public Date time PDOJ  {set; get ;}
Public Double Salary  {set; get ;}
Public Int p Dept no {set; get ;}
}
}

Learn the core features of ASP.NET Training and become master with our expertise tutorials.

Create a new class in this Application with the name Examples:-

Write the following code

Namespace CA Sample 2
{
Class Example2
{
Static void Main ()
{
List <Employee> emp list = new list <Employee> ()
{
New  employee  (P emp id = 101, P Ename = “naveen”, Pdesigen = “pl”, p Doj = new date (2012,03,02),p salary = 1200, pdeptno =10);
New  employee  (P emp id = 102, P Ename = “raj”, Pdesigen = “tl”, p Doj = new date (2012,04,01),p salary = 1300, pdeptno =20);
New  employee  (P emp id = 103, P Ename = “sai”, Pdesigen = “ds”, p Doj = new date (2012,05,03),p salary = 1300, pdeptno =10);
};
Var R = from X in Emp list where x.pdept no = 10  Select x;
Console. Write line (“Dept no 10 employee data is :-”);
Console. Write line (“Empid/t, ename/t, designation/t, doj/t salary/t……………”);
Foreach (var I in R)
{
Console. Write line (i.pempid +’/t’  + i. pename +’/t’ +i.pdesig +’/t’+ i.p doj +’/t’+ i.p salary);
}
Console. Read ();
}
}
}

Output :-

Emp id                       E name                   designation                  Doj         salary 101                                  -                               -                                   -            1200 103                                  -                                -                                  -              1400   2If we want to only required fields we use query like. 2Var R = from  x in emplist where x. p dept no = 10 select  x.ename, x. designation, x.esalary;

For indepth understanding click on
 

 

You liked the article?

Like : 0

Vote for difficulty

Current difficulty (Avg): Medium

Recommended Courses

1/15

About Author
Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.


Stay Updated


Get stories of change makers and innovators from the startup ecosystem in your inbox