Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 17 » SQL Anywhere Server - Programming » .NET application programming

SQL Anywhere .NET Data Provider

Microsoft ADO.NET is the latest data access API in the line of ODBC, OLE DB, and ADO. It is the preferred data access component for the Microsoft .NET Framework and allows you to access relational database systems.

The SQL Anywhere .NET Data Provider implements the Sap.Data.SQLAnywhere namespace and allows you to write programs in any of the .NET supported languages, such as Microsoft C# and Microsoft Visual Basic .NET, and access data from SQL Anywhere databases.

Microsoft ADO.NET applications

You can develop Internet and intranet applications using object-oriented languages, and then connect these applications to the database server using the SQL Anywhere.NET Data Provider.


Applications connecting to a database server by using the SQL Anywhere ADO.NET Data Provider.

In this section:
    SQL Anywhere .NET Data Provider features
    The Microsoft .NET Framework is supported through three distinct namespaces.
    .NET sample projects
    There are several sample projects included with the SQL Anywhere .NET Data Provider.
    Using the SQL Anywhere .NET Data Provider in a Microsoft Visual Studio project
    Use the SQL Anywhere .NET Data Provider to develop Microsoft .NET applications with Microsoft Visual Studio by including both a reference to the SQL Anywhere .NET Data Provider, and a line in your source code referencing the SQL Anywhere .NET Data Provider classes.
    Microsoft .NET database connections
    To connect to a database, an SAConnection object must be created. The connection string can be specified when creating the object or it can be established later by setting the ConnectionString property.
    Data access and manipulation
    With the SQL Anywhere .NET Data Provider, there are two ways you can access data, using the SACommand class or the SADataAdapter class.
    Stored procedures
    You can use SQL stored procedures with the SQL Anywhere .NET Data Provider.
    Transaction processing
    You can use the SATransaction object to group statements together. Each transaction ends with a call to the Commit method, which either makes your changes to the database permanent, or the Rollback method, which cancels all the operations in the transaction.
    Microsoft .NET error handling
    Your application should be designed to handle any errors that occur. An SAException object is created when an exception is thrown. Information about the exception is stored in the SAException object.
    Entity Framework support
    The SQL Anywhere .NET Data Provider supports Entity Framework 5.0 and 6.0, separate packages available from Microsoft.
    .NET tracing support
    The .NET Data Provider supports tracing using the .NET tracing feature.
    The SQL Anywhere .NET Data Provider unmanaged code
    When the .NET Data Provider is first loaded by a .NET application (usually when making a database connection using SAConnection), it unpacks a DLL that contains the provider's unmanaged code.