Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting same data table after LINQ query
Message
From
11/06/2014 14:32:59
 
General information
Forum:
ASP.NET
Category:
LINQ
Environment versions
Environment:
C# 4.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01601612
Message ID:
01601726
Views:
26
>Hi Rob,
>
>This doesn't seem to work as is
>
>
>  if (resourceEvent)                              
>                  {
>                      // Remove instructors who don't have anything planned
>                      var query = dtInstructors.AsEnumerable().Where(c => dtAllScheduled.AsEnumerable().Any(b =>  1 == b.Field<Byte>("layer") 
>                                          && true==b.Field<Boolean>("schdassign") && c.Field<String>("instr_id")== b.Field<String>("resource_id")
>                                          ));
>                      query.CopyToDataTable(dtInstructors, LoadOption.OverwriteChanges);
>                  }
>
>My dtInstructors has rows but dtAllScheduled does not.
>
>After the query I am supposed to get 0 rows in the dtInstructors but it seems to be the same table as it was before the query. Do you see how can I adjust the code to get the query "overwrite" my original table?
>
>Thanks.

Is it throwing an InvalidOperationException that is being caught elsewhere? See the conditions for that exception at http://msdn.microsoft.com/en-us/library/bb359707(v=vs.110).aspx
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform