Musing about drag-drop parameter generation

[Earl]

It's fascinating the amount of parameters that are now generated by the
drag-drop SqlDataAdapters. Doesn't this trouble anyone the amount of data
being sent back and forth for a simple insert/update/delete? And that this
is apparently the recommended Microsoft approach?

 

[William \(Bill\) Vaughn]

This is the OSFA approach the code generators take by default. Newer
versions can use a TimeStamp column if present and don't generate as much
code. Frankly, most serious developers use SPs that don't use
client-supplied SQL at all...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[Earl]

Well, I use the SPs, but I had been (2003) taking the easier route of
letting the DAs generate the sproc and parameters before cleaning them up.
This has gotten much messier with the 2005 DAs.