CODEWITHSUNDEEP
sqliteormlite-servicestack
Jeff
Jeff

Reputation: 2071

ServiceStack Ormlite issuing Sqlite specific command

I am running Ormlite against a sqlite database. Love it.
I am adding and deleting lots of records and find that the database does well with an occasional Vacuum command. How can I issue this around the ormlite api?

TIA

Upvotes: 1

Views: 90

Answers (1)

mythz
mythz

Reputation: 143284

You can use the db.ExecuteSql() API to execute Custom SQL, e.g:

Db.ExecuteSql("INSERT INTO page_stats (ref_id, fav_count) VALUES (@refId, @favCount)",
    new { refId, favCount })

Upvotes: 1

Related Questions