public object ExecuteSqlScalar(IDbTransaction Transaction, string dbName, string SQL, bool useMaster) { if (Transaction == null) { return(SQLiteExecuter.ExecuteSqlScalar(GetConnectionString(dbName, useMaster), SQL)); } else { return(SQLiteExecuter.ExecuteSqlScalar((SqliteTransaction)Transaction, SQL)); } }
public object ExecuteCommandScalar(IDbTransaction Transaction, string dbName, IDbCommand dbCommand, bool useMaster) { if (Transaction == null) { return(SQLiteExecuter.ExecuteCommandScalar(GetConnectionString(dbName, useMaster), dbCommand)); } else { return(SQLiteExecuter.ExecuteCommandScalar((SqliteTransaction)Transaction, dbCommand)); } }
public int ExecuteSqlNonQuery(IDbTransaction Transaction, string dbName, string SQL) { if (Transaction == null) { return(SQLiteExecuter.ExecuteSqlNonQuery(GetConnectionString(dbName, true), SQL)); } else { return(SQLiteExecuter.ExecuteSqlNonQuery((SqliteTransaction)Transaction, SQL)); } }
public int ExecuteCommandNonQuery(IDbTransaction Transaction, string dbName, IDbCommand dbCommand) { if (Transaction == null) { return(SQLiteExecuter.ExecuteCommandNonQuery(GetConnectionString(dbName, true), dbCommand)); } else { return(SQLiteExecuter.ExecuteCommandNonQuery((SqliteTransaction)Transaction, dbCommand)); } }
/// <summary> /// ExecuteCommandScalarAsync /// </summary> /// <param name="Transaction"></param> /// <param name="dbName"></param> /// <param name="dbCommand"></param> /// <param name="useMaster"></param> /// <returns></returns> /// <exception cref="DatabaseException"></exception> public Task <object> ExecuteCommandScalarAsync(IDbTransaction?Transaction, string dbName, IDbCommand dbCommand, bool useMaster = false) { if (Transaction == null) { return(SQLiteExecuter.ExecuteCommandScalarAsync(GetConnectionString(dbName, useMaster), dbCommand)); } else { return(SQLiteExecuter.ExecuteCommandScalarAsync((SqliteTransaction)Transaction, dbCommand)); } }
/// <summary> /// ExecuteCommandScalarAsync /// </summary> /// <param name="Transaction"></param> /// <param name="dbName"></param> /// <param name="engineCommand"></param> /// <param name="useMaster"></param> /// <returns></returns> /// <exception cref="DatabaseException"></exception> public async Task <object?> ExecuteCommandScalarAsync(IDbTransaction?Transaction, string dbName, EngineCommand engineCommand, bool useMaster = false) { using SqliteCommand dbCommand = CreateTextCommand(engineCommand); if (Transaction == null) { return(await SQLiteExecuter.ExecuteCommandScalarAsync(GetConnectionString(dbName, useMaster), dbCommand).ConfigureAwait(false)); } else { return(await SQLiteExecuter.ExecuteCommandScalarAsync((SqliteTransaction)Transaction, dbCommand).ConfigureAwait(false)); } }
/// <summary> /// ExecuteCommandNonQueryAsync /// </summary> /// <param name="Transaction"></param> /// <param name="dbName"></param> /// <param name="engineCommand"></param> /// <returns></returns> /// <exception cref="DatabaseException"></exception> public async Task <int> ExecuteCommandNonQueryAsync(IDbTransaction?Transaction, string dbName, EngineCommand engineCommand) { using SqliteCommand dbCommand = CreateTextCommand(engineCommand); if (Transaction == null) { return(await SQLiteExecuter.ExecuteCommandNonQueryAsync(GetConnectionString(dbName, true), dbCommand).ConfigureAwait(false)); } else { return(await SQLiteExecuter.ExecuteCommandNonQueryAsync((SqliteTransaction)Transaction, dbCommand).ConfigureAwait(false)); } }
/// <summary> /// ExecuteCommandReaderAsync /// </summary> /// <param name="Transaction"></param> /// <param name="dbName"></param> /// <param name="engineCommand"></param> /// <param name="useMaster"></param> /// <returns></returns> /// <exception cref="DatabaseException"></exception> public async Task <IDataReader> ExecuteCommandReaderAsync(IDbTransaction?Transaction, string dbName, EngineCommand engineCommand, bool useMaster = false) { //使用using的话,会同时关闭reader. //在Microsoft.Data.Sqlite实现中, dipose connection后,会自动dispose command #pragma warning disable CA2000 // Dispose objects before losing scope SqliteCommand dbCommand = CreateTextCommand(engineCommand); #pragma warning restore CA2000 // Dispose objects before losing scope if (Transaction == null) { return(await SQLiteExecuter.ExecuteCommandReaderAsync(GetConnectionString(dbName, useMaster), dbCommand).ConfigureAwait(false)); } else { return(await SQLiteExecuter.ExecuteCommandReaderAsync((SqliteTransaction)Transaction, dbCommand).ConfigureAwait(false)); } }