Named parameters in SQLite

Question

How to use named parameters in SQLite.

Gohil Jayendrasinh · Answer

Hi SQLite provider does not support named parameters you must provide ? and then ensure the ordering number of parameters . command.CommandText = INSERT INTO discData(rootfolderID time volumeName discLabel  + userTitle userDesc) + VALUES(? ? ? ? ? ?); + SELECT last_insert_rowid() AS RecordID;; command.Parameters.Add(@rootfolderID DbType.Int64).Value = d.rootfolderID; command.Parameters.Add(@time DbType.Int64).Value = d.time; command.Parameters.Add(@volumeName DbType.String).Value = d.volumeName; command.Parameters.Add(@discLabel DbType.String).Value = d.discLabel; command.Parameters.Add(@userTitle DbType.String).Value = d.userTitle; command.Parameters.Add(@userDesc DbType.String).Value = d.userDesc; d.discID = (long)command.ExecuteScalar();