/// <summary>
/// Gets the SQL statement to generate the next unoccupied ID value for tables without auto-increment.
/// </summary>
/// <param name="map">The <see cref="DbTableMap"/> providing the relevant information.</param>
/// <returns>The appropriate SQL statement.</returns>
internal static string GetNextIdValueSql(DbTableMap map)
{
string idColumn = map.GetIdColumnName();
return string.Format("select max({0}} + 1 from {1}", idColumn, map.Table);
}
