public SQLiteCommand(string commandText, SQLiteConnection connection, SQLiteTransaction transaction) { CommandText = commandText; DbConnection = connection; DbTransaction = transaction; m_parameterCollection = new SQLiteParameterCollection(); }
/// <summary> /// Initializes a command with the given SQL, connection and transaction /// </summary> /// <param name="commandText">The SQL command text</param> /// <param name="connection">The connection to associate with the command</param> /// <param name="transaction">The transaction the command should be associated with</param> public SQLiteCommand(string commandText, SQLiteConnection connection, SQLiteTransaction transaction) { _commandTimeout = 30; _parameterCollection = new SQLiteParameterCollection(this); _designTimeVisible = true; _updateRowSource = UpdateRowSource.None; if (commandText != null) { CommandText = commandText; } if (connection != null) { DbConnection = connection; _commandTimeout = connection.DefaultTimeout; } if (transaction != null) { Transaction = transaction; } SQLiteConnection.OnChanged(connection, new ConnectionEventArgs( SQLiteConnectionEventType.NewCommand, null, transaction, this, null, null, null, null)); }
/// <summary> /// Initializes a command with the given SQL, connection and transaction /// </summary> /// <param name="commandText">The SQL command text</param> /// <param name="connection">The connection to associate with the command</param> /// <param name="transaction">The transaction the command should be associated with</param> public SQLiteCommand(string commandText, SQLiteConnection connection, SQLiteTransaction transaction) { _statementList = null; _activeReader = null; _commandTimeout = 30; _parameterCollection = new SQLiteParameterCollection(this); _designTimeVisible = true; _updateRowSource = UpdateRowSource.FirstReturnedRecord; _transaction = null; if (commandText != null) { CommandText = commandText; } if (connection != null) { DbConnection = connection; } if (transaction != null) { Transaction = transaction; } }
public SQLiteCommand(string commandText, SQLiteConnection connection, SQLiteTransaction transaction) { CommandText = commandText; DbConnection = connection; DbTransaction = transaction; m_parameterCollection = new SQLiteParameterCollection(); }
protected void AsetaOsoitteenArvot(SQLiteParameterCollection parameters) { parameters.AddWithValue("$lahiosoite", Lahiosoite); parameters.AddWithValue("$postitoimipaikka", Postitoimipaikka); parameters.AddWithValue("$postinro", Postinumero); parameters.AddWithValue("$email", Email); parameters.AddWithValue("$puhelinnro", Puhelinnumero); }
/// <summary> /// AddRangeW with value /// </summary> /// <param name="conn"></param> /// <param name="values"></param> public static void AddRangeWithValue(this SQLiteParameterCollection conn, Dictionary <string, object> values) { conn.CheckNull(nameof(conn)); #if NETFRAMEWORK || NETSTANDARD2_0 foreach (var pair in values) { var key = pair.Key; var value = pair.Value; #else foreach (var(key, value) in values) { #endif conn.AddWithValue(key, value); } } }
/// <summary> /// Initializes a command with the given SQL, connection and transaction /// </summary> /// <param name="commandText">The SQL command text</param> /// <param name="connection">The connection to associate with the command</param> /// <param name="transaction">The transaction the command should be associated with</param> public SQLiteCommand(string commandText, SQLiteConnection connection, SQLiteTransaction transaction) { _commandTimeout = 30; _parameterCollection = new SQLiteParameterCollection(this); _designTimeVisible = true; _updateRowSource = UpdateRowSource.None; if (commandText != null) { CommandText = commandText; } if (connection != null) { DbConnection = connection; _commandTimeout = connection.DefaultTimeout; } if (transaction != null) { Transaction = transaction; } }
public SQLiteCommand(string commandText, SQLiteConnection connection, SQLiteTransaction transaction) { this._statementList = null; this._activeReader = null; this._commandTimeout = 30; this._parameterCollection = new SQLiteParameterCollection(this); this._designTimeVisible = true; this._updateRowSource = UpdateRowSource.None; this._transaction = null; if (commandText != null) { this.CommandText = commandText; } if (connection != null) { this.DbConnection = connection; this._commandTimeout = connection.DefaultTimeout; } if (transaction != null) { this.Transaction = transaction; } }
/// <summary> /// Initializes a command with the given SQL, connection and transaction /// </summary> /// <param name="commandText">The SQL command text</param> /// <param name="connection">The connection to associate with the command</param> /// <param name="transaction">The transaction the command should be associated with</param> public SQLiteCommand(string commandText, SQLiteConnection connection, SQLiteTransaction transaction) { _statementList = null; _activeReader = null; _commandTimeout = 30; _parameterCollection = new SQLiteParameterCollection(this); _designTimeVisible = true; _updateRowSource = UpdateRowSource.FirstReturnedRecord; _transaction = null; if (commandText != null) CommandText = commandText; if (connection != null) DbConnection = connection; if (transaction != null) Transaction = transaction; }
/// <summary> /// Initializes a command with the given SQL, connection and transaction /// </summary> /// <param name="commandText">The SQL command text</param> /// <param name="connection">The connection to associate with the command</param> /// <param name="transaction">The transaction the command should be associated with</param> public SQLiteCommand(string commandText, SQLiteConnection connection, SQLiteTransaction transaction) { _commandTimeout = 30; _parameterCollection = new SQLiteParameterCollection(this); _designTimeVisible = true; _updateRowSource = UpdateRowSource.None; if (commandText != null) CommandText = commandText; if (connection != null) { DbConnection = connection; _commandTimeout = connection.DefaultTimeout; } if (transaction != null) Transaction = transaction; SQLiteConnection.OnChanged(connection, new ConnectionEventArgs( SQLiteConnectionEventType.NewCommand, null, transaction, this, null, null, null, null)); }
/// <summary> /// Initializes a command with the given SQL, connection and transaction /// </summary> /// <param name="commandText">The SQL command text</param> /// <param name="connection">The connection to associate with the command</param> /// <param name="transaction">The transaction the command should be associated with</param> public SQLiteCommand(string commandText, SQLiteConnection connection, SQLiteTransaction transaction) { _commandTimeout = 30; _parameterCollection = new SQLiteParameterCollection(this); _designTimeVisible = true; _updateRowSource = UpdateRowSource.None; if (commandText != null) CommandText = commandText; if (connection != null) { DbConnection = connection; _commandTimeout = connection.DefaultTimeout; } if (transaction != null) Transaction = transaction; }