How can we test the stored procedure from the database by us

Question

How can we test the stored procedure from the database by using the moq objects in C#?

 

I have two sp's in database. I have tested two sp's by using the MS Unit test. In deployment i faced a problem. I could not be able to access database in application server. That's why i came up with the moq framework. I need to test those two sp's by using the moq objects instead of actual database calls. Can you please suggest me is there any better way to do?