public void SqlQuery_Tests()
{
var runner = RunnerFactory.Create();
var result = runner.Query(new Query());
result.Should().Be("TEST");
}
public void Execute_TypedOutputParameter()
{
var runner = RunnerFactory.Create();
var result = runner.Execute(new CommandWithTypedOutputParameter());
result.Should().Be("TEST");
}
public void TestQuery1_Test()
{
var target = RunnerFactory.Create();
var result = target.Query(new TestQuery1());
result.TestInt.Should().Be(5);
result.TestString.Should().Be("TEST");
}
public void SqlQuery_Combine()
{
var runner = RunnerFactory.Create();
var query = SqlQuery.Combine("SELECT 'TEST'", r => r.AsEnumerable <string>().First());
var result = runner.Query(query);
result.Should().Be("TEST");
}
public void SqlQueryRawCommand_GetParameters()
{
var runner = RunnerFactory.Create();
var result = runner.Query(new CommandWithParameter());
result.Should().NotBeNull();
result.Value.Should().Be("TEST");
}
public void MapOnto_MappedTest()
{
var target = RunnerFactory.Create();
var result = target.Query(new MapOntoQuery_MappedRecord());
result.Id.Should().Be(1);
result.Name.Should().Be("TEST");
result.Value.Should().Be("VALUE");
}
public void StreamingResults_Query()
{
var runner = RunnerFactory.Create();
var stream = runner.QueryStream(new Query());
var result = stream.AsEnumerable <int>().ToList();
result.Should().ContainInOrder(1, 2, 3);
stream.Dispose();
}
public void GetResultEnumerable_Map_Parameter()
{
var runner = RunnerFactory.Create();
var result = runner.Query(new QueryWithResultSetAndParameterQuery(), new EnumerateMapParameterMaterializer());
result.Should().NotBeNull();
result.OutputParameterValue.Should().Be("param");
result.ResultSetValue.Should().Be("result");
}
public void SqlQuery_PerformanceReport()
{
string report = null;
var runner = RunnerFactory.Create(b => b.MonitorPerformance(s => report = s));
var result = runner.Query(new Query());
result.Should().Be("TEST");
report.Should().NotBeNull();
}
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 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 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>();
}
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);
}