C# Controller method entity model

Question

I have a controller method that uses an edmx model in my asp.net mvc project that is used to get data from a View in a SQL database. Currently, I'm only interested in two columns from that table. I'm able to acquire the data using my entities class and a simple Linq statement to store the returned data to a list. What I'd like to do is iterate through the list, and check where those two columns are both populated with data (the value can be either null or populated with data) and return the row that gives me a true. Below is the code snippet of my method:

public ActionResult GetCurrentState()
{

    // create the entity object
    ALCS4Entities entities = new ALCS4Entities();

    // Get the InterConnectPortGidAB column data
    var checkInterConnectPorts = (from icp in entities.LogicalConnectionEndToEnd_v
                                  select new
                                  {
                                      InterconnectPortGidA = icp.InterconnectPortGidA,
                                      InterconnectPortGidB = icp.InterconnectPortGidB
                                  }).ToList();

    return Json(new { interConnectPortGidABList = checkInterConnectPorts}, JsonRequestBehavior.AllowGet);

}

Am I missing something? from icp in entities.LogicalConnectionEndToEnd_v where InterconnectPortGidA != null && InterconnectPortGidB != null — fdomn-m
– fdomn-m, Commented Aug 22, 2016 at 17:41
What the first commenter said and I wouldn't create an anonymous object around the query results. I would just send the results --return Json(checkInterConnectPorts, JsonRequestBehavior.AllowGet); — Fran
– Fran, Commented Aug 22, 2016 at 17:48

fdomn-m · Accepted Answer · 2016-08-22 19:51:13Z

2

You can use where directly after the from entity and before the select:

var checkInterConnectPorts = (from icp in entities.LogicalConnectionEndToEnd_v
                              where InterconnectPortGidA != null 
                                 && InterconnectPortGidB != null
                              select new
                              {
                                  InterconnectPortGidA = icp.InterconnectPortGidA,
                                  InterconnectPortGidB = icp.InterconnectPortGidB
                              }).ToList();

This will get translated via the LINQ to SQL to a SQL statement, so will run on the SQL server directly, ie be the most efficient.

The query is deferred, it runs only when the query is executed, in this case at the time of the .ToList().

answered Aug 22, 2016 at 19:51

fdomn-m

28.8k8 gold badges39 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

C# Controller method entity model

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