How Can i get primary key value when insert data to table?

[Anand]

Hi,

I have a table named as House in my database.which has 3 columns as HouseId(Primarykey),HouseDate,HouseType.

In my view model I have insert method as follows

 _stx = new CPMDomainContext();            House.HouseDate = HouseDate;            House.HouseType = HouseType;            _stx.Houses.Add(House);            _stx.SubmitChanges();

Data added to table successfully.Now how can i get HouseId of newly added data.

Help me ..