Concatenate two Columns in LINQ to search

Help
1

I need to concatenate the multiple columns in linq something like this:

DataTable.Select(“Convert([First Name],‘System.String’) & “Convert([LastName],‘System.String’)='”+FullName.ToString()+”'").CopyToDataTable().Rows.Count

Any help how to do this in Assign activity ?

2

how about this…

dt.AsEnumerable().Where(function(x) x(“Column1”).ToString & x(“Column2”).ToString() = “AkshaySandhu” ).Select(function(y) y).Count.ToString

1 Like