Using Provider-specific Templates
Visual Studio offers a set of templates to help you build applications that automatically include features such as SQL leveling.
Creating a New Project
When you create a new project in Visual Studio, you can use a template specific to the Pervasive PSQL data provider, or a template that creates an application with generic code.
In the following example, we create a new project in Visual Studio using the template for the Pervasive PSQL data provider.
1
Select File / New / Project... The New Project dialog appears.
2
In the Project Types pane, select Visual C# / Pervasive PSQL.
3
Make any necessary changes to the fields on the New Project dialog:
a.
In the Templates pane, select Pervasive PSQL Project.
b.
In the Name field, type a name, for example, My Pervasive Project, or accept the default name.
c.
In the Location field, type the location to which you want to save the project, or click Browse to navigate to the directory.
d.
In the Solution Name field, type the name for the solution.
e.
If you are using Visual Studio 2008, you can select the version of the .NET Framework that you want to use from the drop-down list at the top of the window.
4
Click OK.
5
The new project appears in the Solution Explorer. The namespace for the Pervasive PSQL ADO.NET data provider is automatically added to the project.
NOTE: If you are using the ADO.NET 2.0 common programming model, select the Pervasive Generic Provider Project template. In this case, the project does not require a specific reference to an assembly.
Adding a Template to an Existing Project
To add a Pervasive PSQL template to an existing project:
1
In Solution Explorer, right-click the project and select Add / New Item...
2
In the Add New Item dialog, select the Pervasive PSQL class.
3
Click Add. The class for the Pervasive PSQL data provider is added to the project.