public async Task StreamingResultsSimpleAsync() { var runner = RunnerFactory.Create(); var stream = await runner.QueryStreamAsync("SELECT 1 UNION SELECT 2 UNION SELECT 3"); var result = stream.AsEnumerable <int>().ToList(); result.Should().ContainInOrder(1, 2, 3); stream.Dispose(); }
public async Task StreamingResults_QueryAsync() { var runner = RunnerFactory.Create(); var stream = await runner.QueryStreamAsync(new Query()); var result = stream.AsEnumerable <int>().ToList(); result.Should().ContainInOrder(1, 2, 3); stream.Dispose(); }
public void SqlQuery_ViewCommandBeforeExecution() { string report = null; var runner = RunnerFactory.Create(b => b.ViewCommandBeforeExecution(s => { report = s.Trim(); })); var result = runner.Query(new Query()); result.Should().Be("TEST"); report.Should().Be("SELECT 'TEST';"); }
public void CreateAndQueryStoredProc_Test() { var runner = RunnerFactory.Create(); var batch = runner.CreateBatch(); batch.Add(new CreateTempStoredProcCommand()); var result = batch.Add(new ExecuteStoredProcQuery()); runner.Execute(batch); result.IsComplete.Should().BeTrue(); result.GetValue().Should().Be("TEST"); }
public void Batch_SimpleSql() { var runner = RunnerFactory.Create(); var batch = runner.CreateBatch(); var result = batch.Add <string>("SELECT 'TEST';"); runner.Execute(batch); var list = result.GetValue(); list.Count.Should().Be(1); list[0].Should().Be("TEST"); }
public void CommandAndQueryBatch_AsTask() { var runner = RunnerFactory.Create(); var batch = runner.CreateBatch(); var promise = batch.Add(new QuerySimpleQuery()); var task = promise.AsTask(TimeSpan.FromSeconds(10)); runner.Execute(batch); var result = task.Result; result.Should().Be("TEST"); }
public void Query2_Stringify() { var runner = RunnerFactory.Create(); var parameters = new QueryValues { Value1 = 5, Value2 = 3.14f, Value3 = "TEST" }; var query = new Query(parameters); var result = runner.ObjectStringifier.Stringify(query); result.Should().NotBeNullOrEmpty(); }
public void ParameterObject_Test() { var runner = RunnerFactory.Create(); var parameters = new QueryValues { Value1 = 5, Value2 = 3.14f, Value3 = "TEST" }; var result = runner.Query(new Query(parameters)); result.Value1.Should().Be(5); result.Value2.Should().Be(3.14f); result.Value3.Should().Be("TEST"); }
public void CommandAndQueryBatch_Transaction() { var runner = RunnerFactory.Create(b => b.UseTransaction(IsolationLevel.Serializable)); var batch = runner.CreateBatch(); batch.Add(new CreateTempTableCommand()); var result = batch.Add(new QueryTempTableQuery()); runner.Execute(batch); result.IsComplete.Should().Be(true); var list = result.GetValue(); list.Should().NotBeNull(); list.Should().BeEquivalentTo(1, 3, 5, 7); }
public void CommandAndQueryBatch_SimpleSql() { var runner = RunnerFactory.Create(); var batch = runner.CreateBatch(); batch.Add(@" CREATE TABLE #castiron_test ( [Value] INT NOT NULL ); INSERT INTO #castiron_test ([Value]) VALUES (1),(3),(5),(7);"); var result = batch.Add <int>("SELECT * FROM #castiron_test;"); runner.Execute(batch); result.IsComplete.Should().Be(true); var list = result.GetValue(); list.Should().NotBeNull(); list.Should().BeEquivalentTo(1, 3, 5, 7); }
public void GetResultEnumerable_Parameter_Map() { Result Read(IDataResults result) { var results = result.AsEnumerable <string>(); var paramValue = result.GetOutputParameter <string>("value"); var firstResult = results.First(); return(new Result { OutputParameterValue = paramValue, ResultSetValue = firstResult }); } var runner = RunnerFactory.Create(); Action getResults = () => runner.Query(new QueryWithResultSetAndParameterQuery(), Read); getResults.Should().Throw <SqlQueryException>(); }