The SQL Anywhere .NET Data Provider can be used when developing .NET applications with Visual Studio. To use the SQL Anywhere .NET Data Provider, you must include two items in your Visual Studio project:
a reference to the SQL Anywhere .NET Data Provider
a line in your source code referencing the SQL Anywhere .NET Data Provider classes
These steps are explained below.
For information about installing and registering the SQL Anywhere .NET Data Provider, see Deploying the SQL Anywhere .NET Data Provider.
Adding a reference to the Data Provider in your projectAdding a reference tells Visual Studio which provider to include to find the code for the SQL Anywhere .NET Data Provider.
To add a reference to the SQL Anywhere .NET Data Provider in a Visual Studio projectStart Visual Studio and open your project.
In the Solution Explorer window, right-click References and choose Add Reference.
On the .NET tab, scroll through the list to locate any of the following:
Note that there is separate version of the provider for Windows Mobile platforms. For the Windows Mobile SQL Anywhere .NET Data Provider, click the Browse tab and locate the Windows Mobile version of the provider. The default location is install-dir\CE\Assembly\V2.
Select the provider of your choice and then click OK. The provider is added to the References folder in the Solution Explorer window of your project.
Using the Data Provider classes in your source codeTo assist with the use of the SQL Anywhere .NET Data Provider namespace and the types defined in this namespace, you should add a directive to your source code.
To use the Data Provider namespace in your codeStart Visual Studio and open your project.
Add the following line to your project:
If you are using C#, add the following line to the list of using directives at the beginning of your project:
using iAnywhere.Data.SQLAnywhere; |
If you are using Visual Basic, add the following line at the beginning of your project before the line Public Class Form1:
Imports iAnywhere.Data.SQLAnywhere |
This directive is not required, however, it allows you to use short forms for the SQL Anywhere .NET classes. For example:
SAConnection conn = new SAConnection() |
Without this directive, you can still use the following:
iAnywhere.Data.SQLAnywhere.SAConnection conn = new iAnywhere.Data.SQLAnywhere.SAConnection() |
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |