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()); }