protected override void SelectParameters(IDbCommand command, UC_Prof.ID k)
{
SqlParameter p1 = new SqlParameter("@uc", k.UC);
SqlParameter p2 = new SqlParameter("@ano", k.Date);
command.Parameters.Add(p1);
command.Parameters.Add(p2);
}
public override UC_Prof Read(UC_Prof.ID id)
{
using TransactionScope ts = new TransactionScope(TransactionScopeOption.Required);
UC_Prof entity = new UC_Prof();
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);
}
