I have this 2 classes Cliente and Pedido. I would like to select only the Cliente that has Pedido. I'm trying to do this:

ICriteria criteria = NHibernateSessionManager.Instance.GetSession().CreateCriteria(typeof(Cliente));
IClienteDao clienteDao = (new NHibernateDaoFactory().GetClienteDao());

criteria.Add(Expression.Eq("Ativo", "1"))
.SetFetchMode("Pedidos", FetchMode.Join)
.AddOrder(Order.Asc("NomeFantasia"))
.SetResultTransformer(CriteriaUtil.DistinctRootEntity);

But it's not working, it's returning all my Clientes either they have Pedido or not. What is wrong?


<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="ADFinance.Comum.Cliente, ADFinance" table="T_ADF_MD_ClIE">
<id name="ID" column="cod_cliente" unsaved-value="0">
<generator class="native">
<param name="sequence">S_T_ADF_MD_ClIE</param>
</generator>
</id>

<property name="NomeFantasia" column="nome_fantasia" />
<property name="RazaoSocial" column="razao_social" />
<property name="Cnpj" column="cnpj" />
<property name="InscricaoEstadual" column="inscricao_estadual" />
<property name="Ativo" column="ativo" />
<property name="Email" column="email" />
<property name="CodAgencia" column="cod_agencia" />

<many-to-one name="ClientePrincipal"
class="ADFinance.Comum.Cliente, ADFinance" column="cliente_principal" />
<many-to-one name="Usuario"
class="ADFinance.Acesso.Usuario, ADFinance" column="cod_usuario" />

<set lazy="true" inverse="false" name="Telefones"
access="NHibernate.Generics.GenericAccessor, NHibernate.Generics">
<key column="cod_cliente" />
<one-to-many class="ADFinance.Comum.Telefone, ADFinance" />
</set>
<set lazy="true" inverse="false" name="Enderecos"
access="NHibernate.Generics.GenericAccessor, NHibernate.Generics">
<key column="cod_cliente" />
<one-to-many class="ADFinance.Comum.Endereco, ADFinance" />
</set>
<set lazy="true" inverse="false" name="Pedidos"
access="NHibernate.Generics.GenericAccessor, NHibernate.Generics">
<key column="cod_cliente" />
<one-to-many class="ADFinance.Faturamento.Pedido, ADFinance" />
</set>
</class>

</hibernate-mapping>

and

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="ADFinance.Faturamento.Pedido, ADFinance" table="T_ADF_PO_Pedido">
<id name="ID" column="cod_po" unsaved-value="0">
<generator class="native">
<param name="sequence">S_T_ADF_PO_Pedido</param>
</generator>
</id>

<property name="StatusFaturamento" column="cod_status_faturamento" />
<property name="TipoPedido" column="cod_tipo_pedido" />
<property name="CodPoOrigem" column="cod_po_origem" />
<property name="StatusOperacao" column="cod_status_operacoes" />
<property name="CodAp" column="cod_ap" />

<property name="NotaFiscalFornecedor" column="cod_notafiscal_fornecedor" />
<property name="NotaFiscalVeiculo" column="cod_notafiscal_veiculo" />
<property name="PorcentagemComissao" column="porcentagem_comissao" />
<property name="ValorComissao" column="valor_comissao" />
<property name="TipoCondicaoFaturamento" column="cod_condicao_faturamento" />
<property name="TipoRateio" column="cod_tipo_rateio" />
<property name="CodCliente" column="cod_cliente" />

<property name="CodProduto" column="cod_produto" />
<bag name="Itens" lazy="true" table="T_ADF_CP_PO_Item" inverse="false"
access="NHibernate.Generics.GenericAccessor, NHibernate.Generics" >
<key column="cod_po" />
<one-to-many class="ADFinance.Faturamento.ItemPedido, ADFinance" />
</bag>
</class>
</hibernate-mapping>

you would need to tell NH that you want Cliente with NOT NULL Pedidos...



-devon

There's no NotNullExpression method in th Expression class...

sorry. i was looking at the CHM and not my code:



it really should be:

it didnt work. Still returning all Clientes

can you post the generated SQL? i can't see how, if the column is NULL in the db, a Cliente with no Perdido would be returned in this situation.

-devon