title: How to find the data between month in entityframework?
body: <p>I had requirement to display the data of this month (between month starting to ending data )
  I know how to do in MySQL  below query </p>
  
  <pre><code>enter code here select  @MonthAmount := IFNULL(sum(AmountReceived), 0.0) as TotoalAmountperMonth  
      from collection 
      where  date_time between DATE_FORMAT(NOW() ,'%Y-%m-01') 
          and LAST_DAY(now() - interval 0 month ) and AgentID=v_agent) as monthamount
  </code></pre>
  
  <p>but how to do using entity (lambda expression) I am new to entity when I google I got to get the data of today but in month?</p>
  
  <p>below query got the result of today data</p>
  
  <pre><code>enter code here  var newAuctionsResults = repo.FindAllAuctions()
                      .Where(a =&gt; a.IsActive == true 
                                  || (a.StartTime.Value.Year == todayYear
                                      &amp;&amp; a.StartTime.Value.Month == todayMonth
                                      &amp;&amp; a.StartTime.Value.Day == todayDay))
                      .ToList();
  </code></pre>