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中AsEnumerable和AsQueryable的区别
  
linq中group by
  
Linq操作Datable
  
linq中延迟执行
  
使用 LINQPad 调试linq以及lambda表达式
  
linq xml 查询
  
list使用linq排序
  
datatable linq查询
  
如何查看linq生成的sql
  
LINQ中Aggregate的用法
  
linq 排序
  
linq 数据类型转换
  
linq distinct去重
  
Linq中select查询
  
linq中let
  
LINQ TO SQL 中join
微信（微信分身）
双十二（双十二和双十一哪个划算）
佛肚竹盆景的养护之道（佛肚竹盆景的养护之道）
包水饺（包水饺手法怎么包视频）
越南河粉（越南河粉来自哪里）
按这几方面养护佛肚竹盆景，保证枝叶繁茂，造型优美（按这几方面养护佛肚竹盆景）