Entity Framework getting data from the ENTIRE column

Question

I've got an api call getUser which returns ALL the info from the database at the specified column, but I want to exclude some things; phonenumber, email etc.

Tried fiddling with the LINQ, changeing the modelBuilder, changeing the optionBuilder

Have looked for any SQL saying "Select * from" but found nothing

Deleting things in my UserModel do work, however this is an ugly way of doing it.

Result<UserModel> result = new Result<UserModel>();
try
    {
        using (var db = new ComeatDBContext(optionsBuilder.Options))
        {
            var user = db.User
                .Include(f => f.Nationality)
                .Include(f => f.State)
                .FirstOrDefault(e => e.Id == id && !e.IsDeleted);

            result.ResponseObject = (new UserModel()).FromUser(user);
            var house = db.House.FirstOrDefault(e => e.UserId == user.Id);
            if (house != null)
            {
                result.ResponseObject.House = ( new HouseModel() ).FromHouse(house);
            }
            result.Success = true;
        }

Expected specifying which data to include (or not include) but instead I get everything unless I set the values to "null" after they've been delievered by the DB.

DaggeJ · Accepted Answer · 2019-08-30T12:18:54.807

1

The .FirstOrDefault(...) is what causes the underlying database query (SQL) to be executed. It will populate all properties that are defined on the entity. The data entity is then transformed to your UserModel object when you execute (new UserModel()).FromUser(user);.

If you want to reuse your UserModel class but not populate all the columns you can do something like this;

var userModel = db.User
     .Select(x => new UserModel { Name = x.Name, Id = x.Id })
     .FirstOrDefault(e => e.Id == id && !e.IsDeleted);

result.ResponseObject = userModel;

edited Aug 30 '19 at 12:18

answered Aug 30 '19 at 11:36

DaggeJ

2,094
1
10
22

Or if you want to limit the response items to a max of one without executing the data, you may use `.Take(1)` – Chrᴉz remembers Monica Aug 30 '19 at 11:46
Unfortunatly that doesn't work " cannot convert from 'PLACEHOLDER.Business.Models.UserModel' to 'PLACEHOLDER.Data.Models.User' – Mikkel Rohde Glerup Aug 30 '19 at 12:10
@MikkelRohdeGlerup - I think you get the error on the row where you assign the result.ResponseObject. Added this line to my response to clarify that you do not need to do (new UserModel()).FromUser(user); anymore... – DaggeJ Aug 30 '19 at 12:20
@DaggeJ thank you so much! I've been battling this for 2 days now! – Mikkel Rohde Glerup Aug 30 '19 at 12:26

Entity Framework getting data from the ENTIRE column

1 Answers1