Note: SwisSQL API product was previouly known as SwisSQL SQLOne API.
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.
|
