1: using System;
2: using System.Collections.Generic;
3: using System.Linq;
4: using System.Text;
5: using System.Threading.Tasks;
6:
7: namespace EF6_ManyToManyAndSelf
8: {
9: class Program
10: {
11: static void Main(string[] args)
12: {
13: using (var context = new ProductContext())
14: {
15: var product1 = new Product { ProductName = "美容業零售管理系統", Price = 59888M };
16: var product2 = new Product { ProductName = "窗簾業ERP系統", Price = 3500000M };
17: var product3 = new Product { ProductName = "玩具製造業ERP系統", Price = 6700000M };
18: product2.RelatedProducts.Add(product3);
19: product1.RelatedProducts.Add(product2);
20: context.Products.Add(product1);
21: context.SaveChanges();
22: }
23: using (var context = new ProductContext())
24: {
25: var product2 = context.Products.First(p => p.ProductName == "窗簾業ERP系統");
26: Console.WriteLine("Product: {0} ... {1}", product2.ProductName, product2.Price.ToString("C"));
27: Console.WriteLine("Related Products");
28: foreach (var prod in product2.RelatedProducts)
29: {
30: Console.WriteLine("\t{0} ... {1}", prod.ProductName, prod.Price.ToString("C"));
31: }
32: foreach (var prod in product2.AboveProducts)
33: {
34: Console.WriteLine("\t{0} ... {1}", prod.ProductName, prod.Price.ToString("C"));
35: }
36: }
37:
38: Console.ReadKey();
39: }
40: }
41: }
