protected virtual DbCommand GetCommand(Guid marker, QueryCommand qryCommand, DbConnection conn)
{
DbCommand command = GetFactory().CreateCommand();
command.CommandText = qryCommand.Sql;
PrepareCommandParameters(qryCommand.Parameters, command);
command.Connection = conn;
DbTrace.Write(marker, command);
return(command);
}
public virtual IDataReader ExecuteReader(QueryCommand cmd)
{
Guid marker = DbTrace.GetMarker();
DbCommand command = GetCommand(marker, cmd, GetConnection());
command.Connection.Open();
DbTrace.Write(marker, "Connection Open");
IDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection);
DbTrace.Write(marker, "IDataReader returned");
return(dr);
}
public virtual object ExecuteScalar(QueryCommand cmd)
{
using (DbConnection conn = GetConnection())
{
Guid marker = DbTrace.GetMarker();
DbCommand command = GetCommand(cmd, conn);
conn.Open();
DbTrace.Write(marker, "Connection Open");
object obj = command.ExecuteScalar();
DbTrace.Write(marker, "ExecuteScalar completed");
conn.Close();
return(obj);
}
}
public virtual int ExecuteNonQuery(QueryCommand cmd)
{
using (DbConnection conn = GetConnection())
{
Guid marker = DbTrace.GetMarker();
DbCommand command = GetCommand(marker, cmd, conn);
conn.Open();
DbTrace.Write(marker, "Connection Open");
int rowCount = command.ExecuteNonQuery();
DbTrace.Write(marker, "ExecuteNonQuery completed");
conn.Close();
return(rowCount);
}
}
protected virtual DbCommand GetCommand(QueryCommand qryCommand, DbConnection conn)
{
return(GetCommand(DbTrace.GetMarker(), qryCommand, conn));
}
