C# (CSharp) ISqlStatementExecutor.ExecuteScalar Examples

Example #1

File: SqlServerSequenceHiLoValueGenerator.cs Project: timrog1/EntityFramework

 protected override long GetNewLowValue()
 => (long)Convert.ChangeType(
     _executor.ExecuteScalar(
         _connection,
         _sqlGenerator.GenerateNextSequenceValueOperation(_sequence.Name, _sequence.Schema)),
     typeof(long),
     CultureInfo.InvariantCulture);

Example #2

File: SqliteDataStoreCreator.cs Project: aliaminahmad/EntityFramework

        public override bool HasTables()
        {
            var count = (long)_executor.ExecuteScalar(
                _connection,
                null,
                "SELECT COUNT(*) FROM \"sqlite_master\" WHERE \"type\" = 'table' AND \"rootpage\" IS NOT NULL;");

            return(count != 0);
        }

Example #3

        protected override long GetNewLowValue()
        {
            var nextValue = _executor.ExecuteScalar(
                _connection,
                _connection.DbTransaction,
                _sqlGenerator.GenerateNextSequenceValueOperation(_sequenceName));

            return((long)Convert.ChangeType(nextValue, typeof(long), CultureInfo.InvariantCulture));
        }

Example #4

 public override bool HasTables()
 => (int)_statementExecutor.ExecuteScalar(_connection, _connection.DbTransaction, CreateHasTablesCommand()) != 0;

Example #5

 public virtual bool Exists()
 => _databaseCreator.Exists() && InterpretExistsResult(_executor.ExecuteScalar(_connection, ExistsSql));

Example #6

 public virtual bool Exists()
 => _databaseCreator.Exists() && Exists(_executor.ExecuteScalar(_connection, null, ExistsSql));