new dbcontext returns all data in database?

c# dbcontext entity-framework-6 linq-to-entities performance

Question

I'm New to EF and .Net, and nothing I've read or searched-for has prepared me for what I'm seeing - any help is appreciated!

Question1: Why is my DbContext full of data simply upon instantiation!?

(A#1: It's not. It's just the debugger trying to help by loading data automagically.)

Original Question2: How do I get it to instantiate as an empty "repo/container" object for loading data via my explicit queries?

Better Question2: What do I pay attention to while debugging?

(A#2: Ignore the DbContext object and look at the DbSet & Query objects.)

Reason for asking:

  • While Debugging, every row, from every table, is populated in Locals/ResultsView of dbcontext.
  • At least the data it's returning is correct, but this would be a real performance killer :0

Think I've ruled out:

  • LazyLoading is set to false
  • No Linq queries have intentionally been run
  • Caching issues
    • Deleting data directly in db returns empty Locals/ResultsView. (so as long as my db has no data I'm fine :p)
  • Migration/db mismatch
  • Type Mismatches

Haven't looked at:

  • Sql profiler
  • Any deep internals, IL

Have several projects in the .sln (VS2015 community) playing with CQRS pattern (EF6, MVC5, SimpleInjector)

  • .Web (MVC5, DI, deployment startup)
  • .Domain (POCO classes)
  • .Data.Read (ReadDbContext, ReadDAO, EF Migrations, designtime-startup)
    • Using instance of LocalDB
  • .Data.Write (WriteDbContext, WriteDAO)

In Data.Read project, while set to startup, the Main class has the following "Play-Code" with a breakpoint as:

using ( MyDbContext dbcontext = new MyDbContext() )
    {
    //BREAKPOINT:  Why is dbcontext full of data simply upon instantiation!?
    //(while Debugging, Every row, from every table, is populated in Locals/ResultsView of dbcontext)
    //No explicit Linq queries have been run
1
1
1/19/2017 8:35:50 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Why is my DbContext full of data simply upon instantiation!?

DbContext does not load the data. Your debugger does. The debugger allows you to view the data, and when you view it the DbContext will query the database. But it won't do it otherwise. This can easily be tested with SQL Server Profiler. Run it up and you will see that your DbContext doesn't query your database until you use your debugger to view it.

How do I get it to instantiate as an empty "repo/container" object for loading data via my explicit queries?

The most simple way would be to just get the table.

Say that your DbContext looks like this:

public class MyDbContext : DbContext
{
    public DbSet<Customer> Customers {get; set;}
}

Then you can get your container like so:

using(var context = new MyDbContext())
{
    // Get the table. This can serve as your repository.
    DbSet<Customer> table = context.Customers;

    // If you're using generics you can do like this as well.
    DbSet<Customer> otherTable = context.Set<Customer>();

    // Specify your explicit query.
    IQueryable<Customer> query = table.Where(x => x.Name == 'Jenny');

    // Note that EF still haven't executed a query.
    // By calling methods like ToList() or FirstOrDefault() it will run the query.
    IList<Customer> result = query.ToList();
}
1
1/19/2017 6:42:46 AM

Related Questions

Using sample data to seed an Entity Framework database does not generate a database.

I see you're adding your objects to your entity, but are you calling context.SaveChanges() to commit then to the db?...found a link that may help: ...EF4 Code First CTP5: Seed method no longer works
asp.net-mvc-3 entity-framework
asked by Eric Walter

Entity Framework: adding existing child POCO to new Parent POCO, creates new child in DB

I believe there are few ways of accomplishing this. You can specify that course entity is unchanged rather than added, along these lines:...ctx.Entry(course).State = EntityState.Unchanged; ...Or instruct your context, that you are working with existing entity:...ctx.Courses.Attach(course); ...More info here: ...http://msdn.microsoft.com/en-us/data/...
.net c# entity-framework
asked by Sebastian K

Created a new view in MVC 5, opening the new view results in HTTP 404

You should be accessing the view through an ...action... method. So If you created your new view in ...~/Views/Home/AboutMe.cshtml..., You should add an action method like this in your ...HomeController.......public class HomeController : Controller { public ActionResult AboutMe() { return View(); } } ...Now you can access this like ....
asp.net-mvc asp.net-mvc-5 asp.net-mvc-views entity-framework
asked by Shyju

Entity Framework 6 query returning record with data not yet saved in the database

The ...DbContext... is a ...unit of work... and it is a feature that it returns the same object as you already have loaded. The ...DbContext... caches all objects loaded and provides one consistent view of the data which you can update and later save in one call to ...SaveChanges().......If you want to do separate queries from the database that don...
c# ef-code-first entity-framework-6
asked by Anders Abel

Prevent EF from adding new child objects instead of just association when inserting new parent object?

When disconnected entities are reattached they are in Added state by default....You can change the state after attaching the exercise....public int CreateExercise(Exercise newExercise) { db.Exercises.Add(newExercise); // set all attached users to unchanged. db.ChangeTracker.Entries<User>().ToList().ForEach(p => p.State = EntityState.U...
asp.net-mvc c# entity-framework entity-framework-6
asked by codeworx

MVC var userStore = new UserStore<ApplicationUser>(db); returning null

Finally found the solution for me in another thread. I disabled this option:...Project Properties> Build> Optimize code ...It fixed both the original problem and also the problem in the very end with breakpoints
asp.net-identity asp.net-mvc c# entity-framework-6 usermanager
asked by Mikael Puusaari

Autofac - Retrieving new instance of UnitOfWork - "DBcontext has been disposed error"

To ensure I get a fresh instance of my UnitOfWork after each batch of operations, I retrieve a reference to my current Autofac lifetime scope and ask Autofac to give me a new lifetime scope inside a using statement, then I use Autofac to register and resolve those dependencies. Some of my services also depend on the UnitOfWork so it was important t...
autofac c# entity-framework entity-framework-6
asked by Ciaran Gallagher

System.Data.SQLite.SQLiteException: unable to open database file (An exception occurred while initializing the database)

This looks like a permission issue... System.Data.SQLite.SQLiteException: unable to open database file ...The database-file is set to ...c:\mydb.sqlite... in app.config connectionString... <connectionStrings> <add name="ConnectionString" connectionString="Data Source=c:\mydb.sqlite" providerName="System.Data.SQLite"/> </connectionSt...
entity-framework-6 sqlite
asked by dahumm

Error inserting data from many method return lists to a database in c#

I was able to resolve my question, what I did is to assign all lists in a loop and then assign them to each column in the database....But I am still searching for a better and more clean way to this solution...private async void btn_SubmitData_Click(object sender, EventArgs e) { // parse list methods - represents each field of the datab...
arraylist c#-4.0 entity-framework-6 winforms
asked by NewCoder

Priority in retrieving Data from mysql database and filtering the retrieved data

Since you're using a ....ToList()... EF will ...Retrieve all customers from database...Map them to customer objects...Later, when you compute ...GetOneColumn..., you do a projection on them (iterating through already materialized object list)...To retrieve only one column, ...Remove the ....ToList()... from the repository, and return a ...IQueryabl...
c# entity-framework-6
asked by ironstone13

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow