Esempio n. 1
0
        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++;
                }
            }
        }
Esempio n. 2
0
        public string CreateSql(IDbLayer dbLayer, QueryBuildInfo buildInfo)
        {
            var aliases = buildInfo.GetAlias(EntityType);

            if (!string.IsNullOrEmpty(aliases))
            {
                return(aliases + ".*");
            }
            return("*");
        }