Where Clause using lambda always returns true in Unit Testing
<p>I have a table with 2 columns.</p>

<pre><code>| DealerCode | TransactionID |
| 222223     | 98766         |
</code></pre>

<p>and i have this method that returns a list</p>

<pre><code>public List&lt;Transaction&gt; GetCurrentTransaction(string dealerCode, string transactionId)
    {
        return context.Transactions.Where(c =&gt; c.DealerCode == dealerCode &amp;&amp; (c.TransactionID == transactionId)).ToList();
    }
</code></pre>

<p>however everytime i tried to unit test it, it always display true, as you can see in my testing, i purposedly created a wrong parameter so that it would fail.</p>

<pre><code>Assert.IsNotNull(tran.GetCurrentTransaction("2222231", "987661"));
</code></pre>

<p>i have tried searching thru the forums and googling to no avail.</p>
