SQLiteException - SQLite error Insufficient parameters supplied to the command

Question

When querying data from SQLite, it says:

SQLite error Insufficient parameters supplied to the command

I think there is either a bug, or the error message is misleading. Because I only have one parameter and I am providing it, so I cannot understand where is the problem.

Here is my code:

public List<T> Read(string sql, List<SQLiteParameter> addParametera = null, params string[] properties)
{
    var data = new DataTable();

    var command = new SQLiteCommand(Connection);
    command.CommandText = sql;
    addParametera?.ForEach(p => command.Parameters.Add(p));
    var reader = command.ExecuteReader(); // <- ERROR
    if (reader.HasRows)
    {
        data.Load(reader);
    }
    reader.Close();

    var maps = Maps.ByProperties(properties).ToList();
    var results = data.Rows.Cast<DataRow>().Select(r => New(r, maps)).ToList();
    return results;
}

an here the command object:

The parameter name of the parameter object is NULL, I'm guessing that's the problem. — Rik
– Rik, Commented Nov 4, 2015 at 14:08
You're welcome. I added it as an answer below, please accept it, so this question can be wrapped up. — Rik
– Rik, Commented Nov 4, 2015 at 15:36
The mistake was, I used a wrong constructor [new SQLiteParameter(type, parameterName) { Value = parameterValue}] instead of new SQLiteParameter(type, parameterValue) {ParameterName = parameterName} in an other part of code. — Georg
– Georg, Commented Nov 5, 2015 at 8:44

Rik · Accepted Answer · 2015-11-04 15:34:40Z

1

The parameter name of the parameter object is NULL, I'm guessing that's the problem

answered Nov 4, 2015 at 15:34

Rik

29.3k14 gold badges52 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLiteException - SQLite error Insufficient parameters supplied to the command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related