1.0

1. Start Visual Studio 2008.
2. Select View > Server Explorer to open the Server Explorer window.
3. Right-click the Data Connections node and choose Add Connection.... to display the Add Connection
dialog.
4. Click Change... to display the Change Data Source dialog.
5. In the Data provider menu, select .NET Framework Data Provider for SQLFire and click OK.
6. In the Server field, anter the hostname and port of the SQLFire server or locator to which you want to connect
(for example, localhost:1527).
7. Click Test Connection to verify that you can connect to the SQLFire system.
8. Click OK to create the connection. A SQLFire node is added to the Data Connections node.
The connection settings are saved for future use. You can use the saved connection to design or edit tables,
columns, indexes, foreign keys, constraints, views, and triggers.
Editing Tables
Use SQLFire.NET Designer to visually create and modify SQLFire tables.
Prerequisites
Before you follow this procedure:
• Install the SQLFire.NET Designer component. See Installing SQLFire.NET Designer on page 133.
• Create a connection to a SQLFire system in Visual Studio 2008. See Connecting to a SQLFire Distributed
System on page 133.
Procedure
To design SQLFire tables with SQLFire.NET Designer:
1. Start Visual Studio 2008.
2. Select View > Server Explorer to open the Server Explorer window.
3. Right-click the Data Connections > SQLFire node.
4. To create a new table, right-click the Tables folder and select Add New Table to open the Table Designer.
5. To edit an existing table, right-click an available table name and select Design to open the Table Designer.
6. The Table Designer view provides several features to help you edit SQLFire tables:
• Column editor grid—Use the column editor grid at the top of the view to add, delete, or rearrange table
columns. Enter column names and data types directly in the labeled cells. Choose Allow Nulls if the column
should allow null values.
Click the cell to the left of a column to select the entire column, or drag the cell to the left of the column
up or down to rearrange columns.
Right-click in the cell to the left of a column to access the column's context menu (for example, to delete
a column or display the Properties window).
• Properties window—Use this window to edit the name and schema of the table.
• Table Designer menu—Use this menu to perform editing tasks such as adding and deleting columns,
setting the primary key column, editing indexes and primary keys, editing foreign key relationships, or
editing check constraints. The sections that follow describe these tasks in more detail.
7. Select File > Save Tablen or File > Save All to save your changes.
8. When creating a new table, SQLFire.NET Designer prompts you to enter a table name. Specify the schema
and table name, separated by a period (for example, APP.Table1).
vFabric SQLFire User's Guide134
Developing Applications with SQLFire