Wednesday, 21 August 2013

iTextSharp Linq Query

iTextSharp Linq Query

is there a way to print linq queries with itextsharp ? Like below sample?
from cx in OrderDetails
join dx in Orders on cx.OrderID equals dx.OrderID
join fx in Customers on dx.CustomerID equals fx.CustomerID
join px in Products on cx.ProductID equals px.ProductID
group cx by new {cx.OrderID,dx.CustomerID,px.ProductID} into g
where g.FirstOrDefault().ProductID==3
select new
{
ProductName=g.FirstOrDefault().Product.ProductName,
UnitsInStock=g.FirstOrDefault().Product.UnitsInStock,
Discount=g.FirstOrDefault().Discount,
OrderDate=String.Format("{0:d}",g.FirstOrDefault().Order.OrderDate),
Quantity=g.FirstOrDefault().Quantity,
UnitPrice=String.Format("{0:c}",g.FirstOrDefault().UnitPrice)
}

No comments:

Post a Comment