. The Monster Hunter series is one of the most popular JRPG series, and. Saints Row IV is a post-apocalyptic violent crime thriller, an action-packed video game.
It's really that simple. Details are here, Get the full experience and grow the fastest.Q:
Entity Framework Eager Loading with where clause
I have a.net 4.5 entity model and the following query:
SELECT
[Projects].[Id] AS [Id],
[Projects].[Name] AS [Name],
[Projects].[StatusId] AS [StatusId],
[Projects].[Deleted] AS [Deleted]
FROM [Projects]
WHERE
[Projects].[StatusId] = @p__linq__0
AND ([Projects].[Deleted] = 0)
ORDER BY
[Projects].[Name] ASC
The issue I have is that if StatusId is not null then the StatusId property is also being returned but I do not want it.
What I want is something like this:
SELECT
[Projects].[Id] AS [Id],
[Projects].[Name] AS [Name],
[Projects].[StatusId] AS [StatusId],
[Projects].[Deleted] AS [Deleted]
FROM [Projects]
WHERE
[Projects].[StatusId] = @p__linq__0
AND ([Projects].[Deleted] = 0)
How can I achieve this?
A:
You can try:
SELECT
[Projects].[Id] AS [Id],
[Projects].[Name] AS [Name],
[Projects].[StatusId] AS [StatusId],
[Projects].[Deleted] AS [Deleted]
FROM [Projects]
WHERE
[Projects].[StatusId] = @p__linq__0
AND ([Projects].[Deleted] = 0)
ORDER BY
[Projects be359ba680
Related links:
Comments