Gente tengo el esquema que le envió.
Cuando quiero ejecutar:IQuery query = NHibernateSession.CreateQuery("select n
from Nombramiento as n where n.persona = " + personaId.ToString() + " AND
n.Active = 1 Order by n.Id desc");
Recibo el error:unexpected token: as [select n from Nombramiento as n where
n.persona = nnnn AND n.Active = 1 Order by n.Id desc]
-NHibernateSession.CreateQuery("select n from Nombramiento as n where n.persona
= " + personaId.ToString() + " AND n.Active = 1 Order by n.Id desc");
'NHibernateSession.CreateQuery("select n from Nombramiento as n where n.persona
= " + personaId.ToString() + " AND n.Active = 1 Order by n.Id desc")' produjo
una excepción de tipo 'NHibernate.QueryException' NHibernate.IQuery
{NHibernate.QueryException}
DB.CREATE TABLE [dbo].[Nombramiento]( [Id] [int] IDENTITY(1,1) NOT NULL,
[personaId] [int] NOT NULL, [FechaDesde] [datetime] NOT NULL,
[FechaHasta] [datetime] NOT NULL, [Active] [bit] NOT NULL, CONSTRAINT
[PK_Nombramiento] PRIMARY KEY CLUSTERED ( [Id] ASC)WITH (PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]
Clase.using System;using System.Collections.Generic;using System.Linq;using
System.Text;
namespace PAC.Dominio{ public class Nombramiento : DomainObject<int>,
IReplicable { private Persona _persona; private DateTime
_fechaHasta; private DateTime _fechaDesde; private bool _active;
public virtual Persona Persona { get { return
_persona; } set { _persona = value; } }
public virtual DateTime FechaDesde { get { return
_fechaDesde; } set { _fechaDesde = value; } }
public virtual DateTime FechaHasta { get { return
_fechaHasta; } set { _fechaHasta = value; } }
public virtual bool Active { get { return _active; }
set { _active = value; } }
public override int GetHashCode() { return
(GetType().FullName + "|" + Persona.Nombre + "|" +
Id.ToString()).GetHashCode(); }
#region IReplicable Members
public int GetId() { return this.Id; }
public string GetNombreEntidad() { return
this.GetType().Name; } #endregion }}
XML de mapeo.<?xml version="1.0" encoding="utf-8" ?><hibernate-mapping
xmlns="urn:nhibernate-mapping-2.2"> <class name="PAC.Dominio.Nombramiento,
PAC.Dominio" table="Nombramiento" lazy="false"> <id name="Id" column="Id"
unsaved-value="0"> <generator class="identity" /> </id> <property
name="FechaDesde" column="FechaDesde" /> <property name="FechaHasta"
column="FechaHasta" /> <property name="Active" column="Active" />
<!-- Persona --> <many-to-one name="Persona" column="personaId"
class="PAC.Dominio.Persona, PAC.Dominio" ></many-to-one>
</class></hibernate-mapping>
Gracias y disculpen.
Javier.
