两对象查询，结合出一个对象：

 

private void MultiFromQuery()

     {   ///构建数据源

         List<UserInfo> ausers = new List<UserInfo>();

         List<UserInfo> busers = new List<UserInfo>();

         for (int i = 1; i < 10; i++)

         {

              ausers.Add(new UserInfo(i,"AUser0" + i.ToString(),"AUser0" + i.ToString() + "@web.com"));

              busers.Add(new UserInfo(i,"BUser0" + i.ToString(),"BUser0" + i.ToString() + "@web.com"));

         }

         ///共包含两个查询，一个查询ID值小于3的用户，另外一个查询ID值大于5的用户

         var value = from au in ausers

                       where au.ID < 3

                       from bu in busers

                       where bu.ID > 5

                       select new {au.Username, bu.Email};

         ///显示查询结果

         foreach (var v in value)

         {

              Response.Write(v.Username + " " + v.Email + "</br>");

         }

     }