I have two table like Customer and VisitDetail and i need to convert below SQL Query into Linq to Sql
select *
from Customer
where id not in (select distinct CustomerId
from visitdetail
where VisitDate='2016-06-13' and SalesRepAccId=1 and
RouteId=10
) and
RouteId = 10 and Active=1 and SalesRepAccId=1
Aucun commentaire:
Enregistrer un commentaire