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 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));
}
protected List <T> Execute(string script)
{
var scriptDictionary = new QueryScriptDictionary();
scriptDictionary.AddQuery(ProviderType.Default, script);
var entities = _dataContext.ExecuteQuery <T>(scriptDictionary);
return(entities.ToList <T>());
}
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));
}
protected List <T> Execute(string sqlScript, string oracleScript)
{
var scriptDictionary = new QueryScriptDictionary();
scriptDictionary.AddQuery(ProviderType.Oracle, oracleScript);
scriptDictionary.AddQuery(ProviderType.Sql, sqlScript);
var entities = _dataContext.ExecuteQuery <T>(scriptDictionary);
return(entities.ToList <T>());
}
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);
}
}
public T ExecuteScalar <T>(QueryScriptDictionary scripts, object parameters = null, int?commandTimeout = null)
{
return(ExecuteQuery <T>(scripts, parameters, commandTimeout).FirstOrDefault());
}