Пример #1
0
 private ExpressionVisitorContext(SqlGenerator generator, IDictionary<string, object> parameters, ICollection<Tuple<Type, string, Column>> tempColumnMappers)
 {
     this.Generator = generator;
     this.Fragment = new QueryFragment();
     this.Parameters = parameters;
     this.TableNames = new Dictionary<Type, string>();
     this.TempColumnMappers = tempColumnMappers;
 }
Пример #2
0
 internal ExpressionVisitorContext(SqlGenerator generator)
 {
     this.Generator = generator;
     this.Fragment = new QueryFragment();
     this.Parameters = new Dictionary<string, object>();
     this.TableNames = new Dictionary<Type, string>();
     this.TempColumnMappers = new List<Tuple<Type, string, Column>>();
 }
Пример #3
0
 public abstract string ToSql(SqlGenerator generator);
Пример #4
0
 public override string ToSql(SqlGenerator generator)
 {
     if (Left != null)
         return string.Format("{0} {1} {2}", Left.ToSql(generator), Relation, Right.ToSql(generator));
     return Right.ToSql(generator);
 }
Пример #5
0
 public override string ToSql(SqlGenerator generator)
 {
     var sb = new StringBuilder();
     sb.Append(generator.DecorateName(TableName));
     if (!string.IsNullOrEmpty(this.Alias))
         sb.AppendFormat(" AS {0}", Alias);
     return sb.ToString();
 }
Пример #6
0
 public abstract string ToSql(SqlGenerator generator, bool withAlias = true);
Пример #7
0
 public override string ToSql(SqlGenerator generator)
 {
     var sb = new StringBuilder();
     sb.AppendFormat("({0})", InnerFragment.ToSql(generator));
     if (!string.IsNullOrEmpty(this.Alias))
         sb.AppendFormat(" AS {0}", Alias);
     return sb.ToString();
 }
Пример #8
0
 public override string ToSql(SqlGenerator generator, bool withAlias = true)
 {
     if (!string.IsNullOrEmpty(this.Alias) && withAlias)
     {
         return string.Format("{0} AS {1}", MemberName, Alias);
     }
     return MemberName;
 }
Пример #9
0
        public string ToSql(SqlGenerator generator)
        {
            var sb = new StringBuilder();

            sb.Append("Select ");
            if (SelectPart.Any())
            {
                sb = SelectPart.Aggregate(sb, (s, i) => s.AppendFormat("{0},", i.ToSql(generator)));
                sb.Remove(sb.Length - 1, 1);
            }
            else
            {
                sb.Append("*");
            }
            sb.Append(" From ");
            sb = FromPart.Aggregate(sb, (s, i) => s.AppendFormat("{0} ", i.ToSql(generator)));

            if (WherePart != null)
            {
                sb.AppendFormat("Where {0}", WherePart.ToSql(generator));
            }

            if (GroupPart.Any())
            {
                sb.Append(" Group By ");
                sb = GroupPart.Aggregate(sb, (s, o) => s.AppendFormat("{0},", o.ToSql(generator, false)));
                sb.Remove(sb.Length - 1, 1);
            }

            if (OrderPart.Any())
            {
                sb.Append(" Order By ");
                sb = OrderPart.Aggregate(sb, (s, o) => s.AppendFormat("{0},", o.ToSql(generator)));
                sb.Remove(sb.Length - 1, 1);
            }

            if (Take.HasValue)
            {
                sb.Append(" limit ");
                if (Skip.HasValue)
                {
                    sb.AppendFormat("{0},", Skip.Value);
                }
                sb.Append(Take.Value);
            }

            return sb.ToString();
        }
Пример #10
0
 public string ToSql(SqlGenerator generator)
 {
     return string.Format("{0} {1}", Column.ToSql(generator), Order);
 }
Пример #11
0
 public override string ToSql(SqlGenerator generator, bool withAlias = true)
 {
     var sb = new StringBuilder();
     if (!string.IsNullOrEmpty(TableName))
         sb.AppendFormat("{0}.", generator.DecorateName(TableName));
     sb.Append(generator.DecorateName(MemberName));
     if (!string.IsNullOrEmpty(this.Alias) && withAlias)
         sb.AppendFormat(" AS {0}", Alias);
     return sb.ToString();
 }
Пример #12
0
 public override string ToSql(SqlGenerator generator)
 {
     var sb = new StringBuilder();
     sb.AppendFormat("{0} ", GetJoinSql(JoinMode));
     sb.Append(Table.ToSql(generator));
     if (!string.IsNullOrEmpty(this.Alias))
         sb.AppendFormat(" AS {0}", Alias);
     if (JoinMode != JoinMode.Default)
     {
         sb.AppendFormat(" On {0}", JoinCondition.ToSql(generator));
     }
     return sb.ToString();
 }
Пример #13
0
 public override string ToSql(SqlGenerator generator, bool withAlias = true)
 {
     var sb = new StringBuilder();
     if (this.Parameters != null && this.Parameters.Any())
         sb.AppendFormat(this.Formatter, this.Parameters.Select(p => p.ToSql(generator)).ToArray());
     else
         sb.Append(this.Formatter);
     if (!string.IsNullOrEmpty(this.Alias) && withAlias)
         sb.AppendFormat(" AS {0}", Alias);
     return sb.ToString();
 }
Пример #14
0
 internal TypeHandler(IDbConnection connection)
 {
     SqlGenerator = new SqlGenerator(connection);
     //parser = new QueryExpressionParser(connection);
 }