LLBLGen Pro Help
Best practises -> How do I -> How do I get the MAX(Order.ShippingDate - Order.OrderDate) value from a customer's orders ?
ADAPTER
' VB.NET
Dim adapter As New DataAccessAdapter()
Dim maxValue As Integer = CInt(adapter.GetScalar(OrderFieldIndex.OrderId, (OrderFields.ShippedDate - OrderFields.OrderDate), _
AggregateFunction.Max, (OrderFields.CustomerId == _customerId)))
'instead of OrderFieldIndex.OrderId should be OrderFields.OrderId
'and instead of == should be just =
Dim maxValue As Integer = CInt(adapter.GetScalar(OrderFields.OrderId, (OrderFields.ShippedDate - OrderFields.OrderDate), _
AggregateFunction.Max, (OrderFields.CustomerId = _customerId)))