Issue with assign activity after updating to Windows Compatability

Help Studio
, ,
1

Hello, I recently updated a project to the new Windows Compatability (.Net Core), and I am now getting an error in my Assign activity. Any help would be appreciated.

Expression Used:
(From x In Dt_EmailNotification.AsEnumerable() Order By convert.Tostring(x(“Subsidiary”)),convert.ToString(x(“ExpirationDate”)) Select x).CopyToDataTable

Error:

image
image778×337 17 KB

image
image1686×250 19.4 KB

2

Please try this

Dt_EmailNotification.AsEnumerable().OrderBy(function(x) x("Subsidiary").ToString).OrderBy(function(x) x("ExpirationDate").ToString).CopyToDataTable

And for the error try retyping by deleting it or use another assign and see…I don’t see an error on the code nor the code shows error in my studio

image
image1437×140 6.13 KB

Hope this helps

Cheers

3

ensure the right doublequotes needed: "

grafik
grafik847×327 114 KB 

(From x In Dt_EmailNotification.AsEnumerable() 
Order By x("Subsidiary").ToString() ,x("ExpirationDate").ToString
Select x).CopyToDataTable

Keep in mind:

x("ExpirationDate").ToString

will cause a lexically ordering

When using the method syntax from LINQ we would use the ThenBy for second ordering
grafik

4

Hello @Anil_G,

First, thank you for reviewing. Are you using Windows compatibility (.Net Core 6) or Windows Legacy (.Net Framework 4.6.xxx). It works when using Windows Legacy (.Net Framework), but when upgrading to Windows compatibility (.Net Core), it no longer works.

5

@PWilliams

Windows is what I am on …and it works…try upgrading packages and then as said retype the formula…the double quotes are different in windows legacy and windows…"(0x22) these are the correct ones…

Hope this helps

Cheers