EF Core Select Columns without projection to anonymous object Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!Conditional select with EF CoreEF CORE Optimistic concurrency without timestampin ef core combine nullable columnsEF core 2.1 using take in projectionFiltering with EF Core 2.1 inheritanceError when inserting record to SQL Server database from ASP .Net Core 2.1 Web API using EF Core 2.1(In EFCore) How can I configure the underlying database column types, based on a general Type ruleEF core Join two table without primary key columnWhy is a GroupBy followed by a SelectMany to take the n latest records for that group not working without an extra select anonymous step?
Like totally amazing interchangeable sister outfit accessory swapping or whatever
Why do people think Winterfell crypts is the safest place for women, children & old people?
Weaponising the Grasp-at-a-Distance spell
Etymology of 見舞い
When speaking, how do you change your mind mid-sentence?
What is the difference between 准时 and 按时?
Why isn't everyone flabbergasted about Bran's "gift"?
Has a Nobel Peace laureate ever been accused of war crimes?
Why aren't these two solutions equivalent? Combinatorics problem
Why not use the yoke to control yaw, as well as pitch and roll?
Can a Wizard take the Magic Initiate feat and select spells from the Wizard list?
Can gravitational waves pass through a black hole?
What could prevent concentrated local exploration?
What is the evidence that custom checks in Northern Ireland are going to result in violence?
Can a Knight grant Knighthood to another?
Are bags of holding fireproof?
How to mute a string and play another at the same time
Should man-made satellites feature an intelligent inverted "cow catcher"?
A journey... into the MIND
Why did Israel vote against lifting the American embargo on Cuba?
When does Bran Stark remember Jamie pushing him?
Assertions In A Mock Callout Test
tabularx column has extra padding at right?
Does Prince Arnaud cause someone holding the Princess to lose?
EF Core Select Columns without projection to anonymous object
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!Conditional select with EF CoreEF CORE Optimistic concurrency without timestampin ef core combine nullable columnsEF core 2.1 using take in projectionFiltering with EF Core 2.1 inheritanceError when inserting record to SQL Server database from ASP .Net Core 2.1 Web API using EF Core 2.1(In EFCore) How can I configure the underlying database column types, based on a general Type ruleEF core Join two table without primary key columnWhy is a GroupBy followed by a SelectMany to take the n latest records for that group not working without an extra select anonymous step?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I have a query like the one below where I want to be specific about which columns I want to get without projecting to a new type.
dbcontext.
SomeEntity
.Include(_ => _.ChildEntityA)
.ThenInclude(_ => _.SubChildEntityA)
.Include(_ => _.ChildEntityB)
.ThenInclude(_ => _.SubChildEntityB)
.ThenInclude(_ => _.SubSubChildEntityB)
.Include(_ => _.ChildEntityC)
.Include(_ => _.ChildEntityD)
.FirstOrDefault(_ => _.Id == 123)
I am fine projecting when doing small requests but when it gets complex then it becomes heavy to create whole chain of objects via new when there may be only one or two sub entities that you want to filter out which columns you want.
ef-core-2.1
asked Mar 9 at 2:10
PascalPascal
112
add a comment |
I have a query like the one below where I want to be specific about which columns I want to get without projecting to a new type.
dbcontext.
SomeEntity
.Include(_ => _.ChildEntityA)
.ThenInclude(_ => _.SubChildEntityA)
.Include(_ => _.ChildEntityB)
.ThenInclude(_ => _.SubChildEntityB)
.ThenInclude(_ => _.SubSubChildEntityB)
.Include(_ => _.ChildEntityC)
.Include(_ => _.ChildEntityD)
.FirstOrDefault(_ => _.Id == 123)
I am fine projecting when doing small requests but when it gets complex then it becomes heavy to create whole chain of objects via new when there may be only one or two sub entities that you want to filter out which columns you want.
ef-core-2.1
asked Mar 9 at 2:10
PascalPascal
112
add a comment |
I have a query like the one below where I want to be specific about which columns I want to get without projecting to a new type.
dbcontext.
SomeEntity
.Include(_ => _.ChildEntityA)
.ThenInclude(_ => _.SubChildEntityA)
.Include(_ => _.ChildEntityB)
.ThenInclude(_ => _.SubChildEntityB)
.ThenInclude(_ => _.SubSubChildEntityB)
.Include(_ => _.ChildEntityC)
.Include(_ => _.ChildEntityD)
.FirstOrDefault(_ => _.Id == 123)
I am fine projecting when doing small requests but when it gets complex then it becomes heavy to create whole chain of objects via new when there may be only one or two sub entities that you want to filter out which columns you want.
ef-core-2.1
asked Mar 9 at 2:10
PascalPascal
112
I have a query like the one below where I want to be specific about which columns I want to get without projecting to a new type.
dbcontext.
SomeEntity
.Include(_ => _.ChildEntityA)
.ThenInclude(_ => _.SubChildEntityA)
.Include(_ => _.ChildEntityB)
.ThenInclude(_ => _.SubChildEntityB)
.ThenInclude(_ => _.SubSubChildEntityB)
.Include(_ => _.ChildEntityC)
.Include(_ => _.ChildEntityD)
.FirstOrDefault(_ => _.Id == 123)
I am fine projecting when doing small requests but when it gets complex then it becomes heavy to create whole chain of objects via new when there may be only one or two sub entities that you want to filter out which columns you want.
ef-core-2.1
ef-core-2.1
asked Mar 9 at 2:10
PascalPascal
112
asked Mar 9 at 2:10
PascalPascal
112
asked Mar 9 at 2:10
PascalPascal
112
asked Mar 9 at 2:10
PascalPascal
112
asked Mar 9 at 2:10
PascalPascal
112
112
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55073326%2fef-core-select-columns-without-projection-to-anonymous-object%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55073326%2fef-core-select-columns-without-projection-to-anonymous-object%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
