I used the following code in v. 0.9
public static IDataReader ExecuteReader(string connectionString, string commandText, params object parameters)
SQLiteConnection conn = new SQLiteConnection();
conn.ConnectionString = connectionString;
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = commandText;
for (int i = 0; i < parameters.Length; i++)
cmd.Parameters[i].Value = parameters[i];
This code however does not work in 0.12, I get an exception when assigning the parameter in the for loop.
The sql statement sent to the function uses unnamed parameters (e.g. "select * from table where id = ?") and the parameters that are supposed to be inserted are sent in the params array.
See the release notes for 0.12, your issue is addressed in the very first item...
ahh, ok - I didnt read the release notes.
Log in to post a comment.