title: ADO.NET : how to run sql query with parameters?
body: <p>version is PostgreSQL 14.2
  I have perfect sql query:</p>
  <pre><code>select  
          details -&gt;&gt; 'id' as vr_id, 
          details -&gt;&gt; 'lastname' as lastname, 
          details -&gt;&gt; 'birthdate' as birthday, 
          jsonb_path_query_first(details, 
                                '$.contacts.phoneList[*] ? (@.fullNumber == &quot;0671234567&quot; &amp;&amp; @.verifyStateId == 1)'
                               ) -&gt;&gt; 'businessId' as businessId,
          jsonb_path_query_first(details, 
                                '$.contacts.phoneList[*] ? (@.fullNumber == &quot;0671234567&quot; &amp;&amp; @.verifyStateId == 1)'
                               ) -&gt;&gt; 'fullNumber' as fullnumber
  from public.information
  where details @? '$.contacts.phoneList[*] ? (@.fullNumber == &quot;0671234567&quot; &amp;&amp; @.verifyStateId == 1)';
  </code></pre>
  <p>I need use in this SQL the parameters for phone number and stateId.</p>
  <p>vPhone varchar := '0671234567';     --  fullNumber</p>
  <p>vStateId int := 1;                  --  verifyStateId</p>
  <p>something like that</p>
  <pre><code>select  
          details -&gt;&gt; 'id' as vr_id, 
          details -&gt;&gt; 'lastname' as lastname, 
          details -&gt;&gt; 'birthdate' as birthday, 
          jsonb_path_query_first(details, 
                                '$.contacts.phoneList[*] ? (@.fullNumber == &quot;vPhone&quot; &amp;&amp; @.verifyStateId == vStateId)'
                               ) -&gt;&gt; 'businessId' as businessId,
          jsonb_path_query_first(details, 
                                '$.contacts.phoneList[*] ? (@.fullNumber == &quot;vPhone&quot; &amp;&amp; @.verifyStateId == vStateId)'
                               ) -&gt;&gt; 'fullNumber' as fullnumber
  from public.information
  where details @? '$.contacts.phoneList[*] ? (@.fullNumber == &quot;vPhone&quot; &amp;&amp; @.verifyStateId == vStateId)';
  </code></pre>
  <p>I plan use this sql as procedure for .Net Core API.</p>
  <p>How I can to give these parameters to sql-query?</p>