Esempio n. 1
0
        /// <summary>
        /// Executes an asynchronous Razor SQL command with the specified model and updates the model from its resulting data set.
        /// </summary>
        /// <typeparam name="TModel">Type of the concrete parameter model.</typeparam>
        /// <param name="model">A concrete model containing parameter values for the command.</param>
        /// <param name="configure">A method for configuring command options.</param>
        /// <param name="commandName">The command name to locate the Razor page by. Defaults to the name of the calling method.</param>
        /// <param name="cancellationToken">The token to monitor for cancellation requests.</param>
        protected async Task ExecuteAsync <TModel>(TModel model = default, Action <SqlOptions> configure = null, [CallerMemberName] string commandName = null, CancellationToken cancellationToken = default)
        {
            IProcResult result = this.ExecuteAndGetResult(commandName, model, new ProcArgs()
            {
                ModelType  = typeof(TModel) == typeof(object) ? model?.GetType() : typeof(TModel),
                ResultType = typeof(object),
            });

            SqlOptions options = this.GetCommandOptions(result.Domain);

            configure?.Invoke(options);

            ISqlSerializer <Command> serializer = result.Buffer as ISqlSerializer <Command>;
            IEnumerable <Command>    commands   = serializer.Serialize(options);

            CommandOptions commandOptions = new CommandOptions()
            {
                ConnectionFactory = result.Domain.ConnectionFactory,
                Filters           = options.Filters,
            };

            CommandEngine engine = new CommandEngine(commandOptions);

            await engine.ExecuteAsync(commands, cancellationToken).ConfigureAwait(false);
        }
        public async Task Test_MultiInsertAsync_WithExplicitTransaction()
        {
            this.helper.CreateTable();

            Command[]     commands = this.GetMultiInsertCommands();
            CommandEngine engine   = this.helper.GetCommandEngine(new TransactionFilter());

            try
            {
                await engine.ExecuteAsync(commands);
            }
            catch (DbException) { }

            this.helper.VerifyTransaction();
        }
        public async Task Test_InsertsAsync_WithTransactionScope()
        {
            this.helper.CreateTable();

            Command       command = this.helper.GetInsert();
            CommandEngine engine  = this.helper.GetCommandEngine(new TransactionScopeFilter());

            try
            {
                await engine.ExecuteAsync(command);
            }
            catch (DbException) { }

            this.helper.VerifyTransaction();
        }
Esempio n. 4
0
        public async Task Test_CommandEngine_Connection()
        {
            var connection1 = new SqliteConnection(DatabaseHelper.TestDbConnectionString);
            var connection2 = new SqliteConnection(DatabaseHelper.TestDbConnectionString);

            try
            {
                CommandOptions options1 = new CommandOptions()
                {
                    ConnectionFactory = () => connection1,
                };

                CommandOptions options2 = new CommandOptions()
                {
                    ConnectionFactory = () => connection2,
                };

                CommandEngine engine1 = new CommandEngine(options1);
                CommandEngine engine2 = new CommandEngine(options2);

                engine1.Execute(new Command()
                {
                    CommandText = "SELECT 0;"
                });
                await engine2.ExecuteAsync(new Command()
                {
                    CommandText = "SELECT 0;"
                });

                connection1.State.ShouldBe(ConnectionState.Closed);
                connection2.State.ShouldBe(ConnectionState.Closed);
            }
            finally
            {
                connection1.Dispose();
                connection2.Dispose();
            }
        }