how to add where whitout relations

Posts   
 
    
Homer00
User
Posts: 10
Joined: 27-Dec-2010
# Posted on: 10-Mar-2011 17:53:20   

hi,

I need to do somenthing like:

select c.name from clients c, aleatory_table at where c.id=at.aleatory_id

clientes and aleatory_table has no relations. Its a weak relation.

How can i construct this in llblgen?.

Thank you

Homer00
User
Posts: 10
Joined: 27-Dec-2010
# Posted on: 10-Mar-2011 19:17:15   

I solve it by my self:

SD.LLBLGen.Pro.ORMSupportClasses.RelationCollection relacion = new SD.LLBLGen.Pro.ORMSupportClasses.RelationCollection();
            relacion.Add(TDB.EntityClasses.ExpedienteEntity.Relations.DocumentoEntityUsingIdDocumento, JoinHint.Inner);
           IEntityRelation rel = new EntityRelation(TDB.HelperClasses.ExpedienteFields.Identificador , TDB.HelperClasses.ClienteFields.Nif , RelationType.ManyToOne);

the solution is EntityRelation

**Daelmo solution ** (he save one more time simple_smile ) http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=14517