I am facing problems converting a relatively complex SQL query to a LinqToSQL statement. There are lots of examples on the web, but none involve 'joins' + 'where' + 'group'
Here is my query I am trying to use Linq for :
count(*) as NumOfOrders,
sum(Customers.BillingAmount) as BillingAmount,
sum(Orders.OrderTotal) as OrderTotal
left outer join Orders on Customers.CustomerID = Orders.CustomerID
Where Customers.Name = @username
and Customers.LastLoggedIn > @fromdate
and Customers.LastLoggedIn < @throughdate
and Customers.ZipCode = @zipcode
group by Customers.CustomerID
I need help converting this to a LinqToSql for VB.Net
Thank you very much!
View Complete Post