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

[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

 

[Cor Ligthert [MVP]]

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

 

[Navin Mishra]

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

Thanks

 

[Cor Ligthert [MVP]]

Navin,

Have a look at this sample.

http://www.vb-tips.com/default.aspx?ID=b57d0ce2-3f5f-47d4-9663-fee3733fcd6f

I hope this helps,

Cor