NHibernate: how to do lookup a specific date in Nhibernate

Posted by Daoming Yang on Stack Overflow See other posts from Stack Overflow or by Daoming Yang
Published on 2010-04-03T10:36:21Z Indexed on 2010/04/03 11:03 UTC
Read the original article Hit count: 193

Filed under:

nhibernate

How I can lookup a specific date in Nhibernate?

I'm currently using this to lookup one day's order.

 ICriteria criteria = SessionManager.CurrentSession.CreateCriteria(typeof(Order))
            .Add(Expression.Between("DateCreated", date.Date.AddDays(-1), date.Date.AddDays(1)))
            .AddOrder(NHibernate.Criterion.Order.Desc("OrderID"));

I tried the following code, but they did bring the data for me.

Expression.Eq("DateCreated", date)

Expression.Like("DateCreated", date)

Note: The pass in date value will be like this 2010-04-03 00:00:00,

The actual date value in the database will be like this 2010-03-13 11:17:16.000

Can anyone let me know how to do this?

Many thanks.

Related posts about nhibernate

How can I eager-load a child collection mapped to a non-primary key in NHibernate 2.1.2?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have two objects with a many-to-many relationship between them, as follows: public class LeftHandSide { public LeftHandSide() { Name = String.Empty; Rights = new HashSet<RightHandSide>(); } public int Id { get; set; } public string Name { get; set;… >>> More
Nhibernate 2.1 and mysql 5 - InvalidCastException on Setup

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello there, I am trying to use NHibernate with Spring.Net und mySQL 5. However, when setting up the connection and creating the SessionFactoryObject, I get this InvalidCastException: NHibernate seems to cast MySql.Data.MySqlClient.MySqlConnection to System.Data.Common.DbConnection which causes… >>> More
Nhibernate transactions:Avoiding Nhibernate dependency in the service layer

as seen on Stack Overflow - Search for 'Stack Overflow'
One of practices advocated by Nhibernate experts is to do all actions in inside a transaction. In a typical 3 tier web architecture, Nhibernate depedency is limited the data layer. In such a case is it fine to use using (var tr = NHibernateSession.Current.BeginTransaction()) { at the controller… >>> More
Series of abstract classes and NHibernate

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, and first off thanks for your time to look at this. For a research project I'm working on, I have a somewhat complex design (which I've been given) to persist to a database via NHibernate. Here's an example of the class hierarchy: TransitStrategy, TransportationCompany and TransportationLocation… >>> More
Using Time columns with NHibernate, Fluent NHibernate and SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a table with a time column in my SQL Server 2008 database. The property of the object I'm trying to map to is a TimeSpan. How can i tell FluentNHibernate to use the TimeAsTimeSpan NHibernate type, so that I don't have cast problems? >>> More

Developer IT

NHibernate: how to do lookup a specific date in Nhibernate - Developer IT

NHibernate: how to do lookup a specific date in Nhibernate

nhibernate

Related posts about nhibernate

How can I eager-load a child collection mapped to a non-primary key in NHibernate 2.1.2?

Nhibernate 2.1 and mysql 5 - InvalidCastException on Setup

Nhibernate transactions:Avoiding Nhibernate dependency in the service layer

Series of abstract classes and NHibernate

Using Time columns with NHibernate, Fluent NHibernate and SQL Server 2008

Categories cloud