[ Team LiB ] Recipe 10.7 Creating a New SQL Server Database Problem You need to create a new database in your SQL Server. Solution Use the CREATE DATABASE statement. The sample code executes the DDL statement—using the ExecuteNonQuery( )
[ Team LiB ] Recipe 2.3 Creating a Strongly Typed DataSet Problem You want to create a strongly typed object wrapper around a DataSet. Solution Use one of the three techniques shown in the discussion to create a strongly typed DataSet using either the Visual Studio .NET IDE or a command line approach.
[ Team LiB ] Recipe 6.1 Creating a Class That Participates in an Automatic Transaction Problem You need to create a .NET class that participates in automatic transactions. Solution Use the appropriate custom attributes from the System.EnterpriseServices namespace.
[ Team LiB ] Recipe 10.6 Creating a New Access Database Problem You need to create a new Microsoft Access database. Solution Use ActiveX Database Objects Extensions (ADOX) from .NET through COM interop. You'll need a reference to Microsoft ADO Ext. 2.7 for DDL and Security from the COM tab in Visual Studio
[ Team LiB ] Recipe 10.15 Creating a Table in the Database from a DataTable Schema Problem You need to create a table in a database from an existing DataTable schema. Solution Use the CreateTableFromSchema( ) method shown in this solution.
After completing this lesson, you should be able to do
• Create a database with the Database Configuration
• Create a database design template with the DBCA
• Generate database creation scripts with the DBCA