hi all
i want create Query with Nhibernate
i problem with average time the object
my code :
public static int GetInboxFaultsCount(int InboxId, FaultState State)
{
Criteria criteria = new Criteria();
criteria.Query = "select count(distinct fault) from IFault fault inner join fault.ReceiversInbox inbox where inbox.Id=:id and fault.State =:state AND (not exists (from fault.Results fr where fr.SendState=1 AND fr.OwnerFixUnit.Inbox.id=:id))";
criteria.Parameters.Add("state", State);
criteria.Parameters.Add("id", InboxId);
DataFacade dFacade = new DataFacade();
return dFacade.GetCount(criteria);
}