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(); }