SQL Where in to Linq with DataTable

Viewed 136

I'm trying to achieve this in c#

Select a.Name,a.Param
from Customization a
where a.name in (select Name from Standard)

I have try something like this but it still doesn't work.

 merge = dt1.AsEnumerable()
            .Where(r => r.Field<string>("Name")
            .Contains(dt2.Rows.Contains("Name")))
            .CopyToDataTable();
1 Answers
Related