Esempio n. 1
0
        public SqlStatement Parse(SqlQueryParser parser)
        {
            var parameters = new Dictionary <string, SqlSubQueryResult>();
            var inserts    = parser.ParseInsertBuilder(FromQuery, InsertExpression, parameters);

            var primaryKey = FromQuery.Columns.Where(c => c.PrimaryKeyAutoIncrement).FirstOrDefault();

            return(new SqlInsert()
            {
                Inserts = inserts,
                TableName = FromQuery.TableName,
                AutoIncrementPrimaryKeyName = primaryKey?.SqlName,
            });
        }
Esempio n. 2
0
        public SqlStatement Parse(SqlQueryParser parser)
        {
            var queryResult = parser.ParseQuery(Parent);
            var parameters  = new Dictionary <string, SqlSubQueryResult>();

            parameters[InsertExpression.Parameters[0].Name] = queryResult.SelectResult; // item
            // parameters[stmt.InsertExpression.Parameters[1].Name] = ; // builder

            var inserts = parser.ParseInsertBuilder(FromQuery, InsertExpression, parameters);

            return(new SqlUpdate()
            {
                FromSource = queryResult,
                Inserts = inserts,
            });
        }