/// <inheritDoc /> public override string GetLastInsertId(PDO pdo, string name) { pdo.ClosePendingReader(); string last_insert_id_query; if (string.IsNullOrEmpty(name)) { last_insert_id_query = "SELECT @@IDENTITY"; } else { // TODO: "SELECT CURRENT_VALUE FROM SYS.SEQUENCES WHERE NAME=%s" throw new NotImplementedException(nameof(name)); } using (var com = pdo.CreateCommand(last_insert_id_query)) { var value = com.ExecuteScalar(); if (value == null) { // TODO: error return(null); } return(value.ToString()); } }
/// <summary> /// Closes pending data reader if any. /// </summary> public static void ClosePendingReader(this PDO pdo) => pdo.ClosePendingReader();