RadhaKrishnaKiJaya

<div>
Hi Chris,<br />
Thank you so much for your wonderful help. I had to change little bit to make it work. Instead of &nbsp;&quot;get&quot; &nbsp;used &quot;Fetch&quot; method.<br />
&nbsp;<br />
var MemberRecentSignIn = _MemberFailedSignInReposit<wbr />ory.Fetch(<wbr />x =&gt; x.UserName == UserName &amp;&amp;&nbsp;x.Created &gt;= DateTime.Today).OrderByDes<wbr />cending(x =&gt; x.Created).FirstOrDefault(<wbr />);<br />
<br />
Thank you again!
</div>


Hi Chris,
Thank you so much for your wonderful help. I had to change little bit to make it work. Instead of  "get"  used "Fetch" method.
 
var MemberRecentSignIn = _MemberFailedSignInRepository.Fetch(x => x.UserName == UserName && x.Created >= DateTime.Today).OrderByDescending(x => x.Created).FirstOrDefault();

Thank you again!

<div>
No worries. Glad I could help
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have this query. (I am sorry, I don't know what type of query is this)<br />

<pre><code id="code-10-29147486-1">var MemberRecentSignIn = _MemberFailedSignInRepository.Get(x =&gt; x.UserName == UserName);</code></pre>
<br />
This query returns all the records for that user. But I want only the latest record for todays date. I want something like this If I would do in SQL.<br />
<br />

<pre><code id="code-10-29147486-2">SELECT TOP (1) [ID],[UserName],[LockCounter],[LockFlag],[Created]
                                FROM MemberFailedSignIns where 
                                Created &gt;= DATEADD(DAY, 0, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP))
                                AND Created &lt;  DATEADD(DAY, 1, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP))order by created desc</code></pre>
</div>
</div>


Hi Experts,

I have this query. (I am sorry, I don't know what type of query is this)
(CODE)

This query returns all the records for that user. But I want only the latest record for todays date. I want something like this If I would do in SQL.

(CODE)

Need help with a LINQ type query

Microsoft’s ASP.NET MVC is a web application framework that implements the model–view–controller (MVC) pattern. As an open-source software, it’s set apart from the ASP.NET Web Forms component, which is proprietary.

.NET MVC

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).