linq基本运用

       linq访问sql

  //实例化一个自动生成类的实例
            linqtextDataContext lc = new linqtextDataContext();
            //linq语句
            var query =
                from proj_awd in lc.Project_Award where proj_awd.ID > 10 select proj_awd;
            //linq查询结果为project_Award的类类型
            foreach (Project_Award pa in query)
            {
                Console.WriteLine(pa.ProjectID);
            }
            Console.ReadLine();

 

 

 

 

 

 

 

 

linq访问对象

//

//定义一个类类型的数值，数组中包含多个类实例为数值元素

     stu[] student = new stu[]
            {
                new stu{ID=1,name="www"},
                new stu{ID=2,name ="rrr"},
                new stu{ID=3,name="III"}
            };

 

//linq语句
            var query =
                from dddd in student where dddd.name.Contains("r") select dddd;

 

//query.toarray接受一个类类型参数此方法返回一个类类型数值，将其赋予定义的stu类型数值list
            stu[] list = query.ToArray<stu>();

.//循环遍历数组

            foreach (stu ssd in list)
            {
                Console.WriteLine(ssd.name);
            }
            Console.ReadLine();

 

//定义一个类 定义两个属性
  class stu
        {
            public int ID { get; set; }
            public string name { get; set; }
        }

 

 

 

 

 

 

 

//linq访问数组

//from是定义一个变量

int[] iiu = new int[] { 1,2,3,4,5,6,7,8,9,10};
            var query =
                from ll
                in iiu
                where ll > 2
                select ll;
            foreach (int jj in query)
            {
                Console.WriteLine(jj);
            }
            Console.ReadLine();