protected override void SelectParameters(IDbCommand command, UnidadeCurricular.ID k)
{
SqlParameter p1 = new SqlParameter("@uc_sigla", k.Sigla);
SqlParameter p2 = new SqlParameter("@ano", k.Data);
command.Parameters.Add(p1);
command.Parameters.Add(p2);
}
public override UnidadeCurricular Read(UnidadeCurricular.ID id)
{
using TransactionScope ts = new TransactionScope(TransactionScopeOption.Required);
UnidadeCurricular entity = new UnidadeCurricular();
EnsureContext();
context.EnlistTransaction();
using (IDbCommand cmd = context.createCommand()) {
cmd.CommandText = SelectCommandText;
cmd.CommandType = SelectCommandType;
SelectParameters(cmd, id);
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
IDataRecord info = reader;
entity = Map(info);
}
reader.Close();
}
ts.Complete();
return(entity);
}
