That I do, a parenthesis if you please. On Thu, Mar 5, 2009 at 5:58 PM, Will Shaver <[email protected]> wrote:
> > And by "bracket" he means ) > > > On Thu, Mar 5, 2009 at 11:53 AM, James Gregory <[email protected]> > wrote: > > I don't know if it's of any relevance, but your formula is either missing > an > > opening bracket, or has an extra closing one; the last bracket is > unmatched. > > > > On Thu, Mar 5, 2009 at 4:56 PM, robcar <[email protected]> wrote: > >> > >> Hello > >> > >> I'm quite a beginner with NHibernate but I have run into a problem I > >> can't seem to come any closer to fix. Is this a bug? > >> > >> I'm trying do make my self a class that looks like the following: > >> > >> public class Price > >> { > >> public virtual int PriceId { get; set; } > >> public virtual int PerQuantityMultiplier { get; set; } > >> public virtual int Generation { get; set; } > >> public virtual DateTime EffectiveDate { get; set; } > >> } > >> > >> With the following mapping file: > >> > >> <?xml version="1.0" encoding="utf-8" ?> > >> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" > > >> <class name="Volvo.Purchasing.Pricing.DomainModel.Entities.Price, > >> Entities" > > >> > >> <id name="PriceId" column="PriceId" type="System.Int32" unsaved- > >> value="null"> > >> <generator class="native"/> > >> </id> > >> > >> <property name="PerQuantityMultiplier" column="Multiplier" not- > >> null="false" type="System.Int32" insert="true" update="true"/> > >> <property name="EffectiveDate" column="EffectiveDate" not- > >> null="true" type="System.DateTime" insert="true" update="true"/> > >> <property name="Generation" column="Generation" not-null="true" > >> type="System.Int32" formula="ROW_NUMBER() OVER (PARTITION BY > >> AgreementId ORDER BY EffectiveDate DESC) as [Generation])" /> > >> > >> </class> > >> > >> </hibernate-mapping> > >> > >> When I fetch a list of this class I get an "Can''t execute query > >> exception". This is because NHibernate prefixes my Formula query and > >> doesn't seem to recognize the reserved words PARTITION and OVER. > >> Is there any way to tell NHibernate not to do this replace of my > >> custom SQL query? > >> > >> Very, very greatful for any help in this matter. > >> > >> KR > >> Robin Carlander > >> > >> > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
