Expose API for advisory locks

Postgresql has a mechanism for backend-managed advisory locks:
http://www.postgresql.org/docs/9.3/static/explicit-locking.html

Exposed this via a clean API in Npgsql.