public T ExecuteQuerySingle(string spQuery, object[] parameters)
{
using (_connection = new DBContextMessage <T>())
{
return(_connection.Database.SqlQuery <T>(spQuery, parameters).FirstOrDefault());
}
}
public IEnumerable <T> ExecuteQuery(string spQuery, object[] parameters)
{
using (_connection = new DBContextMessage <T>())
{
using (var dbContextTransaction = _connection.Database.BeginTransaction())
{
try
{
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
}
}
return(_connection.Database.SqlQuery <T>(spQuery, parameters).ToList());
}
}
public int ExecuteSQLCommand(string spQuery, object[] parameters)
{
int result = 0;
using (_connection = new DBContextMessage <T>())
{
using (var dbContextTransaction = _connection.Database.BeginTransaction())
{
try
{
result = _connection.Database.ExecuteSqlCommand(spQuery, parameters);
dbContextTransaction.Commit();
}
catch (Exception)
{
dbContextTransaction.Rollback();
}
}
}
return(result);
}
