Hour 19. Using Automatically Generated Commands

for RuBoard

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 type of code generation capability but does not use the CommandBuilder object. In both cases, Microsoft continues to try to make the programmer's job easy.

In this hour, you will learn the following topics:

• When automatically generated commands are created

• Coding examples using the CommandBuilder

• What to do when the original SELECT statement changes

• A brief look at Windows Form Designer “generated code

for RuBoard