is it possible to mimic the functionality of ms-access with c#?

views:

answers:

+2 Q:

is it possible to mimic the functionality of ms-access with c#?

+3 A:

You can do this using ADO.Net DataTable.

Concurrency issues need to be carefully managed - for example, when multiple people change the same row, how are you going to handle that?

Steve Townsend 2010-10-04 16:50:38

@steve thanks! i am going to manage it the same way i managed ms-access: no managing - they are responsible for their own changes

i am a girl 2010-10-04 16:51:34

Er, C# isn't going to give you the same kind of options as you get with Access's optimistic locking.

David-W-Fenton 2010-10-04 19:17:27

@david that's exactly my question, can you please direct me to a resource about optimistic locking?

i am a girl 2010-10-04 19:25:21

@jenny - try this http://msdn.microsoft.com/en-us/library/aa0416cz.aspx

Steve Townsend 2010-10-04 19:29:15

@jenny: This is not a simple issue at all. Access has a whole set of default behaviors built in so you don't have to program anything at all to cover this issue. I don't use C# so can't tell you what to do, but you'll have to roll your own, both in the way you interact with the data, and with a UI to help the user respond to write conflicts.

David-W-Fenton 2010-10-05 21:24:23

@David-W-Fenton - that is what I meant when I mentioned management of concurrency issues. I am sure that to mimic Access behaviour is decidedly non-trivial. @jenny, I suggest you take a look at the `DataTable` events for change notification, and the info on optimistic locking, and come back with separate questions.

Steve Townsend 2010-10-05 22:50:27

ansaurus

tags:

views:

answers:

is it possible to mimic the functionality of ms-access with c#?

related questions