updated dao methods.