sqlsharp(1) General Commands Manual sqlsharp(1) (NAME) sqlsharp - SQL (SYNOPSIS) sqlsharp [-f filename] [-o filename] [-s] (DESCRIPTION) sqlsharp SQL SQL . (OPTIONS) : -f filename SQL . -o filename . -s . (HOW TO USE) SQL . (\) . : \open : \provider \connectionstring \open \quit \help : . \provider Example: SQL# \provider mysql . \connectionstring Example: SQL# \connectionstring Database=test . \open Example: SQL# \open (CONNECTION AND PROVIDER COMMANDS) ConnectionString Example: SQL# \ConnectionString Database=testdb or SQL# \cs Database=testdb CONNECTION STRING EXAMPLES . Provider . PROVIDERS . Example: to set the provider for MySQL: SQL# \provider mysql or SQL# \p mysql Note: if you need to load an external provider in SQL#, see the SQL# command \loadextprovider ListProviders ADO.NET 2.0 Example: SQL# \ListProviders or SQL# \listp BCS (echo) . Example: SQL# \bcs ConnectionString Option: Data Source [] SQL# blazer ConnectionString Option: Persist Security Info [False] SQL# ConnectionString Option: Integrated Security [False] SQL# ConnectionString Option: User ID [] SQL# scott Password: ***** ConnectionString Option: Enlist [False] SQL# ConnectionString Option: Pooling [True] SQL# ConnectionString Option: Min Pool Size [0] SQL# ConnectionString Option: Max Pool Size [100] SQL# ConnectionString Option: Unicode [False] SQL# ConnectionString Option: Load Balance Timeout [0] SQL# ConnectionString Option: Omit Oracle Connection Name [False] SQL# ConnectionString is set. LoadExtProvider (ASSEMBLY CLASS) . Connection . Example: to load the MySQL provider Mono.Data.MySql SQL# \loadextprovider Mono.Data.MySql Mono.Data.MySql.MySqlConnection Open Example: SQL# \open Close Example: SQL# \close Default Provider ConnectionString. Example: SQL# \defaults Q Example: SQL# \q SQL e SQL ( SELECT) : SQL# SELECT * FROM EMPLOYEE SQL# \e : \e ; . : SQL# SELECT * FROM EMPLOYEE; exenonquery SQL ( SELECT) : : SQL# INSERT INTO SOMETABLE (COL1, COL2) VALUES('ABC','DEF') SQL# \exenonquery : . exescalar SQL ( ). : Maximum SQL# SELECT MAX(grade) FROM class SQL# \exescalar exexml FILENAME SQL XML : SQL# SELECT fname, lname, hire_date FROM employee SQL# \exexml employee.xml : DataAdapter DataTable DataSet (FILE COMMANDS) SQL# f FILENAME SQL# : SQL# \f batch.sql# : SQL# . SQL . o FILENAME . : SQL# \o result.txt load FILENAME SQL SQL. : SQL# \load commands.sql save FILENAME SQL SQL . : SQL# \save commands.sql . h ( ). : SQL# \h s TRUE FALSE . : SQL# \s true : SQL# \s false r . : SQL# \r print SQL. : SQL# \print (VARIABLES WHICH CAN BE USED AS PARAMETERS) SQL . SQL . set NAME VALUE . : SQL# \set sFirstName John unset NAME . : SQL# \unset sFirstName variable NAME . : SQL# \variable sFirstName (PROVIDER SUPPORT OPTIONS) . UseParameters TRUEFALSE SQL . true SQL SQL# . : SQL# \useparameter true : false UseSimpleReader TRUEFALSE (simple reader) . : SQL# \usesimplereader true : false. . IDataReader (simple reader) . SqlClient MySQL PostgreSQL true . PROVIDER NAME NAMESPACE ASSEMBLY oracle Oracle 8i-11g System.Data.OracleClient System.Data.OracleClient postgresql NetPostgreSQL Npgsql Npgsql bytefx ByteFX MySQL ByteFX.Data.MySqlClient ByteFX.Data sqlclient MS SQL 7-2008 System.Data.SqlClient System.Data odbc ODBC System.Data.Odbc System.Data sqlite SQL Lite Mono.Data.SqliteClient Mono.Data.SqliteClient sybase Sybase Mono.Data.SybaseClient Mono.Data.SybaseClient firebird Firebird SQL FirebirdSql.Data.FirebirdSql FirebirdSql.Data.Firebird mysql MySQL AB MySql.Data.MySqlClient MySql.Data : Npgsql .NET PostgreSQL . : http://npgsql.projects.postgresql.org MySql.Data MySQL Connector/Net MySQL . MySQL ByteFX.Data MySql.Data . MySql.Data Mono . MySQL Connector/Net MySQL AB : http://dev.mysql.com/downloads FirebirdSql.Data.Firebird : http://www.firebirdsql.org/index.php?op=files&id=netprovider (CONNECTION STRING SAMPLES) onnectionString : onnectionstring Database=testdb : Microsoft SQL Server System.Data.SqlClient Server=DANPC;Database=pubs;User ID=saPassword=; Integrated Security ( ) Mono Windows SQL Server Windows Server . Windows . Server=DANPC;Database=pubs;User ID=DOMAINser;Password=pass;Integrated Security=SSPI localhost . ODBC System.Data.Odbc DSN "MSSQLDSN" ODBC Data Sources Windows Microsoft SQL Server 2000 : DSN=MSSQLDSN;UID=danmorg;PWD=freetds ODBC Unix unixODBC http://www.unixodbc.org iODBC http://www.iodbc.org SQL Lite Mono.Data.SqliteClient SqliteTest.db : URI=file:SqliteTest.db Oracle System.Data.OracleClient Data Source=testdb;User ID=scott;Password=tiger tnsnames.ora TNS host port service name . host IP . User ID=SCOTT; Password=TIGER; Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=TESTDB))) Npgsql (.NET PostgreSQL) http://gborg.postgresql.org/project/npgsql/projdisplay.php Server=localhost;Database=test;User ID=postgres;Password=fun2db ByteFX (ByteFX MySQL) MySql.Data . Server=localhost;Database=test;User ID=mysql;Password= FirebirdSql FirebirdSql.Data.Firebird ( FirebirdSql.org) Database=C:REBIRD;Password=masterkey;Dialect=3;Server=localhost MySQL (MySql.Data) MySQL Connector/Net http://www.mysql.com Server=localhost;Database=test;User ID=mysql;Password=mypass;Pooling=false . (AUTHORS) Mono SQL Query Tool Daniel Morgan (LICENSE) Mono SQL Query Tool GNU GPL . `COPYING' . Novell Daniel Morgan . (BUGS) : https://github.com/mono/mono/issues (MAILING LISTS) : http://lists.ximian.com/mailman/listinfo/mono-devel-list (WEB SITE) : http://www.mono-project.com (SEE ALSO) mono(1) 9 September 2008 sqlsharp(1)