/// <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();
