Hi all,

Given this data:

Feed includedFeed = new Feed {
    LastUploaded = DateTime.Now.AddHours(-6),
    UploadFrequencyInHours = 5
};

Feed excludedFeed = new Feed {
    LastUploaded = DateTime.Now,
    UploadFrequencyInHours = 5
};

I would like to query the database using the criteria API to get
"pending feeds", ie. ones which have not been uploaded within the
UploadFrequencyInHours window. Something like this in SQL:

WHERE (DateDiff(hh, LastUploaded, getdate()) >=
UploadFrequencyInHours)

Is there a method of doing this with Criteria?

Thanks,
Colin.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to