AutoGenerate Identity Negative PK in EF4

Question

I am using EF 4.4.0.0 and following custom methods for generating identity negative PK:

    private int? GetMinId()
    {
        return Context.ENTITY.Min(c => (int?)c.Id);
    }

    public int GenerateNegativeId()
    {
        var minId = GetMinId() ?? default(int);

        if (0 < minId) return minId * -1;
        if (0 > minId) return --minId;

        return -1;
    }

Could you explain how to AutoGenerate Identity Negative PK ids. (Is it possible?)

Thank you

Answer 1

This is not possible, because identity generation happens on the database side. Why do you need this, why can't you just order your rows?