title: how to set N prefix before sql parameter
body: <p>i writed a query like this:</p>
  
  <blockquote>
  <pre><code>SELECT [FirstName], [LastName] 
  FROM [WorkersView] 
  WHERE ([FirstName] LIKE '%' + N'علی' + '%' ) AND ([LastName] LIKE '%' + N'مسروری' + '%')
  </code></pre>
  </blockquote>
  
  <p>and it's work very well! and Gives me the desired result!</p>
  
  <p>but i want send parameter to the query like this:</p>
  
  <blockquote>
  <pre><code>SELECT [FirstName], [LastName] 
  FROM [WorkersView] 
  WHERE ([FirstName] LIKE '%' + N@FirstName + '%' ) AND ([LastName] LIKE '%' + N@LastName + '%')
  </code></pre>
  </blockquote>
  
  <p>that don't worked!</p>
  
  <p>and also i tried this code:</p>
  
  <blockquote>
  <pre><code>SELECT [FirstName], [LastName] 
  FROM [WorkersView] 
  WHERE ([FirstName] LIKE N'%' + @FirstName + '%' ) AND ([LastName] LIKE N'%' + @LastName + '%')
  </code></pre>
  </blockquote>
  
  <p>that don't worked,too! and No result returns!</p>
  
  <p>my collation is Persian_100_CI_AI. and all of data type of columns in nvarchar</p>
  
  <p>meantime, i have this code in asp.net :</p>
  
  <blockquote>
  <pre><code>            &lt;asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" Width="645px"&gt;
                  &lt;Columns&gt;
                      &lt;asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" /&gt;
                      &lt;asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" /&gt;
                  &lt;/Columns&gt;
              &lt;/asp:GridView&gt;
              &lt;asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="&lt;%$ ConnectionStrings:ResamanConnectionString %&gt;"  SelectCommand="SELECT [FirstName], [LastName] FROM [WorkersView] WHERE (([FirstName] LIKE N'%' + @FirstName + N'%') AND ([LastName] LIKE N'%' + @LastName + N'%'))" &gt;
                  &lt;SelectParameters&gt;
                      &lt;asp:ControlParameter ControlID="firstNameTextBox" Name="FirstName" PropertyName="Text" Type="String" /&gt;
                      &lt;asp:ControlParameter ControlID="lastNameTextBox" Name="LastName" PropertyName="Text" Type="String" /&gt;
                  &lt;/SelectParameters&gt;
              &lt;/asp:SqlDataSource&gt;
  </code></pre>
  </blockquote>
  
  <p>how to send parameter with this code with N prefix?</p>