UltraLite.NET User's Guide
  Tutorial: Visual Studio Application

Lesson 2: Create an UltraLite schema file

This section assumes some familiarity with the UltraLite Schema Painter. For more information, see the UltraLite Schema Painter Tutorial.

Create a schema file

1. Use the UltraLite Schema Painter to create a database schema in the same directory as your application with the following characteristics:

   • Schema file name    tutorial.usm

   • Character set    Default

   • Case sensitivity    Leave unchecked.

   • Table name    Names

   • Columns    Create columns in the Names table with the following attributes:

     Column Name	Data Type (Size)	Allow NULL?	Default value
     id	integer	No	autoincrement
     name	char(30)	No	None

   • Primary key    Ascending id

2. Link the schema file to your application:

   1. From the Visual Studio .NET 2003 interface, choose Project > Add Existing Item.

   2. Browse to your tutorial directory and select tutorial.usm.

   3. Click the down arrow on the Open button and choose Link File to add the file to your application.

   4. Once the tutorial schema file has been linked to your application, right click it in the Solution Explorer and select Properties. In the properties pane, set the Build Action property to Content.

You have now added the schema file to your application.