DbContext , Entity Framework 6, query for entity added in current session

Asked Oct 15 '20 at 14:38

Active Oct 15 '20 at 15:02

Viewed 67 times

I'm using Entity Framework 6, I have Star entity and I'm dealing with following simple code:

                      foreach(var name in names)
                      {
                        Star star = context.Stars
                            .Where(st => st.Name == name)
                            .FirstOrDefault();

                        if (star == null)
                        {
                            star = new Star();
                            star.Name = name;
                            context.Stars.Add(star);

                            star = context.Stars
                                .Where(st => st.Name == name)
                                .FirstOrDefault();

                            // Now it's NULL
                        }
                        }

I want to add to DB new Star only if it doesn't exists yet. Unfortunatelly, subsequent queries on the same session context without SaveChanges(), cant's find entities added in current session. How can I solve it? (I don't want to save it in each step).

edited Oct 15 '20 at 14:59

asked Oct 15 '20 at 14:38

Shark

I meant context.SaveChanges(), not SaveAll() – Shark Oct 15 '20 at 14:42
You can edit your Post and replace SaveAll to SaveChanges. – Yaroslav Bres Oct 15 '20 at 14:43
What is your goal? You want to get exactly item from state or you just want to make a batch add? – Yaroslav Bres Oct 15 '20 at 14:45
1

See what `context.Stars.Local.FirstOrDefault(s=>s.Name == name)` returns. – Tanveer Badar Oct 15 '20 at 15:03
context.Stars.Local.FirstOrDefault() works for me, so should I check both collections? – Shark Oct 15 '20 at 15:32
Does this answer your question? [Entity Framework: Re-finding objects recently added to context](https://stackoverflow.com/questions/699648/entity-framework-re-finding-objects-recently-added-to-context) – Progman Oct 15 '20 at 17:13

DbContext , Entity Framework 6, query for entity added in current session

0 Answers0