Entity Framework Add Fields to Dataset

Question

Is it possible select only specific fields to return. In these example all Tickets including Username. LazyLoading is disabled.

[Table("UserProfile")]
public class UserProfile
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int UserId { get; set; }
    public string Username { get; set; }
    public DateTime? LastOnline { get; set; }

    public Tickets Tickets { get; set; }
}

Code

var whereQuery= "x => true";
_uow.Users.DbSet.Include("Tickets").Where(whereQuery).OnlyTickets.IncludeUsername();
//or
var whereQuery= "x => true";
_uow.Tickets.DbSet.Include("UserProfile").Where(whereQuery).OnlyTickets.IncludeUsername();

mr100 · Accepted Answer · 2014-05-11 06:48:31Z

2

How about this:

_uow.Users.DbSet.Where(whereQuery).Select(u => new {Tickets = u.Tickets, Username = u.UserName});

You might add there Include(item => item.Tickets) to eager load Tickets prperty but this is not mandatory. If you do not want to use anonymous type you might use Tuple:

_uow.Users.DbSet.Where(whereQuery).Select(u => new Tuple<List<Ticket>,string>(u.Tickets, u.UserName));

edited May 11, 2014 at 6:48

answered May 11, 2014 at 6:25

mr100

4,4382 gold badges29 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework Add Fields to Dataset

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