Musing about drag-drop parameter generation

  • Thread starter Thread starter Earl
  • Start date Start date
E

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?
 
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)
 
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.
 
Back
Top