/// <summary> /// AddParameter /// </summary> /// <param name="value">参数值</param> /// <returns>参数名称</returns> public string AddParameter(object value) { string name = string.Format("p_{0}", _parameters.Count + 1); _parameters.Add(name, SqliteDataBase.CreateParameter(name, value)); return(name); }
private SqliteDataBaseScope(SqliteDataBase dataBase, bool trans = false) { _dataBase = dataBase; if (dataBase.QuoteCount <= 0) { dataBase.Open(); } else { dataBase.QuoteCount += 1; } if (!trans || dataBase.Transaction == null) { return; } this._isHearTransaction = true; dataBase.Transaction = dataBase.Connection.BeginTransaction(); }
/// <summary> /// AddParameter /// </summary> /// <param name="name">参数名(无名称使用序号)</param> /// <param name="value">参数值</param> /// <returns>True表示设置到旧参数,False表示增加了一个参数</returns> public bool SetParameterValue(string name, object value) { if (name == null) { name = string.Format("p_{0}", _parameters.Count + 1); _parameters.Add(name, SqliteDataBase.CreateParameter(name, value)); return(false); } SQLiteParameter parameter; if (this._parameters.TryGetValue(name, out parameter)) { parameter.Value = value; return(true); } _parameters.Add(name, SqliteDataBase.CreateParameter(name, value)); return(false); }
public static SqliteDataBaseScope CreateScope(SqliteDataBase dataBase, bool trans = false) { return(new SqliteDataBaseScope(dataBase, trans)); }