complete stored procedures, add data provider methods