Dear NG,
I have not heard from anyone about a good book that deals with the
concurrency issue in SQL Server using C#. I have PROMISED Nick I would not
use record locking and I have used an old row / new row approach. (see next
paragraph for my reply to Nick) I would like to use Timestamps and
Transactions to produce an iron-clad and efficient application in a
multi-user environment. Can anyone recommend such a book?
OK Nick, I promise NEVER to even CONSIDER locking. I have two new skills to
learn: 1/ Transactions and 2/ using timestamps. I had been using a
technique of old record / new record to determine if the record had been
changed on update or delete. Timestamps seem more elegant. Sadly, the book
I have been using for learning SQL is Petkovic, SQL Server 2000, A
Beginner's Guide. He mentions timestamps, but then goes forward to
explaining locking (and not to well I might add). Can you suggest a good
book that implements your suggested approach to concurrency that would cover
both the C# and the SQL issues?
Thank you,
Bob
Robert Schuldenfrei bo*@s-i-inc.com 5 1495
Robert Schuldenfrei wrote: Dear NG,
I have not heard from anyone about a good book that deals with the concurrency issue in SQL Server using C#. I have PROMISED Nick I would not use record locking and I have used an old row / new row approach. (see next paragraph for my reply to Nick) I would like to use Timestamps and Transactions to produce an iron-clad and efficient application in a multi-user environment. Can anyone recommend such a book?
[...]
If you don't mind reading Java articles, I recommend looking up web
resources on "Optimistic Locking" -- I guess that's what you're referring
to.
Cheers,
--
Joerg Jooss jo*********@gmx .net
Robert:
Try in the microsoft.publi c.dotnet.framew ork.adonet newsgroup. William
Ryan should be able to give you a good book reference.
--
Scott http://www.OdeToCode.com
On Wed, 25 Aug 2004 11:43:27 GMT, "Robert Schuldenfrei"
<bo*@s-i-inc.com> wrote: Dear NG,
I have not heard from anyone about a good book that deals with the concurrency issue in SQL Server using C#. I have PROMISED Nick I would not use record locking and I have used an old row / new row approach. (see next paragraph for my reply to Nick) I would like to use Timestamps and Transactions to produce an iron-clad and efficient application in a multi-user environment. Can anyone recommend such a book?
OK Nick, I promise NEVER to even CONSIDER locking. I have two new skills to learn: 1/ Transactions and 2/ using timestamps. I had been using a technique of old record / new record to determine if the record had been changed on update or delete. Timestamps seem more elegant. Sadly, the book I have been using for learning SQL is Petkovic, SQL Server 2000, A Beginner's Guide. He mentions timestamps, but then goes forward to explaining locking (and not to well I might add). Can you suggest a good book that implements your suggested approach to concurrency that would cover both the C# and the SQL issues?
Thank you,
Bob
Robert Schuldenfrei bo*@s-i-inc.com
Hi Kevin,
Thanks for the follow up. I have printed out the articles you and Scott
suggested. I have noted the two books below. I now face the classic issue
of students: Do I just read the articles and plow right into my application
OR do I get the book and learn ADO.NET cold? I am 61 years old and doing
this just for a hobby, so I think I will take the latter approach. I live
in suburban Boston and we have a great technical book store, SoftPro, in
Waltham. I will see if they have either one of the books you mention.
The John Papa article has an interesting slant that I picked up on by just
briefly looking over the paper. He talks about the old row / new row
technique, the TIMESTAMP, and placing his own DATETIME column in the record.
He says he prefers the TIMESTAMP, but then goes on to illustrate the
DATETIME method! I am currently using the old row / new row technique so I
was disappointed to see that he was not going to demonstrate the TIMESTAMP.
Ah well...
Thank you for taking the time to help me. In some ways my knowledge is very
deep. I programmed an IBM 7044 back in 1963. But in many respects my
command of the wonderful world of object orientated programming is indeed
shallow. My professional career was in the application of computer based
techniques and not in programming per se. It is only now in retirement that
I get a chance to program for fun.
Cheers,
Bob
Robert Schuldenfrei bo*@s-i-inc.com
"Kevin Yu [MSFT]" <v-****@online.mic rosoft.com> wrote in message
news:uh******** ******@cpmsftng xa10.phx.gbl... Hi Robert,
First of all, I would like to confirm my understanding of your issue. From your description, I understand that you need a reference book about concurrency issues. If there is any misunderstandin g, please feel free to let me know.
In your last thread, Scott has given us a good article "Handling Data Concurrency Using ADO.NET" John Papa http://msdn.microsoft.com/msdnmag/is...s/default.aspx
There are many technical articles about ADO.NET concurrency on the web. Here is one of them
http://support.microsoft.com/default...%2Fwebcasts%2F en%2Ftranscript s%2Fwct050103.a sp
Based on my research, there doesn't seem to be books dealing with concurrency issues dedicatedly. However, some ADO.NET books have topic about this. Here are some of them.
http://www.amazon.com/exec/obidos/tg...087697-3274358 ?v=glance http://www.amazon.com/exec/obidos/tg...087697-3274358 ?v=glance
HTH.
Kevin Yu ======= "This posting is provided "AS IS" with no warranties, and confers no rights."
Hi Robert,
Never too old to learn! :-)
The technical articles only solves problem in certain aspect. If you need
to learn the whole ADO.NET architecture for better programming, I suggest
you read Bob's Essential ADO.NET (I have met Bob once. :-) or David's
Microsoft ADO.NET (Core Reference). Here is a link for this book. http://www.microsoft.com/mspress/books/5354.asp
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights." This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: lkrubner |
last post by:
This might be an idiot question, but how do you group by timestamps by
date? I mean, given a large number of timestamps, spanning many months,
how do grab them and say how many are from each day? If the timestamps
measure visits to a web site, how to easily say there were 45 visits on
January 4th?
The first idea that occurs to me is to put them all in an array and
then loop through the array and use date() on each, one at a time,...
|
by: Robert Schuldenfrei |
last post by:
Hi NG,
I am looking for an opinion here. I am new to C# and SQL, being an old
COBOL hand. I have started into a conversion of an old COBOL ERP system. I
have a number of functions working now and it is time to decide how best to
deal with the issues of concurrency. The old COBOL programs used record
locking to prevent concurrency errors and that logic is already "on the
shelf." Most C# books and articles I have seen use the default...
|
by: Robert Schuldenfrei |
last post by:
Hi NG,
I needed some information about using SQL Timestamps for resolving
concurrency errors. I bought the book: Pragmatic ADO.NET to aid me in this
endeavor. Some people have asked me if I found a book. This posting is
just to thank the people who responded. There is no need to respond further
to this posting.
Cheers,
|
by: Chumma Dede |
last post by:
Hi,
I need to code a DLL in .NET which logs the response times for our asp.net
multi-tier application. The problem is we need to log the timestamps at
multiple stages in a process lifecycle roundtrip without too much overhead.
We have two webservers which are load balanced and the back end tiers
include Biztalk and several remoting components all of which should ideally
use this same dll for logging timestamps in a central location in...
|
by: Craig G |
last post by:
im not too sure how i should be storing the SQL2000 timestamps
basically i return a dataset which is used to populate an editable grid.
this dataset contains the timestamp. how should i be storing the timestamps
for each grid row? is it possible to hold them in the grid in someway? or do
i need to look at other means
ive only used Oracle Timestamps before and they where just decimal
timestamps which made it easy!! could just store them...
| |
by: Erwin Van de Velde |
last post by:
Hi,
I'm building a central logging system for security applications as my master
thesis, but I've run into some troubles:
Different applications make database logs using different formats:
- Timestamps as timestamps or as numeric values
- IP addresses in dotted notation (aaa.bbb.ccc.ddd) or as numeric values
I'd like to convert these to the same type, so that I can compare them. Two
|
by: john conwell |
last post by:
I'm a fairly seasoned vet with .net 1.1, and want a hardcore, indepth review
of the new changes in 2.0, mostly covering the core namespaces and the
System.Windows.Forms namespace. I dont really care about ASP.Net.
Most of the books on 2.0 take it from the point of a beginner, which is a
waste of time and money for me.
any good book recomendations?
|
by: boris |
last post by:
can someone recommend me a book on c++ game programming.I am keenly
intrested in coding games but a beginner in c++ so plz recommend
accordingly.
|
by: Ira Solomon |
last post by:
I am an experienced programmer (40 years). I've done Algol (if you've
heard of that you must be old too), PL/1, VB,VBA, a little C, and a
few other odd languages (e.g. Taskmate).
I'm interested in learning Python and have downloaded a slew of books.
Too many.
I'd like a recommendation as to which books are considered to be the
cream of the crop.
I know there are tutorials on the web, but, again, I don't know the
quality. I would...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |