Esempio n. 1
0
        void ISqlStatementElement.Render(SqlTextWriter writer, SqlBuildArguments args)
        {
            string[] resolvedArguments = new string[0];

            if (this.Arguments != null)
            {
                resolvedArguments = this.Arguments.Select(arg =>
                {
                    if (arg is ISqlTable table)
                    {
                        return(writer.FormatQualifiedIdentifierName(args.TableName(table)));
                    }
                    else if (arg is System.Data.Common.DbParameter dbParam)
                    {
                        return(string.Concat("@", dbParam.ParameterName));
                    }
                    else if (arg is DbParameterValue paramValue)
                    {
                        return(string.Concat("@", args.CreateParameter(paramValue.ParameterName, paramValue.DbType, paramValue.Size)));
                    }
                    else if (arg is string)
                    {
                        return(string.Concat("@", args.CreateParameter(arg.ToString(), System.Data.DbType.String)));
                    }
                    else
                    {
                        return(string.Concat("@", args.CreateParameter(arg, System.Data.DbType.String)));
                    }
                }).ToArray();
            }

            writer.WriteBeginGroup();
            writer.Write(string.Format(this.SqlText, resolvedArguments));
            writer.WriteEndGroup();
        }