Combining multi coloumn failover logic into a single property in Entity Framework 4.1
i am working on a legacy enterprise database that uses multiple columns to retrieve a part number the sql we currently use checks for a part number and if the part number is null then checks for the child part number what would be the best way of combining this logic into a single ef model property (eg  Product.PartNumber )  

I would like this to be invisible as possible  so that only PartNumber is visible externally to the data api 



Combining multi coloumn failover logic into a single property in Entity Framework 4.1
===

i am working on a legacy enterprise database that uses multiple columns to retrieve a part number the sql we currently use checks for a part number and if the part number is null then checks for the child part number what would be the best way of combining this logic into a single ef model property (eg  Product.PartNumber )  

I would like this to be invisible as possible  so that only PartNumber is visible externally to the data api 


