Using Gen Pro 3.0 Final (Oct 22nd, 2010), SelfServicing, .NET 3.5, and Sql Server 2005.

Here is the sql I'm trying to implement in C# with Gen Pro:

select * from Visit v inner join MRNLink l on v.FacilityID = l.FacilityID and v.MedicalRecordID = l.MedicalRecordID where l.EnterprisePatientID = xxxxx

FacilityID is a foreign key column to the Facility table; both Visit and MRNLink have this column. MedicalRecordID is a string value without constraint. I'm expecting zero or more VisitEntities per EnterprisePatientID.

The problem I have is over coming the two hits of a) no MRNLinkEntity.Relations to the VisitEntity, and b) an AND clause on the join (not a .CustomFilter on the join).

This might be a case of not seeing the forest for the trees....

So, there is not any relation between the two entities? You could:

A. Make the relation in DB, refresh catalog and re-generate code.

B. Make the relation in the model only (not DB).

C. No relation in DB nor the Model, but you can construct it at runtime, something like:

var relation = new EntityRelation( RelationType.ManyToOne);
relation.AddEntityFieldPair(AFields.Field1, BFields.Field1);
relation.AddEntityFieldPair(AFields.Field2, BFields.Field2);