예제 #1
0
        public string GetInsertSelectQuery(DatabaseBase database, InsertSelectBuilder insertBuilder, Parameters parameters)
        {
            StringBuilder stringBuilder = new StringBuilder("INSERT INTO ");

            stringBuilder.Append(insertBuilder.Table.Name);
            stringBuilder.Append("(");
            int index = 0;

            while (index < insertBuilder.InsertColumns.Length)
            {
                ColumnBase ColumnBase = insertBuilder.InsertColumns[index];
                if (index > 0)
                {
                    stringBuilder.Append(',');
                }
                stringBuilder.Append(ColumnBase.Name);
                checked { ++index; }
            }
            stringBuilder.Append(")");
            stringBuilder.Append(GetSelectQuery(database, (QueryBuilderBase)insertBuilder.SelectQuery, parameters));
            return(stringBuilder.ToString());
        }
예제 #2
0
        internal static string GetInsertSelectQuery(DatabaseBase database, InsertSelectBuilder insertBuilder, Parameters parameters)
        {
            var builder = GetBuilder(database.DatabaseType);

            return(builder.GetInsertSelectQuery(database, insertBuilder, parameters));
        }