Click here to Skip to main content
15,896,269 members

Comments by job mwa (Top 12 by date)

job mwa 4-Dec-14 9:17am View    
WOrked very well thanx alot ill have to read up some more on WHERE IN.
job mwa 3-Dec-14 13:51pm View    
both and table person contains 200 rows.
job mwa 3-Dec-14 13:03pm View    
Deleted
both and table person contains 200 rows.
job mwa 3-Dec-14 12:42pm View    
what do you mean by "issue a single delete using a "WHERE Id IN (list of Ids)" clause"?? i think there maybe a solution here.
job mwa 3-Dec-14 12:15pm View    
Deleted
string delete = "DELETE FROM Person WHERE Id = @MyId";
using (var command = new SQLiteCommand(delete,conn))
{
using (var trans = conn.BeginTransaction())
{
command.Parameters.AddWithValue("@MyId", Id);
command.ExecuteScalar();
trans.Commit();
}
}