linq中join用法
类别:编程学习 浏览量:3696
时间:2014-4-20 linq中join用法
linq中join用法一、linq中join方法原型
public static IEnumerable<TResult> Join<TOuter, TInner, TKey, TResult>(
this IEnumerable<TOuter> outer,
IEnumerable<TInner> inner,
Func<TOuter, TKey> outerKeySelector,
Func<TInner, TKey> innerKeySelector,
Func<TOuter, TInner, TResult> resultSelector)
二、先创建linq中join方法的实验用例
class Customer
{
public int CustomerId { get; set; }
public string Name { get; set; }
public int Age { get; set; }
}
class Product
{
public int ProductId { get; set; }
public string Name { get; set; }
public string Origin { get; set; }
}
class Order
{
public int OrderId { get; set; }
public int CustomerId { get; set; }
public List<Product> Products { get; set; }
}
static List<Customer> customers;
static List<Product> products;
static List<Order> orders;
public static void CreateEntities()
{
customers = new List<Customer>{
new Customer(){ CustomerId = 1, Name = "CA", Age=13},
new Customer(){ CustomerId = 2, Name = "CB", Age=13},
new Customer(){ CustomerId = 3, Name = "CC", Age=13},
new Customer(){ CustomerId = 4, Name = "CD", Age=13}
};
products = new List<Product>{
new Product(){ ProductId = 1, Name = "PA", Origin="P1" },
new Product(){ ProductId = 2, Name = "PB", Origin="P2" },
new Product(){ ProductId = 3, Name = "PC", Origin="P1" },
new Product(){ ProductId = 4, Name = "PD", Origin="P3" }
};
orders = new List<Order>{
new Order(){ OrderId = 1 , CustomerId =1,
Products = new List<Product>{
new Product(){ ProductId = 2, Name = "PB", Origin="P2" },
new Product(){ ProductId = 3, Name = "PC", Origin="P1" }
}},
new Order(){ OrderId = 2 , CustomerId =1,
Products = new List<Product>{
new Product(){ ProductId = 3, Name = "PC", Origin="P1" },
new Product(){ ProductId = 4, Name = "PD", Origin="P3" }
}},
new Order(){ OrderId = 3 , CustomerId =3,
Products = new List<Product>{
new Product(){ ProductId = 4, Name = "PD", Origin="P3" }
}},
new Order(){ OrderId = 4 , CustomerId =2,
Products = new List<Product>
您可能感兴趣
- Linq中select查询
- LINQ中Aggregate的用法
- linq中join用法
- Linq中的TakeWhile和SkipWhile
- datatable linq查询
- linq中group by
- 如何查看linq生成的sql
- Linq中where查询
- 使用 LINQPad 调试linq以及lambda表达式
- LINQ TO SQL 中join
- linq distinct去重
- list使用linq排序
- linq中AsEnumerable和AsQueryable的区别
- linq not in 查询
- linq 数据类型转换
- linq 排序
- 沪上这16所高校 萌新 礼包开箱 哪一款让你心动(沪上这16所高校萌新)
- 她救了被绑架的他,而这一切竟是一场阴谋...(她救了被绑架的他)
- 冬季养殖这6种阴生植物,方便又好养,你家有么(冬季养殖这6种阴生植物)
- 阴生植物为什么不怕照不到阳光(阴生植物为什么不怕照不到阳光)
- 阴生环境 耐阴地被植物,你知道哪些(阴生环境耐阴地被植物)
- 常见的喜阴植物有哪些 养室内盆栽就在这里选(常见的喜阴植物有哪些)