views:

36

answers:

0

Hello,

I am using http://loungerepo.codeplex.com/

this library needs a unique id when I persist my entities to the repository.

I decided for integer not Guid.

The question is now where do I retrieve a new integer and how do I do it?

This is my current approach in the SchoolclassAdministrationViewModel.cs:

public SchoolclassAdministrationViewModel()
    {
        _schoolclassRepo = new SchoolclassRepository();
        _pupilRepo = new PupilRepository();
        _subjectRepo = new SubjectRepository();

        _currentSchoolclass = new SchoolclassModel();
        _currentPupil = new PupilModel();
        _currentSubject = new SubjectModel();

...
}

private void AddSchoolclass()
    {
        // get the last free id for a schoolclass entity
        _currentSchoolclass.SchoolclassID = _schoolclassRepo.LastID; 

        // add the new schoolclass entity to the repository
        _schoolclassRepo.Add(SchoolclassModel.SchoolclassModelToSchoolclass(_currentSchoolclass));

        // add the new schoolclass entity to the ObservableCollection bound to the View
        Schoolclasses.Add(_currentSchoolclass);

        // Create a new schoolclass entity and the bound UI controls content gets cleaned
        CurrentSchoolclass = new SchoolclassModel();
    }


public class SchoolclassRepository : IRepository<Schoolclass>
{
    private int _lastID;

    public SchoolclassRepository()
    {
        _lastID = FetchLastId();
    }

    public void Add(Schoolclass entity)
    {
        //repo.Store(entity);            
    }                     

    private int FetchLastId()
    {
        return // repo.GetIDOfLastEntryAndDoInc++
    }       

    public int LastID
    {
        get { return _lastID; }
    }
}

Explanation: Every time the user switches to the SchoolclassAdministrationViewModel which is datatemplated with a UserControl the saVM Ctor is called and the schoolclass repository is created wherein the FetchLastId() is called and I am up to date with the last ID doing a inc++ on it to get the free one...

Do you have any better ideas?

What I do not like about my current apporach:

-Having a private method in repositry class because a repositry is to fetch data only not "entity logic" like the counter - Having to access from the ViewModel a public property - located in the repository -, actually its not the ViewModel concern to get a entity id and assign it. Actually the ViewModel should ask for a schoolclass POCO and get a SchoolclassModel to bind to the UI. But then I have again to re-read the Schoolclass properties into the SchoolclassModel properties what I want to avoid.