# Using ADO.NET Data Collections (DataSet)

## Content



ADO.NET **DataTable** can also be used in LiveLinq, for example:

```csharp
CustomersDataTable customers = ...
var query =
  from c in customers.AsIndexed() where c.City == "London" select c;
```

For that, you’ll need to add

```csharp
using C1.LiveLinq.AdoNet;
```

to your source file. The **AsIndexed()** used will be [C1.LiveLinq.AdoNet.AdoNetExtensions.AsIndexed](/componentone/api/win/online-datasource/dotnet-framework-api/C1.LiveLinq.4.8/C1.LiveLinq.AdoNet.AdoNetExtensions.AsIndexed.html). It is specifically optimized for data in ADO.NET DataSets.