How to Transform SQL Queries with Dynamic Single Quote Replacements

How to Correctly Pass nvarchar Parameter to SQL Stored Procedure from .NET Application?