new bee changing the type of a entity

miroconnect · **Joined:** Wed May 14, 2008 2:06 pm **Posts:** 21

I have table called organization this has a column which determines type of organization
so we created abstract organization and different implementations based on type .
now suppose i want to change the type what's the best way to handle this , right now
Organization
TypeA
TypeB

I call findbyId method on organizationService this returns instance of TypeA
now I want to promote TypeA to TypeB

what option I have ?

Help is greatly appreicated

Celdric · **Joined:** Wed May 14, 2008 4:14 pm **Posts:** 5

What do you mean by promote?

A detailed example of what your system is doing right now and what you want it to do will help us help you.

Cameron McKenzie · **Posted:** Wed May 14, 2008 5:05 pm

Create a new record representing the new type, and delete the old record.

miroconnect · **Joined:** Wed May 14, 2008 2:06 pm **Posts:** 21

Cameron McKenzie wrote:

Create a new record representing the new type, and delete the old record.

If i have to delete the old record i have to update references to all the tables referring to this instance , not all tables are mapped to entities we are still migrating , and in my case i have to modify several tables and also i have to audit any changes to some tables what is the best way to handle this ?

miroconnect · **Joined:** Wed May 14, 2008 2:06 pm **Posts:** 21

Celdric wrote:

What do you mean by promote?

A detailed example of what your system is doing right now and what you want it to do will help us help you.

update TypeA to TypeB