sql server - get late employee from database using entity framework -

i working in web app , have 2 table 1 employees, 2-log_time(emp_id:int , log_time :datetime ,log_type : string ) use calendar select date , wont retrieve employee log_lime=calunder.selectedday , log time>8 .

2-retrive late employee between 2 selected date ,

any idea

select employees.emp_id,employees.first_name,employees.manager_id,log_time.log_time log_time join employees on(employees.emp_id=log_time.emp_id) (convert (date,log_time) between '{0}' , '{1}') , convert(time,log_time.log_time)>='08:00:00'

this worked