NHibernate version: 1.2.0

Sql Server 2005

This may be a very newbie question. I've googled and googled and found bits a pieces of answers but never a clear answer to this.

I have two tables, fdUser and fdPrinter.

fdUser:
UserID Guid
Name varchar(50)

fdPrinter:
PrinterID Guid
Name varchar(50)

I want to be able to assign any number of printers to a specific user or multiple users so I use an association table called fdUserPrinter. Included with this association is a user specific setting of "DEFAULT" for a given printer associated to the user.

fdUserPrinter:
UserID Guid
PrinterID Guid
Default bit

I have the mapping file for User like this:


Then I have the mapping file for Printer like this:



And finally I have my UserPrinter mapped like this:



So my question is how can I do the mapping such that the following can be done:

Cascade saving and updating will save the associations
Removing an association from User.Printers collection will delete the association in UserPrinter table
The "Default" value in the UserPrinter class is mapped to the Printer class so I can itterate through User.Printers finding the "Default" printer

I'm somewhat new to NHibernate so I apologize in advance if this is something I should have found in the documentation! :)

Thanks for ANY help with this!

See the prior post:

http://forum.hibernate.org/viewtopic.php?t=974464&highlight=

Also for your cascade delete question try the "all-delete-orphan" which means that when a class in the collection is removed from the collection (no longer associated with a collection) it is to be deleted.

Ok, I tried that and now my Printers collection fails to initialize because it can't cast object UserPrinter to Printer.

I have created 3 entity classes, User, Printer and UserPrinter.

User class has a property:


The mapping for User is now:



