How to SELECT FROM In-Memory dataset in C# .NET?

  • Thread starter Thread starter BillJohnson4
  • Start date Start date
B

BillJohnson4

Experts:

I have built an in-memory dataset by parsing a flat file so that I can
display the contents onto a datagrid.

The Microsoft C# .NET System.Data.DataTable.Select() method allows me
to select all rows that meet certain criteria (just like "WHERE") and
to sort them (just like "ORDER BY").

I want to perform more analysis on this in-memory dataset such as
SUM(), COUNT(*), MIN(), MAX() and possibly even JOIN.

There has to be a way to do SQL commands 100% in-memory without writing
this dataset to a database server. We already have the data in a
dataset in-memory. How can we then use the power of SQL or C# to
process the data further?

Thank you.
 
Stoicho:

Thank you for the link; however, it still does not answer how I can
SUM() across all rows.

I would like to create a view, a column, whatever to SUM() or AVG() or
MIN() or MAX() across all rows of a table in memory.

Any clues or hints?
 
Back
Top