Once you have created an ESP function and linked it into a DLL, register it as an ESP in a database. This lets the user execute the function as an ESP.
Use either of these methods to register an ESP:
The Transact-SQL create procedure command
The sp_addextendedproc system procedure
