or
var usaOrders = from od in OrderDetailswhere od.Order.Customer.Country == "USA"select new { Company = od.Order.Customer.CompanyName, OrderDate = od.Order.OrderDate, OrderID = od.OrderID, Product = od.Product.ProductName, UnitPrice = od.UnitPrice, Quantity = od.Quantity, Discount = od.Discount, Extended = od.UnitPrice * od.Quantity * ( 1M - (decimal)od.Discount )};Dim usaOrders = _ Where od.Order.Customer.Country = "USA"'======================================================='Service provided by Telerik (www.telerik.com)'Conversion powered by NRefactory.'Twitter: @telerik, @toddanglin'Facebook: facebook.com/telerik'=======================================================Dim usaOrders = from od in OrderDetails _ Where od.Order.Customer.Country = "USA" _ select _ Company = od.Order.Customer.CompanyName, _ OrderDate = od.Order.OrderDate, _ OrderID = od.OrderID, _ Product = od.Product.ProductName, _ UnitPrice = od.UnitPrice, _ Quantity = od.Quantity, _ Discount = od.Discount, _ Extended = od.UnitPrice * od.Quantity * ( 1 - od.Discount )