private void CreateJoinExpressionForDefinedRelation(QueryBuildInfo buildInfo) { string typeFromAlias = buildInfo.GetAlias(TypeFrom); IRelation relation = processor.GetRelation(TypeFrom, TypeTo); if (relation == null) { relation = processor.GetRelation(TypeTo, TypeFrom); } if (relation != null) { Expr = JoinExpr.Build(); ICollection <RelationColumnMapping> tableColumnMappings = relation.TableColumnMappings; int i = 0; foreach (RelationColumnMapping mapping in tableColumnMappings) { if (i > 0) { Expr.And(); } Expr.Field(TypeFrom, typeFromAlias, mapping.FromField); Expr.Eq(); Expr.Field(TypeTo, TypeToAlias, mapping.ToField); i++; } } }
public string CreateSql(IDbLayer dbLayer, QueryBuildInfo buildInfo) { var aliases = buildInfo.GetAlias(EntityType); if (!string.IsNullOrEmpty(aliases)) { return(aliases + ".*"); } return("*"); }