If I take the many-to-one out, I don't get the casting exception, but I also don't get any printers :) I'm not sure I understand why NHibernate is trying to make that cast. I've got to be missing something real simple! :(

Thanks for any help!

shouldn't you be using an IList<UserPrinter> instead of IList<Printer>?

duh!

Yep that's it and it seems to be working now!

Thanks for your help!

Hi.
I've the same problem. I can't get it work.
Could you past the mapping documents and the classes documents, please.

I'm starting using this tool and i have some problems yet.
I would apreciate any help.

Thanks

Nassa,

I don't have those files with me at the moment. I will post everything for you later tonight.

Thanks

Ok. Thanks a lot.

I will wait for your help to try to resolve my problem.

Thanks again

Nassa

Yeah Mark - please post it soon so I don't have to email you all the time :)

I'm posting my solution, to help other people with the same problem as me, that is the mapping for tables with a relationsship table with extra columns.

My tables :
tImpEntidade
tImpExpressao
tImpRelExpressaoEntidade

My map files :
Entidade :

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="ExportSTQData.Entidade, ExportSTQData" table="tImpEntidade">
<id name="CodEntidade" type="Guid">
<generator class="guid" />
</id>
<property name="CodImportacao" type="Guid"/>
<property name="Nome" type="String" length="256"/>
<property name="Descricao" type="String" length="1024"/>
<property name="Ordem" type="Int32"/>
<property name="CodDadoImportacao" type="Guid"/>
<property name="DataInsercao" type="DateTime"/>
<property name="DataAlteracao" type="DateTime"/>
<property name="InseridoPor" type="String" length="20"/>
<property name="AlteradoPor" type="String" length="20"/>


<many-to-one name="DadoImportacao" class="ExportSTQData.DadoImportacao, ExportSTQData" column="CodDadoImportacao" not-null="false" />

<bag name="Expressoes" cascade="save-update" table="tImpRelExpressaoEntidade" lazy="true">
<key column="CodEntidade" />
<composite-element class="ExportSTQData.RelacaoExpressaoEntidade, ExportSTQData" >
<parent name="Entidade" />
<property name="CodPropriedadeImportacao" column="CodPropriedadeImportacao" type="String" length="256" />
<property name="OperadorLogico" column="OperadorLogico" type="String" length="50" />
<property name="Valor" column="Valor" type="String" length="100" />
<property name="ePropriedadeInteraccao" column="ePropriedadeInteraccao" type="Boolean" />
<property name="eDadoInteraccao" column="eDadoInteraccao" type="Boolean" />
<property name="ePropriedadeProcesso" column="ePropriedadeProcesso" type="Boolean" />
<property name="Ordem" column="Ordem" type="Int32" />
<property name="DataInsercao" type="DateTime"/>
<property name="DataAlteracao" type="DateTime"/>
<property name="InseridoPor" type="String" length="20"/>
<property name="AlteradoPor" type="String" length="20"/>
<many-to-one name="Expressao" column="CodExpressao" />
</composite-element>
</bag>


</class>
</hibernate-mapping>


Expressao :


<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="ExportSTQData.Expressao, ExportSTQData" table="tImpExpressao">
<id name="CodExpressao" type="Guid" column="CodExpressao">
<generator class="guid" />
</id>
<property name="Nome" type="String" length="256"/>
<property name="Descricao" type="String" length="1024"/>
<property name="ValorExpressao" column="Expressao" type="String"/>
<property name="CodTipoExpressao" type="Guid"/>
<property name="CodGrupoExpressao" type="Guid" not-null="false"/>
<property name="DataInsercao" type="DateTime"/>
<property name="DataAlteracao" type="DateTime"/>
<property name="AlteradoPor" type="String" length="20"/>
<property name="InseridoPor" type="String" length="20"/>



</hibernate-mapping>

RelacaoExpressaoEntidade :

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="ExportSTQData.RelacaoExpressaoEntidade, ExportSTQData" table="tImpRelExpressaoEntidade">
<composite-id access="property">
<key-property name="CodEntidade" column="CodEntidade" type="Guid" />
<key-property name="CodExpressao" column="CodExpressao" type="Guid" />
</composite-id>
<property name="CodPropriedadeImportacao" column="CodPropriedadeImportacao" type="String" length="256" />
<property name="OperadorLogico" column="OperadorLogico" type="String" length="50" />
<property name="Valor" column="Valor" type="String" length="100" />
<property name="ePropriedadeInteraccao" column="ePropriedadeInteraccao" type="Boolean" />
<property name="eDadoInteraccao" column="eDadoInteraccao" type="Boolean" />
<property name="ePropriedadeProcesso" column="ePropriedadeProcesso" type="Boolean" />
<property name="Ordem" column="Ordem" type="Int32" />
<property name="DataInsercao" type="DateTime"/>
<property name="DataAlteracao" type="DateTime"/>
<property name="InseridoPor" type="String" length="20"/>
<property name="AlteradoPor" type="String" length="20"/>
</class>
</hibernate-mapping>

My classes :

Entidade

public class Entidade : IScriptGenerator
{
private Guid codEntidade;
private Guid codImportacao;
private string nome;
private string descricao;
private int ordem;
private Guid codDadoImportacao;
private DateTime dataInsercao;
private DateTime dataAlteracao;
private string inseridoPor;
private string alteradoPor;
private IList<RelacaoExpressaoEntidade> _expressoes;

public virtual IList<RelacaoExpressaoEntidade> Expressoes
{
get { return this._expressoes; }
set { this._expressoes = value; }
}

}


Expressao :

private Guid codExpressao;
private string nome;
private string descricao;
private string expressao;
private Guid codTipoExpressao;
private Guid? codGrupoExpressao;
private DateTime dataInsercao;
private DateTime dataAlteracao;
private string inseridoPor;
private string alteradoPor;


RelacaoExpressaoEntidade

[Serializable]
public class RelacaoExpressaoEntidade : IScriptGenerator
{
private Guid _cod_entidade;
private Guid _cod_expressao;

private Entidade _entidade;
private Expressao _expressao;

private string _cod_propriedade_importacao;
private string _operador_logico;
private string _valor;
private bool _e_propriedade_interaccao;
private bool _e_dado_interaccao;
private bool _e_propriedade_processo;
private int _ordem;
private DateTime _data_insercao;
private DateTime _data_alteracao;
private string _inserido_por;
private string _alterado_por;

public override bool Equals(object obj)
{
return base.Equals(obj);
}

public override int GetHashCode()
{
return base.GetHashCode();
}

}

We just need to create the public virtual properties for each field in classes.

Hope this can be usefull to someone. Is so, please rate it. ;)

If there is anything wrong here, please tell me the correct way to do this.

Thanks.

Nassa