C sharp and ADO.net

  • Thread starter Thread starter Aseem
  • Start date Start date
A

Aseem

Is it possible to create an in memory database from text files (comma
delimited and format is fixed) using ADO.net combined with Text
Streams.

A project written by us in VB6 has as one of its utility tools the
ability to spit out its database into seperate small files (each file
representing a table). I would like to use some of ADO.net and c
sharp's more advanced features to read these files back into a memory
resident database for further manipulation.

I would greatly appreciate any assistance. thank you.
 
Hi,

You could possibly employ the System.Data.OleDb managed provider with the
OLEDB provider for ODBC that would in turn employ the ODBC driver for CSV.
Another option would be to employ the managed ODBC provider that would talk
to the CSV driver directly.
 
Back
Top