Random google search for "migrations stored procedures" https://stackoverflow.com/questions/14139445/code-first-migrations-and-stored-procedures#16589152 https:

Random google search for "migrations stored procedures" https://stackoverflow.com/questions/14139445/code-first-migrations-and-stored-procedures#16589152 https://stackoverflow.com/questions/14139445/code-first-migr... shows that EF6 already supports them. And pgTap as an example of testing them https://pgtap.org/ https://pgtap.org/ . What I'm suspicious is that, having seen untested stored procedures, you haven't bothered to try unit test them. I mean, you can do a lot with BEGIN; set db in good state; call procedure; ROLLBACK; but you have to try.