public void GFSqlConnector_Method_CheckTearDown() { Core.GFSqlConnector TestSQLConnector = new Core.GFSqlConnector("testappAPIKEY", "testuserAPIKEY", this._SQLServer, this._DBName, true); //Generate some test data TestSQLConnector.GenerateTestData(); //Tear the data down TestSQLConnector.TearDownData(); //Check the test data has been removed from the database TestSQLConnector.Open(); //Open Connection SqlCommand Cmd = TestSQLConnector.SQLCommand("SELECT [row_count] = COUNT(*) FROM [simsig].[TSIM] WHERE [testdata_id] = @testdata_id", CommandType.Text); //Generate SqlCommand Cmd.Parameters.Add(new SqlParameter("@testdata_id", TestSQLConnector.TestDataID)); SqlDataReader DataReader = Cmd.ExecuteReader(); int SimulationRowCount = -1; //Variable to store the simulation row count while (DataReader.Read()) { SimulationRowCount = DataReader.GetInt32(0); } TestSQLConnector.Close(); //Close Connection Assert.Equal(0, SimulationRowCount); }
public void GFSqlConnector_Connection_CheckSessionContext() { Core.GFSqlConnector TestSQLConnector = new Core.GFSqlConnector("testappAPIKEY", "testuserAPIKEY", this._SQLServer, this._DBName); TestSQLConnector.Open(); //Open Connection SqlCommand cmd = TestSQLConnector.SQLCommand("SELECT test = CONVERT(INT,SESSION_CONTEXT(N'application'));", CommandType.Text); //Generate SqlCommand SqlDataReader reader = cmd.ExecuteReader(); //Execute int ApplicationID = 0; //Variable to store AppID from GF Microsoft SQL if (reader.HasRows) { while (reader.Read()) { ApplicationID = reader.GetInt32(0); } } reader.Close(); TestSQLConnector.Close(); //Close Connection Assert.Equal(2, ApplicationID); }