Sams Teach Yourself ADO.NET in 24 Hours

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 ...