public void OpenForAdmin()
{
var connString = new DeveelDbConnectionStringBuilder {
UserName = AdminUserName,
Password = AdminPassword,
DataSource = "memory",
Database = DatabaseName,
Schema = "APP",
Create = true
};
var connection = new DeveelDbConnection(connString);
Assert.AreEqual(ConnectionState.Closed, connection.State);
Assert.DoesNotThrow(() => connection.Open());
Assert.AreEqual(ConnectionState.Open, connection.State);
Assert.DoesNotThrow(() => connection.Close());
Assert.AreEqual(ConnectionState.Closed, connection.State);
}
public void OpenForAdmin()
{
var connString = new DeveelDbConnectionStringBuilder {
UserName = AdminUserName,
Password = AdminPassword,
DataSource = "memory",
Database = DatabaseName,
Schema = "APP",
Create = true
};
var connection = new DeveelDbConnection(connString);
Assert.AreEqual(ConnectionState.Closed, connection.State);
Assert.DoesNotThrow(() => connection.Open());
Assert.AreEqual(ConnectionState.Open, connection.State);
Assert.DoesNotThrow(() => connection.Close());
Assert.AreEqual(ConnectionState.Closed, connection.State);
}
public void ExecuteMultipleStatements()
{
const string connString = "Host=Heap;UserID=SA;Password=123456;Database=testdb;BootOrCreate=true";
var connection = new DeveelDbConnection(connString);
Assert.DoesNotThrow(connection.Open);
Assert.IsTrue(connection.State == ConnectionState.Open);
DeveelDbCommand command = connection.CreateCommand();
command.CommandText = "DECLARE firstName STRING NOT NULL; SET firstName = 'antonello'; SELECT :firstName;";
var reader = command.ExecuteReader();
Assert.IsTrue(reader.NextResult());
Assert.IsTrue(reader.NextResult());
Assert.IsTrue(reader.Read());
Assert.IsFalse(reader.IsDBNull(0));
Assert.AreEqual("antonello", reader.GetString(0));
connection.Close();
}
