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...