public async Task Test_UnmappedProgram_RunsAndReturnsExpectedResult()
{
DatabasesConfiguration configuration = DatabasesConfiguration.Active;
SqlProgram unmappedProgram = await configuration.GetSqlProgram("test2", "spReturnsScalar");
Assert.AreEqual("spReturnsScalar", unmappedProgram.Name);
Assert.AreEqual("HelloWorld", await unmappedProgram.ExecuteScalarAsync <string>());
}
public async Task Test_UnmappedProgramOnDifferentConnection_RunsAndReturnsExpectedResult()
{
DatabasesConfiguration configuration = DatabasesConfiguration.Active;
// Get a program which does not use the default lbc.
SqlProgram diffConnection = await configuration.GetSqlProgram("test", "spReturnsScalarString");
// Check name was not mapped
Assert.AreEqual("spReturnsScalarString", diffConnection.Name);
// Check the sproc runs
Assert.AreEqual("HelloWorld", await diffConnection.ExecuteScalarAsync <string>());
}
public async Task Test_CheckMappedProgramReturnsExpectedResult()
{
DatabasesConfiguration configuration = DatabasesConfiguration.Active;
// Get a program that is mapped by the configuration
SqlProgram <string> mappedProgram = await configuration.GetSqlProgram <string>("test2", "TestProgram", "@P1");
// Check the names were mapped.
Assert.AreEqual("spTakesParamAndReturnsScalar", mappedProgram.Name);
Assert.AreEqual("@firstName", mappedProgram.Parameters.Single().Key);
// Check the sproc runs.
string name = Guid.NewGuid().ToString().Substring(0, 10);
string result = mappedProgram.ExecuteScalar <string>(name);
Assert.AreEqual("Hello " + name, result);
}
