public override string NormalizeParameter(string name)
        {
            if (name == null)
            {
                throw new ArgumentNullException(nameof(name));
            }

            return(MsSqlHelper.FormatParamName(name));
        }
        public override IDataParameter CreateParameter(string name, object value)
        {
            if (name == null)
            {
                throw new ArgumentNullException(nameof(name));
            }

            name = MsSqlHelper.FormatParamName(name);
            return(new SqlParameter(name, value ?? DBNull.Value));
        }
Beispiel #3
0
        protected sealed override string OnParseInsert()
        {
            var builder = new StringBuilder();

            builder.AppendFormat("Insert Into {0} (", MsSqlHelper.FormatSymbolName(Name));
            var retriever = new SqlMemberExpressionRetriever();

            foreach (var column in Columns)
            {
                column.Accept(retriever);
            }
            using (var e = retriever.Members.GetEnumerator())
            {
                if (Parameters.Count == 0)
                {
                    throw new InvalidOperationException("parameter count is zero");
                }

                if (e.MoveNext())
                {
                    builder.AppendFormat("[{0}]", e.Current.Name);
                    while (e.MoveNext())
                    {
                        builder.AppendLine();
                        builder.AppendFormat(", [{0}]", e.Current.Name);
                    }
                }
            }

            builder.Append(") Values (");
            using (var e = retriever.Members.GetEnumerator())
            {
                if (e.MoveNext())
                {
                    builder.AppendFormat("@{0}", e.Current.Name);
                    while (e.MoveNext())
                    {
                        builder.AppendLine();
                        builder.AppendFormat(", @{0}", e.Current.Name);
                    }
                }
            }

            builder.AppendFormat(")");
            return(builder.ToString());
        }
Beispiel #4
0
        protected sealed override string OnParseUpdate()
        {
            var builder = new StringBuilder();

            builder.AppendFormat("Update {0}", MsSqlHelper.FormatSymbolName(Name)).AppendLine();
            var retriever = new SqlMemberExpressionRetriever();

            foreach (var column in Columns)
            {
                column.Accept(retriever);
            }
            using (var e = retriever.Members.GetEnumerator())
            {
                if (!e.MoveNext())
                {
                    throw new InvalidOperationException("parameter count is zero");
                }

                builder.AppendFormat("Set [{0}] = @{0}", e.Current.Name).AppendLine();
                while (e.MoveNext())
                {
                    builder.AppendFormat(", [{0}] = @{0}", e.Current.Name).AppendLine();
                }
            }
            builder.AppendFormat("From {0}", MsSqlHelper.FormatSymbolName(Name));
            //foreach (var inner in _inners)
            //{
            //    builder.AppendLine();
            //    inner.Parser();
            //    builder.Append(inner.Sql);
            //}
            if (Condition != null)
            {
                builder.AppendLine();
                builder.Append("Where ");
                var visitor = new MsSqlExpressionVisitor();
                var expre   = MsSqlExpressionVisitor.LogicExpression(Condition);
                expre.Accept(visitor);
                builder.Append(visitor.Complier());
            }

            return(builder.ToString());
        }
Beispiel #5
0
        protected sealed override string OnParseDelete()
        {
            var builder = new StringBuilder();

            builder.AppendFormat("Delete From {0}", MsSqlHelper.FormatSymbolName(Name));
            //foreach (var inner in _inners)
            //{
            //    builder.AppendLine();
            //    inner.Parser();
            //    builder.Append(inner.Sql);
            //}
            if (Condition != null)
            {
                builder.AppendLine();
                builder.Append("Where ");
                var visitor = new MsSqlExpressionVisitor();
                var expre   = MsSqlExpressionVisitor.LogicExpression(Condition);
                expre.Accept(visitor);
                builder.Append(visitor.Complier());
            }

            return(builder.ToString());
        }
        public override void Parameter(SqlParameterExpression node)
        {
            var name = MsSqlHelper.FormatParamName(node.Name);

            SqlBuilder.Append(name);
        }
        public override void Member(SqlMemberExpression node)
        {
            var name = MsSqlHelper.FormatSymbolName(node.Name);

            SqlBuilder.Append(name);
        }
Beispiel #8
0
        protected sealed override string OnParseSelect()
        {
            var builder = new StringBuilder("Select ");

            if (Top != null)
            {
                builder.AppendFormat("Top {0} ", Top.Value);
            }
            if (Columns.Count == 0)
            {
                builder.AppendLine("*");
            }
            else
            {
                using (var e = Columns.GetEnumerator())
                {
                    e.MoveNext();
                    var visitor = new MsSqlExpressionVisitor();
                    e.Current.Accept(visitor);
                    builder.AppendFormat("{0}", visitor.Complier()).AppendLine();
                    while (e.MoveNext())
                    {
                        visitor.Reset();
                        e.Current.Accept(visitor);

                        builder.AppendFormat(", {0}", visitor.Complier()).AppendLine();
                    }
                }
            }
            builder.AppendFormat("From {0}", MsSqlHelper.FormatSymbolName(Name));
            if (Condition != null)
            {
                builder.AppendLine();
                builder.Append("Where ");

                var visitor = new MsSqlExpressionVisitor();
                var expre   = MsSqlExpressionVisitor.LogicExpression(Condition);
                expre.Accept(visitor);
                builder.Append(visitor.Complier());
            }
            if (Groups != null)
            {
                builder.AppendLine();
                builder.AppendFormat("Group By {0}", string.Join(", ", Groups.Select(p => string.Format("[{0}]", p.Name))));
            }
            if (SortOrders != null)
            {
                using (var e = SortOrders.GetEnumerator())
                {
                    if (e.MoveNext())
                    {
                        builder.AppendLine();
                        builder.AppendFormat("Order By [{0}] {1}", e.Current.Member.Name, e.Current.Ascending ? "Asc" : "Desc");
                        while (e.MoveNext())
                        {
                            builder.Append(", ");
                            builder.AppendFormat("[{0}] {1}", e.Current.Member.Name, e.Current.Ascending ? "Asc" : "Desc");
                        }
                    }
                }
            }
            if (RowOffset != null)
            {
                //offset 5*2 rows fetch next 5 rows only
                builder.AppendLine();
                builder.Append("Offset ").Append(RowOffset.Offset).Append(" Rows Fetch Next ").Append(RowOffset.Count).Append(" Rows Only");
            }
            return(builder.ToString());
        }