类型 查询变量= from 临时变量 in 集合对象或数据库对象
[where 条件表达式]
[order by 条件]
select 临时变量中被查询的值
[group by 条件]
linq的分类:linq to objects,linq to datasets,linq to sql,linq to entities,linq to XML
下面是代码练习:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
namespace _71_linq交叉连接
{
class Program
{
static void Main(string[] args)
{
//声明两个CHAR类型的数据源
char[] upperCase = { 'A', 'B', 'C' };
char[] lowerCase = { 'x', 'y', 'z' };
var joinQuery1 =
from upper in upperCase
from lower in lowerCase
select new { upper, lower };
var joinQuery2 =
from lower in lowerCase
from upper in upperCase
select new { upper, lower };
foreach (var pair in joinQuery1)
{
Console.WriteLine(string.Format("{0}匹配{1}", pair.upper, pair.lower));
}
foreach (var pair in joinQuery2)
{
Console.WriteLine(string.Format("{0}匹配{1}", pair.lower, pair.upper));
}
Console.ReadKey();
}
}
}