datediff with case statement in select query linq

select case statement in linq query.

Here is the query on sql:

select case when DATEDIFF(day,convert(varchar,Min([Order].CreatedOnUtc),101),convert(varchar,Max([Order].CreatedOnUtc),101)) = 0 then
Sum([Order].OrderSubtotal)
else
case when (DATEDIFF(day,convert(varchar,Min([Order].CreatedOnUtc),101),convert(varchar,Max([Order].CreatedOnUtc),101))/30) = 0 then Sum([Order].OrderSubtotal) else
Sum([Order].OrderSubtotal)/
(DATEDIFF(day,convert(varchar,Min([Order].CreatedOnUtc),101),convert(varchar,Max([Order].CreatedOnUtc),101))/30)
end
end as 'Account Value' from [order] where And Account.ID = @Act_ID

I am trying the code here:

var query = _orderRepository.Table;
query = query.Where(o => o.AccountId == accountId);

In query i am getting my value.

After query statement what should i write?? how do i write for case statement using linq???

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
You can also use direct SQL if you find conversion to LINQ difficult

https://msdn.microsoft.com/en-us/library/bb399403.aspx

Nilesh Shah9y ago

For case yo can write ? : operator in LINQ

something like

from n in numbers     
where n > 0 select new { 
   Number = n, Text = (             
      n == 1 ? "One" :             
      n == 2 ? "Two" :            
      n == 3 ? "Three" : "Unknown" ) }

For dtaediff, you can use 
(FirstDate - SecondDate).TotalDays