mobileNavlogo
headerlogo

Blog

How to Implement LINQ Queries in Collection Data

21 September, 2018

Related Blogs

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