Hi there,

I have a custom template and I'm looping through Many To One RelatedEntities but can't figure out how to access the FKey field of the currentEntity that represents the relation.

Here's the entity template code:

<[Foreach RelatedEntity ManyToOne]><[If Not MappedFieldRelationIsHidden]>
        <[RelatedEntityName]> f<[MappedFieldNameRelation]>;
        [Association("<[RelatedMappedFieldNameRelation]>-<[RelatedEntityName]>-<[CurrentEntityName]>")]
        [Persistent("<[RelatedEntityFieldName]>")] // I need the fkey Field in this entity which represents the current relation here
        public <[RelatedEntityName]> <[MappedFieldNameRelation]>
        {
            get { return f<[MappedFieldNameRelation]>; }
            set { SetPropertyValue<<[RelatedEntityName]>>("<[MappedFieldNameRelation]>", ref f<[MappedFieldNameRelation]>, value); }
        }<[EndIf]><[NextForeach]>

Example code of what I need:

public ContactEntity
{
   public int cTypeID; // fkey to CType table

// relation property
   [Persistent("cTypeID")]  // can't get 'cTypeID' when looping through related entities
   public CType ContactType;
}

Using Template Studio: 2.6.06102008 Final

A relation can have one or more fields. So you should try this:

<[Foreach RelatedEntity ManyToOne]><[If Not MappedFieldRelationIsHidden]>
        <[RelatedEntityName]> f<[MappedFieldNameRelation]>;
        [Association("<[RelatedMappedFieldNameRelation]>-<[RelatedEntityName]>-<[CurrentEntityName]>")]

       <[Foreach RelationField]>
        [Persistent("<[RelationFieldName]>")] 
       <[NextForeach]>

        public <[RelatedEntityName]> <[MappedFieldNameRelation]>
        {
            get { return f<[MappedFieldNameRelation]>; }
            set { SetPropertyValue<<[RelatedEntityName]>>("<[MappedFieldNameRelation]>", ref f<[MappedFieldNameRelation]>, value); }
        }<[EndIf]><[NextForeach]>

Thanks, just what I needed!

I am using the following in my template.

<[Foreach RelatedEntity OneToMany]>[Include]
[Association("<[ MappedFieldNameRelation ]>", "<[Foreach PrimaryKeyEntityField Comma]><[ EntityFieldName ]><[NextForeach]>", "<[Foreach RelationField]><[If IsForeignKey]><[RelatedEntityRelationFieldName]><[EndIf]><[NextForeach]>", IsForeignKey=false)]
public IEnumerable<<[ RelatedEntityName ]>Entity> <[ MappedFieldNameRelation ]>;
<[ NextForeach ]>

In the place where I am referencing the 'PrimaryKeyEntityField' I actually need the foreign key fields, not the primary keys of the entity. How can I get access to those?

Please show us the expected code snippet.

ok, entities: ContactAddress: pkey is 2 columns:ContactID, AddressID : AddressID is foreign key to... **Address **: pkey is AdrID

I want to see Association("ContactAddress", "AddressID", "AdrID")

Instead of Foreach PrimaryKeyEntityField, Use Foreach RelationField. And the FKfield Token is [RelationFieldName]

Usage example from dao.template:

private IPredicateExpression CreateFilterUsingForeignKeys(<[Foreach RelatedEntity ManyToOne IncludeInherited Comma]>IEntity <[CaseCamel MappedFieldNameRelation]>Instance<[NextForeach]>, IEntityFields fieldsToReturn) { IPredicateExpression selectFilter = new PredicateExpression(); <[Foreach RelatedEntity ManyToOne IncludeInherited]> if(<[CaseCamel MappedFieldNameRelation]>Instance != null) { <[Foreach RelationField CrLf]>selectFilter.Add(new FieldCompareValuePredicate(fieldsToReturn[(int)<[CurrentEntityName]>FieldIndex.<[RelationFieldName]>], ComparisonOperator.Equal, ((<[ RelatedEntityName ]>Entity)<[CaseCamel MappedFieldNameRelation]>Instance).<[RelatedEntityRelationFieldName]>));<[NextForeach]> }<[NextForeach]> return selectFilter; }

thanks for the help