NHibernate Queries with Values Produced by Business Logic

Posted by Lewis on Stack Overflow See other posts from Stack Overflow or by Lewis
Published on 2010-04-22T22:00:40Z Indexed on 2010/04/22 22:03 UTC
Read the original article Hit count: 157

Filed under:

nhibernate

|

domain-driven-design

I have an NH query which returns a Product with a BasePrice. Depending on various other factors, such as Manufacturer price markup, I use a PricingService on the C# side of things to produce a "final" price.

The issue is that I now need to query against this final value - i.e., I need to run a query that selects Products within a particular "final" price range.

I'm thinking that my approach to this is all wrong, but I really didn't want to put the logic of the final price calculation in a SQL function or something like that, so any suggestions would be appreciated.

© Stack Overflow or respective owner

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

Related posts about domain-driven-design

Learn Domain-Driven Design

as seen on Johnny Coder - Search for 'Johnny Coder'
I just wrote about how I like to present on unfamiliar topics. With this said, Domain-Driven Design (DDD) is no exception. This is yet another area I knew enough about to be dangerous but I certainly was no expert. As it turns out, researching this topic wasn’t easy. I could be wrong, but it… >>> More
Value vs Entity objects (Domain Driven Design)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have just started reading DDD. I am unable to completely grasp the concept of Entity vs Value objects.. Can someone please explain the problems (maintainability, performance.. etc) a system could face when a Value object is designed as a Entity object. Example would be great... Thanks >>> More
Domain driven design: Manager and service

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm creating some business logic in the application but I'm not sure how or where to encapsulate it, I've used the repository pattern for data access, I've seen some projects that use DDD that have some classes with the "Service" suffix and the "manager" suffix, what are each of this clases suppose… >>> More
Refactoring in domain driven design

as seen on Programmers - Search for 'Programmers'
I've just started working on a project and we're using domain-driven design (as defined by Eric Evans in Domain-Driven Design: Tackling Complexity in the Heart of Software. I believe that our project is certainly a candidate for this design pattern as Evans describes it in his book. I'm struggling… >>> More
Service Oriented Architecture & Domain-Driven Design

as seen on Stack Overflow - Search for 'Stack Overflow'
I've always developed code in a SOA type of way. This year I've been trying to do more DDD but I keep getting the feeling that I'm not getting it. At work our systems are load balanced and designed not to have state. The architecture is: Website ===Physical Layer== Main Service ==Physical Layer== Server… >>> More