Hi,

I've been playing around with an MVC application connecting to a MySQL database.

I have a simple entity called 'Person' as below

[HierarchyRoot]
[KeyGenerator(KeyGeneratorKind.Default, Name = "PersonGenerator")]
public class Person: Entity
{
    [Field, Key]
    public long Id { get; private set; }

    [Field(Length = 100)]
    public string GivenName { get; set; }

    [Field(Length = 100)]
    public string  FamilyName { get; set; }

    [Field]
    public DateTime? DateOfBirth { get; set; }
}

I can create as many Person records as I want in my application without any problem, however, if I restart the database I can no longer create records in that table (nor in any other table that has already records).

The exception I get is Duplicate entry '1' for key 'PRIMARY'

I know that now my application is trying to create a record with a key that already exists in the table, obviously the database throws a Primary Key violation exception.

I know that Dataobjects.Net has a way of keeping track of the keys that have been fetched from the database, so it can always assign a unique primary key to a new record, but I don't think that it is working for me in this case.

Looks like that Dataobjects fetches keys starting from 1 again when I restart the database.

If Dataobjects fetches say 128 keys (1 to 128) for the first time, and I create two entities, which will be assigned keys 1 and 2, then I restart the database, the next entity should be assigned the key 3, but in my case it tries to assign 1 again.

Am I doing anything wrong?

regards,

Jamal