linq-to-dataset – Tarik Billa

DataTable does not contain definition for AsEnumerable

May 14, 2023 by Tarik

The method you want is in the System.Data namespace, so that using directive is fine, but you also need a reference to the System.Data.DataSetExtensions assembly. Are you sure you’ve got that reference as an assembly reference? It’s not clear why you’ve got a using directive for a System.Data.DataSetExtensions namespace – does that not raise an … Read more

Why is LINQ JOIN so much faster than linking with WHERE?

January 3, 2023 by Tarik

Your first approach (SQL query in the DB) is quite efficient because the DB knows how to perform a join. But it doesn’t really make sense to compare it with the other approaches, since they work directly in memory (Linq to DataSet) The query with multiple tables and a Where condition actually performs a cartesian … Read more