A standards based multi-dialect SQL solution to enable applications work.
BSEditor: 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 databases 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. you can free download SwisSQL API (.NET) 3.5 now.