예제 #1
0
        public static void InsertCustomer(
            string id,
            string companyName,
            string contactName = null,
            string contactTitle = null,
            string address = null,
            string city = null,
            string region = null,
            string postalCode = null,
            string country = null,
            string phone = null,
            string fax = null
            )
        {
            using (new UnitOfWorkScope(true))
            {
                Customer customer = new Customer();
                customer.CustomerID = id;
                customer.CompanyName = companyName;
                customer.ContactName = contactName;
                customer.ContactTitle = contactTitle;
                customer.Address = address;
                customer.City = city;
                customer.Region = region;
                customer.PostalCode = postalCode;
                customer.Country = country;
                customer.Phone = phone;
                customer.Fax = fax;

                UnitOfWorkScope.NorthwindContext.Customers.Add(customer);
            }
        }
예제 #2
0
파일: Class1.cs 프로젝트: bnjMichel/waqs
 public static void TestUnion(Customer c)
 {
     var test = c.Orders.Union(c.Orders2).Select(o => o.Id);
 }
예제 #3
0
파일: Class1.cs 프로젝트: bnjMichel/waqs
 public static void LINQJoinIntoMethod(Customer c)
 {
     var q = c.Orders.GroupJoin(c.Orders2, o => o.Id, o2 => o2.Id, (o, o2s) => new { O = o, Os = o2s }).SelectMany(oo => oo.Os.DefaultIfEmpty(), (o, o2) => new {OrderOrder = o, Order2 = o2 }).Select(oo => new { oo.OrderOrder.O.Date, Date2 = oo.Order2.Date });
 }
예제 #4
0
파일: Class1.cs 프로젝트: bnjMichel/waqs
 public static void LINQJoinInto(Customer c)
 {
     var q = from o in c.Orders
             join o2 in c.Orders2 on o.Id equals o2.Id into os
             from o2 in os.DefaultIfEmpty()
             select new { o.Date, Date2 = o2.Date };
 }
 public void DoSomethingWithCustomer()
 {
     var myCustomer = new Customer();
     PrintCustomer(myCustomer);
 }