Visual Studio DB access

[Ski6]

As the regexp script does not seem forthcoming, I wanted to see if I could do db updates in VS using SQL calls.

I stumbled past the collation thing for WHERE statements in SELECTs using COLLATE NOCASE for strings, but have had no luck doing UPDATES:
using (SQLiteConnection connection = new SQLiteConnection(constr))
{
string updateQuery = @"UPDATE main.Songs SET SongTitle = @SongTitle WHERE ID = @ID";
var result = connection.Execute(updateQuery, new
{
ID = 320923,
SongTitle = "A different song title"
});
}

This yields a collate error and I can't guess what it wants.
Does anyone know a way to do an SQL UPDATE to the Songs DB? Entity framework? Dapper?

[TIV73]

There have been a couple of threads where people reported having issues writing to the database (see here and here), so external tool access might not be a thing atm.

[Peke]

Simply Use Sample Script "SQLeditor" eg. copy from Sample scripts to Scripts.

You can also use that Script to cannibalize what you need for your APP.

Only difference is taht you do not open SQLite Connection but rather thru https://www.mediamonkey.com/webhelp/MM5 ... es/DB.html

[Ski6]

Thanks Peke! That is very helpful.

[Peke]

Hi,
My pleasure. I am curious what you will think of as I had no time to play around much with MM5 API lately.