Changing the where clause to use Oracle Command Parameter
<p>I am currently creating the web API to accept one input parameter and using them in the particular field in the where clause. Below is the code for the service</p>

<pre><code>      public HttpResponseMessage Getdetails( string JRS_NO,string DOB)
    {

        List&lt;OracleParameter&gt; prms = new List&lt;OracleParameter&gt;();
        List&lt;string&gt; selectionStrings = new List&lt;string&gt;();
        var jrs ="";
        var dateofBirth="";
        string connStr = ConfigurationManager.ConnectionStrings["TGSDataConnection"].ConnectionString;
        using (OracleConnection dbconn = new OracleConnection(connStr))
        {
            DataSet userDataset = new DataSet();
            var strQuery = "SELECT * from LIMS_SAMPLE_RESULTS_VW where JRS_NO =:jrs and DOB=:dateofBirth";
            jrs = JRS_NO;
            dateofBirth = DOB;
            prms.Add(jrs);
            prms.Add(dateofBirth);
</code></pre>

<p>Instead of giving them directly in the Query how can I use the OracleParameter here.I have created the prms for the command parameter but not sure how to proceed with that.</p>