Comments by Member 12669478

Member 12669478 19-Aug-16 2:26am View

you had all the right to say that yesterday, about converting this code to line I started working on converting the code, I read the links you provided , the problem I have now is when I tested the query it is not working, as I thought it did in the beginning, yesterday I thought the sql query was correct, I all out of ideas, I am not asking anyone to convert any thing, as you said yesterday i should try it myself. but with the sql query that is all I could come up with. thanks

Member 12669478 18-Aug-16 7:18am View

linq to sql

Member 12669478 14-Aug-16 8:16am View

Deleted

BillWoodruff

Member 12669478 14-Aug-16 7:36am View

Deleted

datalist = (from g in DBCon.Schedules
where g.Date == Calendar1.SelectedDate
select g.StartTime).ToList();

var WorkingHours = (from g in DBCon.WorkingHours
select g.WorkingHours).Except(datalist);

is this what you ment, i tried this and got the following error

Local sequence cannot be used in LINQ to SQL implementations of query operators except the Contains operator.

Comments by Member 12669478 (Top 4 by date)