Newbie: locking disconnected datasets

[Navin Mishra]

Hi,

I've a disconnected dataset to have a sort of in-memory cache(in lieu of
using hashtables) and still take advantage of SQL Like syntax to search,
insert and update data as well as relations, cascading deletes, etc. Is it
necessary to lock the whole dataset when doing any inserts, updates, etc. Or
would it suffice to lock table, table row, etc. only depending upon data to
be updated ?

Could there be any performance issues too ?

Thanks in advance and regards

Navin

 

[William \(Bill\) Vaughn]

I would take a step back and check out the new VS 2008 Local Data Cache
technology. This provides a local data cache of rows using the SQL Compact
database engine. Yes, these rows can be queried, joined, filtered, sorted
and deinfenstrated. You might also consider LINQ, but I wouldn't--but that's
just me.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________