using System; using System.Collections; using System.Collections.Generic; using System.Diagnostics; using System.Linq; //csc LINQ_List_Any_Distinct1.cs /* https://msdn.microsoft.com/en-us/library/bb383977.aspx */ namespace ConsoleApplication2 { class ObjectFacotry { public int empno { get; set; }// Properties public String ename { get; set; } public String job { get; set; } public int manager { get; set; } public String hiredate { get; set; } public double sal { get; set; } public double Comm { get; set; } public int deptno { get; set; } ArrayList list = new ArrayList(); public List cEmp() { return new List { new ObjectFacotry { empno =7369, ename="SMITH ", job="CLERK" , manager= 7902, hiredate="1980-12-17",sal = 800 ,Comm= 00.00 , deptno= 20}, new ObjectFacotry { empno =7499, ename="ALLEN ", job="SALESMAN", manager= 7698, hiredate="1981-02-20",sal = 1600 ,Comm= 300.00 , deptno=30}, new ObjectFacotry { empno =7521, ename="WARD ", job="SALESMAN", manager= 7698, hiredate="1981-02-22",sal = 1250 ,Comm= 500.00 , deptno=30}, new ObjectFacotry { empno =7566, ename="JONES ", job="MANAGER ", manager= 7839, hiredate="1981-04-02",sal = 2975 ,Comm= 00.00 , deptno=20}, new ObjectFacotry { empno =7654, ename="MARTIN ", job="SALESMAN", manager= 7698, hiredate="1981-09-28",sal = 1250 ,Comm= 1400.00 , deptno=30}, new ObjectFacotry { empno =7698, ename="BLAKE ", job="MANAGER ", manager= 7839, hiredate="1981-01-05",sal = 2850 ,Comm= 00.00 , deptno= 30}, new ObjectFacotry { empno =7782, ename="CLARK ", job="MANAGER ", manager= 7839, hiredate="1981-06-09",sal = 2450 ,Comm= 00.00, deptno=10}, new ObjectFacotry { empno =7788, ename="SCOTT ", job="ANALYST ", manager= 7566, hiredate="1987-04-19",sal = 3000 ,Comm= 00.00 , deptno=20}, new ObjectFacotry { empno =7839, ename="KING ", job="PRESIDENT",manager= 0000, hiredate="1981-11-17",sal = 5000 ,Comm= 00.00 , deptno=10}, new ObjectFacotry { empno =7844, ename="TURNER ", job="SALESMAN", manager= 7698, hiredate="1981-09-08",sal = 1500 ,Comm= 00.00 , deptno=30}, new ObjectFacotry { empno =7876, ename="ADAMS ", job="CLERK" , manager= 7788, hiredate="1984-07-13",sal = 1100 ,Comm= 00.00 , deptno= 20}, new ObjectFacotry { empno =7900, ename="JAMES ", job="CLERK", manager= 7698, hiredate="1981-06-09",sal = 950 ,Comm= 00.00 , deptno=30}, new ObjectFacotry { empno =7902, ename="FORD ", job="ANALYST", manager= 7566, hiredate="1981-12-03",sal = 3000 ,Comm= 00.00 , deptno=20}, new ObjectFacotry { empno =7934, ename="MILLER ", job="CLERK" , manager= 7782, hiredate="1982-01-23",sal= 1300 ,Comm= 00.00 , deptno= 10}, }; } } class Program { static void Main(string[] args) { ObjectFacotry of1 = new ObjectFacotry(); List listempdb = of1.cEmp(); ArrayList ar1 = new ArrayList(); foreach (var v1 in listempdb) { ar1.Add(v1.ename + " " + v1.job + " \t" + v1.deptno); } IEnumerable names = from p in listempdb where p.job.Any() select p.job ; IEnumerable dnames = names.Distinct(); //IEnumerable query = ar1.Cast().Distinct().Select(e1 => e1); Console.WriteLine("---Feeding ArayList with List-- "); foreach (string name in names) { Console.WriteLine(name + " :"+ name.Length); } Console.WriteLine("---IEnumerable dnames = names.Distinct();-- "); foreach (string str1 in dnames) { Console.WriteLine(str1); } // Console.ReadLine(); } } }