locked
SQLite prepared statements RRS feed

  • Question

  • Is it possible to used PreparedStatements with SQLite in C# for Windows Store Apps?

    If so, how can this be done?

    Is it true that PreparedStatements offer increased performance over not using them?

    Thursday, March 20, 2014 10:56 PM

Answers

  • If you are using SQLite-net then I believe that if you use it with LINQ it will automatically map many statements into prepare, or you can call SQLite the SQLite_prepare_v2 function directly as Prepare2.

    For more details check the SQLite-net documentation.

    If you're not using SQLite-net but are writing your own wrapper then you can call SQLite_prepare_v2 directly.

    --Rob

    Friday, March 21, 2014 12:06 AM
    Moderator