I am new to VB.net. Is it mandatory that we use a disconnected model when using Sql Server?
Can we use a persistent connection to a Sql Server database like the old OpenDatabase command?
I am uncomfortable with the disconnected model because I do not understand it well. For instance: Table #1 is loaded into an application as disconnected. A user of that application makes changes to Record #15. But, in a parallel session, Record #15 in Table #1 is changed by another user in another application that is accessing that database too. Let's assume that the last name is changed in both
How is the record's data resolved?