public void TestThatDefaultScriptReturnsIfSpecficScriptNotFound()
{
var scriptDictionary = new QueryScriptDictionary();
scriptDictionary.Queries.Add(ProviderType.Default, "Default");
Assert.AreEqual("Default", scriptDictionary.GetScript(ProviderType.Oracle));
Assert.AreEqual("Default", scriptDictionary.GetScript(ProviderType.Sql));
}
public void TestScriptReturnsCorrectly()
{
var scriptDictionary = new QueryScriptDictionary();
scriptDictionary.Queries.Add(ProviderType.Oracle, "Oracle");
scriptDictionary.Queries.Add(ProviderType.Sql, "Sql");
Assert.AreEqual("Oracle", scriptDictionary.GetScript(ProviderType.Oracle));
Assert.AreEqual("Sql", scriptDictionary.GetScript(ProviderType.Sql));
}
public void TestThatExceptionThrowsIfSpecficScriptNotFound()
{
var scriptDictionary = new QueryScriptDictionary();
var ex = Assert.Throws <Exception>(() => scriptDictionary.GetScript(ProviderType.Oracle));
Assert.AreEqual("No DB script for Oracle provider was found", ex.Message);
}
public IEnumerable <T> ExecuteQuery <T>(QueryScriptDictionary scripts, object parameters = null, int?commandTimeout = 0)
{
using (var connection = _dbProvider.CreateConnection(_databaseSettings))
{
connection.Open();
var result = connection.Query <T>(scripts.GetScript(_dbProvider.Type), parameters, commandType: CommandType.Text, commandTimeout: commandTimeout);
connection.Close();
return(result);
}
}