Linq query with MinDate() MaxDate

Posts   
 
    
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 15-Oct-2009 19:46:29   

I am converting some sql to LLBL / LINQ

I have this SQL sinppet but am not sure how to create an ILLBLGenProQuery 'Where' clause to handle it.

dbo.MinDate(ISNULL(SOX_Parent.EndDate,'1/1/2200'),
                       ISNULL(SOX_Child.EndDate, '1/1/2200')
     )  < @TheDate

Any ideas?

           var q = (ILLBLGenProQuery)
               from t in linq.SoxParent
               where  ??????

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 16-Oct-2009 06:11:32   

You have tp use function mappings. Please read the LINQ2LLBL documentation manual for more info.

David Elizondo | LLBLGen Support Team