Newbie:Storing .NET datatypes in disconnected ADO.NET tables

  • Thread starter Thread starter Navin Mishra
  • Start date Start date
N

Navin Mishra

Hi,

I am storing .NET datatypes like Hashtable, ArrayList and other .NET
custom classes in disconnected ADO.NET tables. Some questions:

1) Do I need to still synchronize access to the stored ArrayList, Hashtable,
etc. ? Are they stored by value in table colums or still reference to
collection and collection members are stored only ?
2) I've defined relations between tables. Does disconnected dataaset provide
transaction support ?
3) What is the best way to lock tables to boose performance ? Using
multi-reader-single-writer-locks or using a single lock statement whenever
reading and writing tables is fine ?
4) Could data columns contain array of simple as well as complez types and
would full array be printed when WriteXml function is used ? Currently for a
stored custom type only type name is printed. If a custom type defines
ToString function, would that be invoked to print the contects of type ?

Thanks in advance and regards

Navin
 
Navin,

What is the reason that you take this approach. It is in my opinion (and
seen the answers given until now) really something extraordinary.

To give you one answer. A dataset can only contains formats as in a current
SQL type of database, which means that complex types are impossible.

Cor
 
What if dataset is disconnected ? Could it have columns as array of simple
types like string, etc. ?

Thanks
 
Back
Top