public void ExecuteScalor() { IParameterFactory parameterFactory = new SqliteParameterFactory(); IConnectionFactory connectionFactory = new SqliteConnectionFactory(); ISqlStatementBuilder sqlBuilder = new SqliteStatementBuilder(parameterFactory); using (var connection = connectionFactory.Open(_connectionString)) using (var command = new Command(connection, parameterFactory)) { var sql = sqlBuilder.GetExistsStatement <Test>(); var exists = command.ExecuteScalar <bool>(sql); Assert.IsTrue(exists); sql = sqlBuilder.GetExistsStatement <DoesNotExist>(); exists = command.ExecuteScalar <bool>(sql); Assert.IsFalse(exists); } }
public SqliteOrmDataComponentFactory(RetryOptions retryOptions) : base(retryOptions) { SchemaParameterNames = new SqliteSchemaParameterNames(); ScriptBuilder = new SqliteScriptBuilder(); SqlStatementBuilder = new SqliteStatementBuilder(this); }
public SqliteOrmDataComponentFactory(string connectionString) : base(connectionString) { SchemaParameterNames = new SqliteSchemaParameterNames(); ScriptBuilder = new SqliteScriptBuilder(); SqlStatementBuilder = new SqliteStatementBuilder(this); }
public SqliteOrmDataComponentFactory(SqliteTransientRetryPolicy retryPolicy, string connectionString) : base(retryPolicy, connectionString) { SchemaParameterNames = new SqliteSchemaParameterNames(); ScriptBuilder = new SqliteScriptBuilder(); SqlStatementBuilder = new SqliteStatementBuilder(this); }