Learned Experts, I'm new to SQL server, so before I stumble around in circles, I'm curious about which way is the best to manage a table on a server that is hosting both the WCF services and the database.
I'd really like to take into account concurrency, whereby more than one person/system may be updating the table at the same time (table, row, etc.). I want to start out by having a win exe form present a DGV of the table, and it can be saved via a simple "Save" button. In other words, I don't really require that the changes be instantaneous without a "Save" click (although that would be a productive future goal). So I'm not looking for code (feel free though!), but moreover which high level method(s) you've found to be effective. TIA! pat :)
