public void NewValidConnectionWorks() { var conn = new WebSqlConnection(@"localhost\sqlexpress", "junk", "", "", 5); var connResult = conn.connect(); Assert.AreEqual("", connResult.message, "expect empty message on successful connect"); Assert.AreEqual("Open", connResult.state, "expect open connection"); Assert.AreNotEqual(ZeroGuid, connResult.connectionGuid.ToString(), "expect non-zero GUID"); }
public void NewInvalidConnectionReportsCorrectStatus() { var conn = new WebSqlConnection(@"localhost\sqlexpress_DOES_NOT_EXIST", "junk", "", "", 3); var connResult = conn.connect(); Assert.IsTrue(connResult.message.IndexOf("error") >= 0, "expect error message on failed connect"); Assert.AreEqual("Closed", connResult.state, "expect closed connection"); Assert.AreEqual(ZeroGuid, connResult.connectionGuid.ToString(), "expect zero GUID"); }
public void NewConnectionHasPropertiesSetAsExpected() { var conn = new WebSqlConnection(@"localhost\sqlexpress","junk","","",5); Assert.AreEqual(36, conn.guid.ToString().Length, "expect appropriate GUID length."); Assert.AreEqual(ZeroGuid, conn.guid.ToString(),"expect zero GUID."); Assert.AreEqual(@"localhost\sqlexpress", conn.connection.DataSource, "expect correct server name"); Assert.AreEqual("junk", conn.connection.Database, "expect correct database name"); }
public WebSqlConnectResult Connect(WebSqlConnectRequest input) { var conn = new WebSqlConnection(input.serverName, input.databaseName, input.userId, input.password, 10); var connections = getConnections(); var result = conn.connect(); connections.Add(conn.guid, conn); return result; }
public WebSqlCommandResultSet(WebSqlConnection conn) { this.connectionGuid = conn.guid.ToString(); this.state = conn.state; this.results = new List<WebSqlCommandResult>(); }