public IDataReader ExecuteReader(string query)
{
using (IDbCommand cmd = CreateCommand())
{
cmd.CommandText = query;
return(SqlEngine.ExecuteReader(cmd));
}
}
public T ExecuteScalar <T>(string query)
{
using (IDbCommand cmd = CreateCommand())
{
cmd.CommandText = query;
return(SqlEngine.ExecuteScalar <T>(cmd));
}
}
public int ExecuteNonQuery(string query)
{
using (IDbCommand cmd = CreateCommand())
{
cmd.CommandText = query;
return(SqlEngine.ExecuteNonQuery(cmd));
}
}
public T ExecuteScalar <T>(string query, string[] values)
{
using (IDbCommand cmd = CreateCommand())
{
cmd.CommandText = ((values != null) && (values.Length != 0)) ? string.Format(query, (object[])values)
: query;
return(SqlEngine.ExecuteScalar <T>(cmd));
}
}