COUNTIF() function in C#

Hello Sahoo,

 

Please find the sql query for getting the result :-

SELECT  tblActionDetails.CustomerID,FID, CONVERT(nvarchar(20), ActionDate, 103) as ActionDate,

REPLACE(SUBSTRING(CONVERT(nvarchar(128),ActionDate, 109), 12 , 128),':000', ' ') as ActionTime,

Status,CAST(CASE WHEN ContactNo2 != '' THEN ContactNo2 ELSE ContactNo1 END AS varchar) as Mobile into #CustDetails

from tblActionDetails inner join tblCustomer on tblCustomer.CustomerID=tblActionDetails.CustomerID

where ActionDate between CONVERT(datetime,'11/11/2018',103)and CONVERT(datetime,'12/11/2018',103)

and Area='OUTBOUND_CALL' and tblCustomer.Status='Ringing' order by FID desc

select #CustDetails.CustomerID,

#CustDetails.ActionDate, #CustDetails.ActionTime,#CustDetails.Status,#CustDetails.Mobile

from #CustDetails order by FID desc

drop table #CustDetails

and the output is:-

 (due to security reason,the value is not provided)

 

above result I want to add a column which says how many time the customer ID has been in this result based on the action date. 

hi 

Count is a agrigate function .so can group in linq or sql for count.

 

Other issues may solve if display your full code