public BookEval findById(Int64? id)
{
if (id == null)
{
return null;
}
String sql = "select * from BookEval where id = @id";
SqlDataReader reader = null;
SqlParameter param = makeParameter("@id", id);
BookEval eval = null;
try
{
reader = accessor.select(sql, param);
if (reader.Read())
{
eval = new BookEval();
eval.Id = Int64.Parse(read(reader, "id").ToString());
eval.Eval = (String) read(reader, "evaluation");
}
}
finally
{
closeReader(reader);
}
return eval;
}
public List<BookEval> findAll()
{
String sql = "select * from BookEval";
SqlDataReader reader = null;
List<BookEval> evalList = new List<BookEval>();
try
{
reader = accessor.select(sql);
while (reader.Read())
{
BookEval eval = new BookEval();
eval.Id = long.Parse((String) read(reader, "id"));
eval.Eval = (String) read(reader, "eval");
evalList.Add(eval);
}
}
finally
{
closeReader(reader);
}
return evalList;
}