ComponentOne DataObjects for .NET
OuterJoinInManyToOne Property

C1.Data.2 Assembly > C1.Data.SchemaObjects Namespace > CompositeDefRelation Class : OuterJoinInManyToOne Property
Gets or sets a value indicating whether to use outer join in generated SQL , if Relation.Cardinality = ManyToOne.
Syntax
'Declaration
 
Public Overrides Property OuterJoinInManyToOne As System.Boolean
public override System.bool OuterJoinInManyToOne {get; set;}
Remarks
This property has effect only for many-to-one relations (Relation.Cardinality = ManyToOne).

The default value is True. This means that a many-to-one relation in a composite table diagram generates outer joins in the SQL statement. This ensures the standard interpretation of many-to-one links, where the child table contains one row corresponding to the parent row, or none. If there are no corresponding row, the child fields receive null values. However, some databases do not implement outer joins, or implement them inadequately, with various limitations (as, for example, MS Access). In this case, and when outer joins are undesirable for other reasons, you can set this property to False. Then C1DataObjects will use inner join for this view relation in the composite table diagram.

See Also

Reference

CompositeDefRelation Class
CompositeDefRelation Members
How Composite Table Data is Fetched, Stored and Updated