views:

37

answers:

0

I have tables named Document, SomeOther1Document, SomeOther2Document. Document table contains columns common to the other tables. If I map these tables in the designer and have the other tables inheriting from Document entity, by default It would use Sql queries and Its all good. However, how would i use stored procedure for selecting say rows for SomeOther1Document table. The stored procedure uses INNER JOIN with Document table to get me the data. Am I missing anything here? Could somebody tell me a way to achieve this?