Am I on the right path part 2

[robjens]

(second part)

Last question I have is about the following construction. I made a class called LisaDataObject (Lisa is the namespace of the application). This class connects to a OleDatabase (MS Access, can't use SQL due to system restrictions on this secure environment and a very rigid IT department who obviously won't support anyones hobby eventhough the project is focussed on a real world scenario from which the organization can benefit).

The class then assigns several properties like DataTable, DataSet or DataRow (and some more). This is done by passing the tablename as an argument.
Example

Dim ldo = New LisaDataObject( )
Dim ds = ldo.DataSet("My TableName")

It's my idea to always load all the table data into the dataset and then use LINQ to select from that source. I feel this is a clean, compact and esthetic solution because I know we will always have small database tables (not much more then 200 rows).

Is this approach possible or are them some very big things that I am missing here and should take into concideration?

Again thanks.

[Frinavale]

Now to answer your "second part"....

Using LINQ is pretty nice but if things are small and access to your database is fast then...why not just skip the LINQ part?

Unless you're manipulating the returned data...

-Frinny