internal SqliteBase(SQLitePCL.ISQLiteConnection connection, SqliteDateFormats fmt) : base(fmt) { }
internal SqliteConnectionWrapper(SQLitePCL.ISQLiteConnection connection, SqliteDateFormats fmt) : base(connection, fmt) { if (connection == null) throw new ArgumentNullException("connection"); _sqliteDbConnection = connection; }
/// <summary> /// Initializes the connection with the specified SQLite connection /// </summary> /// <param name="connection">The SQLite connection to be wrap as an ADO connection</param> public SqliteAdoConnection(SQLitePCL.ISQLiteConnection connection) : this(connection, null) { }
/////<overloads> ///// Constructs a new SqliteAdoConnection object ///// </overloads> ///// <summary> ///// Default constructor ///// </summary> //public SqliteAdoConnection() // : this("") { //} ///// <summary> ///// Initializes the connection with the specified connection string ///// </summary> ///// <param name="connectionString">The connection string to use on the connection</param> //public SqliteAdoConnection(string connectionString) { // _sql = null; // _connectionState = ConnectionState.Closed; // _connectionString = ""; // _transactionLevel = 0; // _version = 0; // //_commandList = new List<WeakReference>(); // if (connectionString != null) // ConnectionString = connectionString; //} #endregion /// <summary> /// Initializes the connection with the specified SQLite connection /// </summary> /// <param name="connection">The SQLite connection to be wrap as an ADO connection</param> /// <param name="cryptEngine">The cryptographic engine to be used for encryption operations</param> public SqliteAdoConnection(SQLitePCL.ISQLiteConnection connection, IObjectCryptEngine cryptEngine) { if (connection == null) throw new ArgumentNullException("connection"); _sqliteDbConnection = connection; _cryptEngine = cryptEngine; _sql = null; _connectionState = ConnectionState.Closed; _connectionString = ""; _transactionLevel = 0; _version = 0; //_commandList = new List<WeakReference>(); }
/// <summary> /// Translates a SQLite result message into a helpful text description (note: creating these helpful text descriptions is currently a work-in-progress). /// </summary> /// <param name="result">The SQLite result to translate</param> /// <returns>Text description</returns> public static string ToResultText(SQLitePCL.SQLiteResult result) { string resultText = "An unexpected SQLite result was encountered"; switch (result) { case SQLitePCL.SQLiteResult.ABORT: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.AUTH: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.BUSY: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.CANTOPEN: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.CONSTRAINT: resultText = "A SQLite table/column constraint violation occurred."; break; case SQLitePCL.SQLiteResult.CORRUPT: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.DONE: resultText = "A SQLite DONE result was returned."; break; case SQLitePCL.SQLiteResult.EMPTY: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.ERROR: resultText = "A SQLite ERROR result was returned."; break; case SQLitePCL.SQLiteResult.FORMAT: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.FULL: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.INTERNAL: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.INTERRUPT: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.IOERR: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.LOCKED: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.MISMATCH: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.MISUSE: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.NOLFS: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.NOMEM: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.NOTADB: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.NOTFOUND: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.NOTICE: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.OK: resultText = "A SQLite OK result was returned."; break; case SQLitePCL.SQLiteResult.PERM: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.PROTOCOL: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.RANGE: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.READONLY: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.ROW: resultText = "A SQLite ROW result was returned."; break; case SQLitePCL.SQLiteResult.SCHEMA: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.TOOBIG: resultText += ": " + result.ToString(); break; case SQLitePCL.SQLiteResult.WARNING: resultText += ": " + result.ToString(); break; default: resultText += "."; break; } return resultText; }
/// <summary> /// Initializes the statement and attempts to get all information about parameters in the statement /// </summary> /// <param name="sqlbase">The base SQLite object</param> /// <param name="stmt">The statement</param> /// <param name="strCommand">The command text for this statement</param> /// <param name="previous">The previous command in a multi-statement command</param> internal SqliteStatement(SqliteBase sqlbase, SQLitePCL.ISQLiteStatement stmt, string strCommand, SqliteStatement previous) { _sql = sqlbase; _sqlite_stmt = stmt; this._sqlStatement = strCommand; // Determine parameters for this statement (if any) and prepare space for them. int nCmdStart = 0; int n = _sql.Bind_ParamCount(this); int x; string s; if (n > 0) { if (previous != null) nCmdStart = previous._unnamedParameters; _paramNames = new string[n]; _paramValues = new SqliteParameter[n]; for (x = 0; x < n; x++) { s = _sql.Bind_ParamName(this, x + 1); if (String.IsNullOrEmpty(s)) { s = String.Format(CultureInfo.InvariantCulture, ";{0}", nCmdStart); nCmdStart++; _unnamedParameters++; } _paramNames[x] = s; _paramValues[x] = null; } } }