Tutorial: Build an UltraLite.NET Application
The following procedure creates an UltraLite database schema using the UltraLite Schema Painter.
For information on using the Schema Painter, see Lesson 1: Create an UltraLite database schema.
To create a schema file
Start the UltraLite Schema Painter:
From the Start menu, choose Programs > SQL Anywhere 9 > UltraLite > UltraLite Schema Painter.
Use the UltraLite Schema Painter to create a database schema in the same directory as your application with the following characteristics.
Schema file name vbapp.usm or csapp.usm, depending on your application.
Collation sequence 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 | global autoincrement |
| Name | char(30) | No | None |
Primary key Ascending ID
Link the schema file to your application.
From the Visual Studio .NET 2003 interface, choose Project > Add Existing Item.
Browse to your tutorial directory and select csapp.usm or vbapp.usm, as appropriate. Do not click Open.
Click the arrow on the Open button and choose Link File.
In the Solution Explorer, right click your schema file and select Properties. In the properties pane, set the Build Action property to Content.
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.