May 2004
Intermediate to advanced
888 pages
22h 31m
English
The majority of commands that are invoked against a database are data retrieval and manipulation commands. Occasionally, however, one must do something dynamically to the structure of the database itself. This might be adding or modifying a table, stored procedure, or other such operations.
There are no dedicated .NET classes that perform these operations explicitly. However, you can still execute DDL commands using the IDbCommand.ExecuteNonQuery() method. Listing 19.3 illustrates this technique.
1: program ddlquery; 2: 3: {$APPTYPE CONSOLE} 4: 5: {%DotNetAssemblyCompiler 'c:\windows\microsoft.net\framework\v1.1.4322\System.Data.dll'} 6: 7: uses 8: SysUtils, ... |
Read now
Unlock full access