How to select specific columns in Entity Framework in ASP.NET WebForms?

Question

I want to select specific columns like username, message and subject only from SQL Server Database in Entity Framework in ASP.NET. But my program returns all the columns from table emailtable.

Here is my code:

kicsEntities db = new kicsEntities();

protected void Page_Load(object sender, EventArgs e)
{
    emailtable et = new emailtable();

    string var = Session["username"].ToString();

    GridView1.DataSource = db.emailtables.Where(em => em.receiver == var).ToList(); 
    GridView1.DataBind();
}

You need to make a ViewModel class with properties you want, then continue your query with .Select(x=> new Vm(){...}).ToList() — Lucian Bumb
– Lucian Bumb, Commented Apr 16, 2016 at 8:39

Wendel Fabian Chinsamy · Accepted Answer · 2016-04-28 13:50:33Z

2

You can use projection. For example, create a view model (c# class) called MyClass and declare the properties you require from the database object.

public class MyClass
{
    public string Username { get; set; }
    public string Message { get; set; }
    public string Subject { get; set; }
}

Now using Linq you can request only the properties you require from the database table

db.TableName.Select(m => new MyClass 
{
    Username = m.Username,
    Message = m.Message,
    Subject = m.Subject
});

You can now bind the returned collection as your gridview's datasource with the added benefit of having a strongly typed control.

edited Apr 28, 2016 at 13:50

answered Apr 16, 2016 at 9:10

Wendel Fabian Chinsamy

464 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:33:23Z

0

You could add a view to your database model and have it included only those columns that you would want to retrieve. If your approach is code-first, you can add/map the view as described in this SO post.

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Apr 16, 2016 at 8:35

Wicher Visser

1,54312 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to select specific columns in Entity Framework in ASP.NET WebForms?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related