code View

//urgent checks

var q_uvu = db.d_events
			.AsNoTracking()
			.Where(x => x.event_type.ToLower() == "app_verify" && x.date_apt_exe == null && (x.deleted == null || !(bool)x.deleted))
			.Select(s => new { s.id_person, idApt = (string.IsNullOrEmpty(s.id_event) ? "" : "!") }).Distinct();