Example #1
0
        protected override DbCommand GetCommand()
        {
            DbCommand command         = this.DataService.EntityLiteProvider.CreateCommand();
            string    parameterPrefix = this.DataService.EntityLiteProvider.ParameterPrefix;

            command.CommandText = Template.GetSql(parameterPrefix);
            Template.AddParametersToCommand(command, this.DataService);
            return(command);
        }
        public override string GetFromClauseContent(DbCommand selectCommand, ref int paramIndex, int indentation)
        {
            ISqlTemplate template        = ((ITemplatedQueryLite)this.QueryLite).Template;
            string       parameterPrefix = this.QueryLite.DataService.EntityLiteProvider.ParameterPrefix;

            template.AddParametersToCommand(selectCommand, this.QueryLite.DataService);
            if (string.IsNullOrEmpty(sql))
            {
                var sb = new StringBuilder();
                sb.NewIndentedLine(++indentation);
                var indentedLine = sb.ToString();
                sql = template.GetSql(parameterPrefix).Replace("\r\n", indentedLine);
                sb  = new StringBuilder();
                sb.Append('(').Append('\n').Append(sql).NewIndentedLine(--indentation).Append(") TQ");
                sql = sb.ToString();
            }
            return(sql);
        }