# System.Data.DataSetExtensions assembly

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2017-01-30 20:12 UTC
**Views:** 1104
**Replies:** 6
**URL:** https://www.epiusers.help/t/system-data-datasetextensions-assembly/37075

---

## Post #1 by @litzer67

I am trying to add System.Data.DataSetExtensions in a UI Customization Custom Assembly Reference with no luck.  My guess it is because it is a System Assembly and not a Epicor or User Assembly.

Wondering if there is a way.  I want to be able to use IQueryable and/or IEnumerable in a LINQ query.

Scott

---

## Post #2 by @josecgomez

you could manually drop the dll in the client folder but that's generally not recommended.

---

## Post #3 by @litzer67

Yea, I don’t want to do that.  I guess it is a foreach loop then.

Thanks

---

## Post #4 by @josecgomez

That's all that LINQ does in the back end anyways

---

## Post #5 by @litzer67

Yea, I was looking to convert a DataSet to a .AsQueryable so I did not have to loop through it.  I like to use .Any if I am looking for a condition in multiple rows

---

## Post #6 by @josecgomez

You can do Select and use the SQL Syntax 

DataSet.Table[0].Select("MyField = 33")

---

## Post #7 by @litzer67

Nice, I did not think of that.  Thanks

---


**Canonical:** https://www.epiusers.help/t/system-data-datasetextensions-assembly/37075
**Original content:** https://www.epiusers.help/t/system-data-datasetextensions-assembly/37075