I have some code that I am refactoring but need to keep as much the same as possible.
DBManager dbMgr = new DBManager();
The above line give me direct access to the tables. So:
dbMgr.TableName <<< will give me access to methods like "Select," "Remove," and "RemoveRange" for example.
".Remove" works fine if I ONLY have one record to remove.
My question is how do I remove a resultset that has multiple rows (say 5) without having to loop through and make 5 calls to the database (very inefficient).
How can I, using the DBManager above, send a SQL command that says "DELETE FROM TableName WHERE name = 'Fred'"