SqlSiphon is an ADO.NET wrapper that simplifies the process of connecting to MS SQL Server, MySQL, PostgreSQL, and OleDB-compliant databases and executing stored procedures (for SQL Server and MySQL) or text queries on them.
The project's core ethos is pretty simple: keep everything to the most basic datatypes possible. SqlSiphon is not an Object-Relational Mapping (ORM) system. It is a system for simplifying the strict use of relational SQL in applications and assist in the management of database change.
- Succinct execution of arbitrary SQL through ADO.NET without disposable object leaks.
- Maintains naming and parameter typing between stored procedures in the database and application level calls of SPs.
- Maps query results to class objects for meaningful consumption.
- Synchronizes stored procedures between environments.
- Keeps query code managed with application code, in source control
- Assists in schema migration
- Bulk insert with:
- SQL Server table-value parameters
- PostgreSQL array parameters
Currently, it has been tested and used regularly with:
- MS SQL Server:
- 2005,
- 2008,
- 2012
- MySQL:
- 5.1,
- 5.5
- MS Access 2010
- Some CSV and Excel documents (via the JET OleDB driver)
- PostgreSQL 9.2 (only basic functionality tested so far, but is probably good)
- Expand database support
- SQL Server Compact Edition
- Oracle
- SQLite
- SqlAnywhere
- Generic ODBC drivers (code exists, but is untested)
- Postgres and MySQL schema management and migration
- Query structure analyzer