/// <summary>
/// Execure a raw SQL query
/// </summary>
/// <param name="query">Raw SQL query</param>
/// <returns></returns>
public string ExecuteQuery(NccDbQueryText query)
{
string retVal = "";
using (var txn = _entityRepository.BeginTransaction())
{
try
{
var ret = _entityRepository.ExecuteSqlCommand(query);
retVal = ret.ToString();
txn.Commit();
}
catch (Exception ex)
{
txn.Rollback();
}
}
return(retVal);
}
public string ExecuteQuery(NccDbQueryText query)
{
var retVal = _entityRepository.ExecuteSqlCommand(query);
return(retVal.ToString());
}