multiple workstations to one database
-
hi, im developing a system where it'll be running accross about four workstations, these four are all connected to a database server. my question is in C# how and where do i synchronize database operations, for example deletion, adding, modifying and searching. also.. is there any theoratical document that shows the difference between Java n C#, i search the net but only to get one that was on syntactical differences(by Dare Obasanjo). Any other reading materials? thx !! CODER
-
hi, im developing a system where it'll be running accross about four workstations, these four are all connected to a database server. my question is in C# how and where do i synchronize database operations, for example deletion, adding, modifying and searching. also.. is there any theoratical document that shows the difference between Java n C#, i search the net but only to get one that was on syntactical differences(by Dare Obasanjo). Any other reading materials? thx !! CODER
The easiest place to synchronize the request is by using locking in the RDBMS, such as the MSDE or SQL Server (in which case use the
System.Data.SqlClientclasses for better support). There are many locking features and many ways to lock queries, so see the SQL Server documentation for more information. You can search MSDN[^] (the one-stop place for most or your Windows development information) for documents that discuss the differences between Java and C#. Keep in mind, however, that C# is just one of many languages that target the CLR. While languages differ in syntax and support of some features of the CLR, they can all access assemblies (including the FCL) written in any other managed language. So the differences you're looking for are between Java (the JVM) and .NET (the CLR), not just C#. The runtimes are completely separate, though they share common ideas like JIT'ing, garbage collection, and other facilities that OO runtimes utilize.Microsoft MVP, Visual C# My Articles