Not getting values from linq query in aspnetzero framework

Question

I am executing following query. I am doing this in aspnetzero framework and doing this in UserAppService.cs file.

var rt = _dbContextProvider.GetDbContext().Users
                    .Where(e => e.Id == 11)
                    .FirstOrDefault();

But this is always returning null, in database there is record with Id = 11.

So anyone has any idea what is wrong in this.

Thanks

Chances are your application is using a connection string to a database you aren't expecting. Check the value of _dbContextProvider.GetDbContext().Database.Connection.ConnectionString to verify that it is connecting to the same database server/instance you are inspecting for records. Also check that your context hasn't added alternate tables based on the naming convention. (I.e. under default namespace or pluralized class name) — Steve Py
– Steve Py, Commented Dec 6, 2020 at 22:35
Try to add .IgnoreQueryFilters(), probably you have defined query filters. — Svyatoslav Danyliv
– Svyatoslav Danyliv, Commented Dec 6, 2020 at 23:08

Zhi Lv · Accepted Answer · 2020-12-11 08:46:32Z

1

As Svyatoslav Danyliv said in the comment, the issue is related to the query filters, try to add the .IgnoreQueryFilters() to ignore the query filters.

answered Dec 11, 2020 at 8:46

Zhi Lv

22.2k1 gold badge28 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Not getting values from linq query in aspnetzero framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related