Linq Expression functions not showing up

[Malusi_Ngubane]

I want to write Linq query however Linq functions are not showing up. See below

I want to write something like this
dt_SheetA.AsEnumerable.Intersect…

Please Help

[ppr (Peter Preuss)]

when datatype i a datatable: dt_SheetA.AsEnumerable(9 is needed for the LINQ

Sometimes the Intelisense cache hangs and we dont get suggestions. You can add System.Linq.Expressions also to the imports. Sometimes it helped

[Malusi_Ngubane]

I tried adding that one too but it’s did not work and yes the data type is datatable

[ppr (Peter Preuss)]

as mentioned, sometimes cache is hanging. So we just type in the statements and it will also be accepted.

Also ensure following:

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

[Rahul_Unnikrishnan]

Hello @Malusi_Ngubane

Just try to restart the studio and try it once. Also check the scope of dt_sheet datatable varibale.