Sunday, February 05, 2012
Support » Support Forum
Register Login
HomeWhat is NDO?- Executive Overview- NDO for DevelopersHow NDO Works- Persistent Classes- Mapping- Queries- Reverse Engineering- Inheritance, Polymorphism- Distributed ApplicationsLicensingSupport- Support Forum- FAQ- Solutions- Downloads- E-Mail Support- Tutorial VideosOnline ShopContact
Welcome to the NDO support forum!
Please register/login at the site if you want to post a thread. We sometimes copy support mails of common interest to the forum. They appear with anonymous sender. Please post your messages in English language if possible. You can do your posts also in German, we will translate your post and our answer so that all users of the forum can read your posts. The forum software requires that javascript is enabled. Please do not insert licence information or licence keys in forum posts. If you know a good answer to a post of another user, feel free to reply! The forum is monitored. We reserve the right to remove posts we consider not to be useful for other forum users.
Hi Uwe,
I'm sorry, that's not possible at the moment. We plan to support aggregate functions on DateTime values in the next bigger release of NDO. For a workaround, you have several possibilities. The first one is to use ADO.NET. Note, that you can use the NDO.Mapping API to decouple the table and column names from your application. The second choice is to use a persistent class with only one DateTime field and fetching an object using a Sql pass-through query:
[NDOPersistent]public class DateTimeContainer{ DateTime date; DateTime Date { get { return date; } }}
// Calling contextstring sql = String.Format("SELECT MAX({0}) AS [Date] FROM {1}", columnName, tableName);Query q = pm.NewQuery(typeof(DateTimeContainer), sql, false, Query.Language.Sql);DateTimeContainer dtc = (DateTimeContainer) q.ExecuteSingle();// dtc.Date contains your date. Should be DateTime.MinValue, if the resultset was emtpy
Hope that helps!
Best Regards:Mirko