O'Reilly logo

Sams Teach Yourself ADO.NET in 24 Hours by Paul Bertucci, Jason Lefebvre

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hour 19. Using Automatically Generated Commands

Most application code (Web or otherwise) that accesses SQL Server data tends to be fairly simple in nature. Rarely is there the need to do complex table joins as the basis of your DataSet population, let alone as the basis of updates back to the database. In the cases where you are only dealing with single-table commands, you can leverage the CommandBuilder feature of .NET to generate the appropriate INSERT, UPDATE, and DELETE commands for this type of single-table processing automatically. There are some limitations to automatic code generation, but its efficiency and coding simplicity far outweigh these limitations. In addition, Visual Studio .NET Enterprise Architect provides much of the same ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required