updated selectall and selectbypk methods to use stored proc

this is part of an ongoing effort to removed the query based
implementation and replace it with a stored procedure based
implementation.