title: How to pass a row as a parameter to a Postgres function using .net core DBFunction
body: <p>Passing pgsql table object as parameter using c# .net core?</p>
  <p>HI in pgsql we can pass table row as parameter , I want to know how we can use it in .net core?</p>
  <p>like below function takes some parameters and give its functionality</p>
  <pre><code>   -CREATE OR REPLACE FUNCTION public.&quot;GetUserName&quot;(u &quot;User_&quot;, pmed &quot;Pharmacy&quot;, puser &quot;Pharmacy&quot;, m &quot;Medication&quot;)
   RETURNS character varying
   LANGUAGE plpgsql
  AS $function$
  BEGIN
      return (
          case when u.&quot;Id&quot; &gt; 0 then
              (
                  u.&quot;FirstName&quot; || ' ' ||coalesce(u.&quot;LastName&quot;, '')
                  || (
                      case when u.&quot;Pharmacy_Id&quot; &gt; 0 then
                              (case when puser.&quot;PharmacyId&quot; &gt; 0 then ' (' || puser.&quot;PharmacyName&quot; || ') ' else '' end)
                      else '' end
                  )
              )
          when coalesce (u.&quot;Id&quot; , 0) = 0 then pmed.&quot;PharmacyName&quot; else '' end
      );
  END
  $function$
  ;
  </code></pre>
  <p>I want to call this function using .net core ef core without dynamic queries using DbFunctions appraoch</p>