views:

39

answers:

0

Hi,

I have a Article and Blog tables that I want to represent as a Content Entity. I have mapped both tables to the Content entity however when I query using a ObjectSet.Take(20) only the article table is being hit in the dbase. Am i wrong in thinking (hoping) the query should look where contentType = 1 and 2?

Ta

SQL query looks like this...

SELECT 
[Extent1].[RhythmyxContentId] AS [RhythmyxContentId], 
[Extent1].[PublishDate] AS [PublishDate], 
[Extent1].[Title] AS [Title], 
[Extent1].[Promo] AS [Promo], 
[Extent1].[AuthorUid] AS [AuthorUid], 
[Extent1].[Body] AS [Body], 
[Extent1].[IsDeleted] AS [IsDeleted], 
[Extent1].[IsLive] AS [IsLive], 
[Extent1].[UpdateDate] AS [UpdateDate], 
[Extent1].[CreatedDate] AS [CreatedDate], 
[Extent1].[Slug] AS [Slug], 
[Extent1].[ContentCategoryId] AS [ContentCategoryId]
FROM [dbo].[tArticle] AS [Extent1]
WHERE [Extent1].[ContentType] =  CAST( '1' AS int)

Heres the entity... alt text