Advertisement
Guest User

Untitled

a guest
Mar 30th, 2015
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. public int Update(string tableName, List<string> columnsNames, SqlManagerSelectOptions selectOptions)
  2. {
  3. if (selectOptions.DbTransaction == null)
  4. {
  5. return Update(tableName, columnsNames, selectOptions.Parameters, selectOptions.Where);
  6. }
  7. else
  8. {
  9. using (FbCommand myCommand = _connection.CreateCommand())
  10. {
  11. myCommand.Transaction = (FbTransaction)selectOptions.DbTransaction;
  12. {
  13. using (FbDataReaderHE myReader = (FbDataReaderHE)Query(SqlBuilder.BuildUpdateQuery(tableName, columnsNames, selectOptions.Where), selectOptions.Parameters, myCommand))
  14. {
  15. int rowsAffected = myReader.RecordsAffected;
  16. myReader.Close();
  17. return rowsAffected;
  18. }
  19. }
  20. }
  21. }
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement