private void button42_Click(object sender, EventArgs e) { using (var ctx = new OrderITEntities()) { var p = new EntityParameter("p0", DbType.String) { Value = 11 }; Dump(ctx.ExecuteStoreQuery <OrderDetailProjection>("Select quantity, unitprice, discount from [OrderDetail] d join [order] o on (d.OrderId = d.OrderId) where o.orderid = @p0", 11)); } }
private void button41_Click(object sender, EventArgs e) { using (var ctx = new OrderITEntities()) { Dump(ctx.ExecuteStoreQuery <OrderDetail>("Select * from [OrderDetail]").ToList()); } }