linq 数据类型转换

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml.Linq;

namespace WebApplication1
...{
    public partial class Default : System.Web.UI.Page
    ...{
        protected void Page_Load(object sender, EventArgs e)
        ...{
            List<Student> students = new List<Student>()
            ...{
                new Student ...{First="张",
                    Last="三",
                    ID=111,
                    Street="复兴大道338",
                    City="杭州",
                    Scores=new List<int>...{84,97,68,92}},      
                new Student ...{First="张",
                    Last="影",
                    ID=111,
                    Street="复兴大道338",
                    City="云南",
                    Scores=new List<int>...{84,97,68,92}},
                new Student ...{First="张",
                    Last="雨",
                    ID=111,
                    Street="复兴大道338",
                    City="芜湖",
                    Scores=new List<int>...{84,97,68,92}},
            };

            List<Teacher> teachers = new List<Teacher>()
            ...{
                new Teacher ...{First="张",
                    Last="敏",
                    ID=111,
                    City="杭州"},   
                new Teacher ...{First="张",
                    Last="雪",
                    ID=111,
                    City="云南"},
                new Teacher ...{First="张",
                    Last="青",
                    ID=111,
                    City="芜湖"}
            };

            //创建查询
            var peopleInSeattle = (from student in students
                                   where student.City == "芜湖"
                                   select student.First + student.Last)
                                     .Concat(from teacher in teachers
                                             where teacher.City == "芜湖"
                                             select teacher.First + teacher.Last);
            Response.Write("在芜湖的教师和学生:");
            //执行查询
            foreach (var person in peopleInSeattle)
            ...{
                Response.Write(" " + person);
            }
        }

        class Student//学生类
        ...{
            public string First ...{ set; get; }
            public string Last ...{ set; get; }
            public int ID ...{ set; get; }
            public string Street ...{ set; get; }
            public string City ...{ set; get; }
            public List<int> Scores;
        }

        class Teacher//教师类
        ...{
            public string First ...{ set; get; }
            public string Last ...{ set; get; }
            public int ID ...{ set; get; }
            public string City ...{ set; get; }
        }

    }
}

		

List<Student> _list = new List<Student>() 
...{ 
new Student ...{FirstName="Svetlana", LastName="Omelchenko", 
             Unid=111, Scores = new List<int>...{97, 92, 81, 60}},

new Student ...{FirstName="Claire", LastName="O’Donnell", 
             Unid=112, Scores = new List<int>...{75, 84, 91, 39}},

new Student ...{FirstName="Sven", LastName="Mortensen", 

 

  
标签：linq   
 
 



              
上一篇：sql server go语句
                	  
			  
下一篇：svn代码冲突的解决

  
 


  

      您可能感兴趣
				

					

  
Linq中select查询
  
如何查看linq生成的sql
  
LINQ TO SQL 中join
  
datatable linq查询
  
linq中延迟执行
  
linq中let
  
linq not in 查询
  
Linq中的TakeWhile和SkipWhile
  
linq distinct去重
  
linq 数据类型转换
  
Linq操作Datable
  
linq中AsEnumerable和AsQueryable的区别
  
LINQ中Aggregate的用法
  
linq 排序
  
linq中group by
  
使用 LINQPad 调试linq以及lambda表达式
盘点那些年让人称奇的年终奖 最后一个赢辣条毫无悬念（盘点那些年让人称奇的年终奖）
你还没有升职吗 他竟因为几套激励理论，升职了（你还没有升职吗）
某知名企业绩效管理体系及薪酬分配体系操作手册（某知名企业绩效管理体系及薪酬分配体系操作手册）
职场人改不掉这4个习惯，只会越混越穷，一辈子也翻不了身（职场人改不掉这4个习惯）
华为 联想等46家公司笔试面试题，涉及各行各业，建议收藏（联想等46家公司笔试面试题）
（）