SQL Queries in ADO.NET datatables

  • Thread starter Thread starter Brian Henry
  • Start date Start date
B

Brian Henry

I wish someday they would add the ability to perform SQL commands on data
tables in ADO.net... it would make some stuff so much easier...
 
Brian Henry said:
I wish someday they would add the ability to perform SQL commands on data
tables in ADO.net... it would make some stuff so much easier...
Click to expand...

Were you aware of the DataTable.Select method?

John Saunders
 
The problem with the DataTable.Select method is that it works on a single
datatable and is very poor in comparison to real SQL commands. Does anyone
knows about a way to run SQL commands on a dataset? I.e, to query the
in-memory dataset...

Thanks,
Arnon.
 
Arnon Axelrod said:
The problem with the DataTable.Select method is that it works on a single
datatable and is very poor in comparison to real SQL commands. Does anyone
knows about a way to run SQL commands on a dataset? I.e, to query the
in-memory dataset...
Click to expand...

Sorry, you'll have to "roll your own', using DataTable.Select,
DataTable.Compute, DataRelations and adding computed columns.

It's usually better to let databases do the "database" work...

John Saunders
 
Back
Top