I've been developing a front end in C# using MyOLEDB,
but I kept running into annoying problems, for example
last_insert_id() would never work for whatever reason.
So I decided to give MySQLDriverCS a try. Everythings
going great and everything seems to be working with
minimal alterations (ExectureScalarQuery() isnt
implemented?) except I can't seem to get multi table
deletions to work, heres a sample:
string sSQL = "delete from table1, table2, using table1
as t1, table2 as t2 where t1.id = t2.id and t1.id = 1";
MySQLCommand Command = new MySQLCommand
ExecuteNonQuery returns 0 and no tables have been
removed when they should be...