public void ExecuteCountQueryWithParametersTest() { var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0); var parameters = new List <SQLiteParameter>(); var aParameter = SqliteExtensions.Create("a", DbType.String, "string1"); var bParameter = SqliteExtensions.Create("b", DbType.Int32, 32); parameters.Add(aParameter); parameters.Add(bParameter); DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a, b);"); Assert.AreEqual(DatabaseWrapper.ExecuteCountQueryWithParameters($"SELECT COUNT(a) FROM {tableName} WHERE a = 'nothing';", parameters), 0); DatabaseWrapper.ExecuteSqlWithParameters($"INSERT INTO {tableName}(a, b) VALUES ({aParameter.ParameterName}, {bParameter.ParameterName});", parameters); Assert.AreEqual(DatabaseWrapper.ExecuteCountQueryWithParameters($"SELECT COUNT(a) FROM {tableName} WHERE a = {aParameter.ParameterName};", parameters), 1); aParameter = SqliteExtensions.Create("a", DbType.String, "string2"); bParameter = SqliteExtensions.Create("b", DbType.Int32, 64); DatabaseWrapper.ExecuteSqlWithParameters($"INSERT INTO {tableName}(a, b) VALUES ({aParameter.ParameterName}, {bParameter.ParameterName});", parameters); Assert.AreEqual(DatabaseWrapper.ExecuteCountQueryWithParameters($"SELECT COUNT(b) FROM {tableName} WHERE b > 20;", parameters), 2); DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};"); }