SwisSQL API (.NET) 3.5

On the Fly SQL Conversion : SwisSQL API (.NET)

SwisSQL API (.NET) provides a standards based multi-dialect SQL solution to enable applications work with multiple databases without needing to port SQL queries from one database dialect to another. SwisSQL API (.NET) comes with a .NET class library which is very simple to use and requires very minimal change to the existing application to make it portable across databases. SwisSQL API (.NET) can be used with VC++, VB, COM and .NET based applications like C# (C Sharp), VB .NET.

Features and Benefits:

• Multi-Dialect SQL parser can parse any SQL Dialect including SQL-99, SQL-92, Oracle, IBM DB2, MS SQL Server, Informix, Sybase, MySQL, PostgresSQL etc.
• Support for the conversion of Oracle SQL to Netezza SQL dialect.
• Support for conversion of Common table expressions (WITH statement) to all the databases
• Support for Select, Update, Insert, Create, Alter and Delete, Drop statements
• High Performance SQL conversion
• 100% C#(CSharp) based implementation
• SwisSQL API (.NET) library component can be leveraged by legacy VC++/VB/COM based applications too
• Low memory footprint
• SQL Object model for advanced users
• "Write SQL Once, Run Any Database"

Applications embedding SwisSQL API can use the API in two ways. Directly parse and convert SQL into different dialects. The second way is to use SwisSQL API ODBC Wrapper, which makes the parsing and conversion of SQL transparent to the applications.

Directly Using SwisSQL API .NET From Applications

SwisSQL API (.NET) Release 3.5 provides a simple and easy to use C# API to utilize the SQL parsing and SQL conversion features from inside the .NET and ASP/COM applications. This ensures applications can leverage the full power a a database's SQL features without needing to worry about portability of the SQL queries across databases. Just by embedding the SwisSQL API (.NET)component, the .NET or the ASP/COM application becomes compatible with other databases.

SwisSQL API ODBC Wrapper

Applications can use SwisSQL API's ODBC Wrapper as bridge between the application and the database specific ODBC driver. Existing applications can leverage seamless integration by just loading the SwisSQL ODBC driver without any other changes.The working model illustration is shown in the figure below.

Supported Database Versions