Re: DataTable efficiency

Sorry, just realized that the DataTable.Load method is available only
in .NET 2.0.... In that case, you will need to derive a class from
DbDataAdapter in order to expose the protected method
DbDataAdapter.Fill(DataTable, IDataReader).

S=E9bastien

On 11/23/07, S=E9bastien Lorion <[email protected]> wrote:
> You can create the DataTable before hand and then use the Load method
> (the CsvReader implement IDataReader).
>
> S=E9bastien
>
> On 11/23/07, Alan Baljeu <[email protected]> wrote:
> > I like it in concept, but... Currently I'm using the ODBC driver to rea=
d these files.  It
> > uses schema.ini to convert specified columns to bool or int.  Your code=
 just gives me
> > strings.  Have you any suggestion on how I might adapt the CSV reader t=
o parse columns
> > according to a schema?  Initially I imagine putting this stuff into Dat=
aTables because
> > anything else will require much code conversion.
> >
> > > -----Original Message-----
> > > From: Discussion relating to the specifics of the C# and
> > > Managed C++ languages [mailto:[email protected]]
> > > On Behalf Of S=E9bastien Lorion
> > > Sent: Wednesday, November 21, 2007 11:09 PM
> > > To: [email protected]
> > > Subject: Re: [DOTNET-CX] DataTable efficiency
> > >
> > > You may want to take a look at my CSV reader found on Code Project:
> > >
> > > http://www.codeproject.com/cs/database/CsvReader.asp
> > >
> > > Sebastien
> > >
> > > On 11/21/07, Alan Baljeu <[email protected]> wrote:
> > > > My application uses a largish readonly database (CSV files,
> > > actually)
> > > > consisting of several tables.  These tables are accessed somewhat
> > > > frequently, and I want to make this as efficient as
> > > possible.  I'm currently using plain DataTable objects
> > > produced by OdbcAdapters and
> > > > queries.     These tables are cached so I'm just searching
> > > in-memory tables after that.  My
> > > > queries look like "SELECT * FROM [{0}]" and occasionally
> > > "SELECT * FROM [{0}] where [{1}] =3D
> > > > '{2}'".    I'm thinking of splitting the latter into just
> > > table.Select("colname =3D value").
> > > >
> > > > I have a nagging suspicion that the DataTable structure isn't
> > > > super-efficient, or that certain ways of using it are
> > > effcient while others aren't.
> > > >
> > > > Is this so?  Are there certain things I should avoid?  Do you
> > > > recommend a certain style for efficient access?  Is there a
> > > better approach that DataTable?
> > > >
> > > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > > > This list is hosted by DevelopMentor(R)  http://www.develop.com
> > > >
> > > > View archives and manage your subscription(s) at
> > > > http://discuss.develop.com
> > > >
> > >
> > >
> > > --
> > > S=E9bastien
> > > www.sebastienlorion.com
> > >
> > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > > This list is hosted by DevelopMentor(R)  http://www.develop.com
> > >
> > > View archives and manage your subscription(s) at
> > > http://discuss.develop.com
> >
> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > This list is hosted by DevelopMentor(R)  http://www.develop.com
> >
> > View archives and manage your subscription(s) at http://discuss.develop=
.com
> >
>
>
> --
> S=E9bastien
> www.sebastienlorion.com
>


--=20
S=E9bastien
www.sebastienlorion.com

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
This list is hosted by DevelopMentor=AE  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com