Menu
Is there a way to get the entire contents of a single column using Entity Framework 4? The same like this SQL Query:
SELECT Name FROM MyTable WHERE UserId = 1; 
223
We can do that simply by using the “new” operator and selecting the properties from the object that we need. In this case, we only want to retrieve the Id and Title columns.
var Q1 = (ds. Tables[1]. AsEnumerable() .
Select multiple columns using Entity Frameworkvar dataset2 = from recordset in entities. processlists where recordset. ProcessName == processname select recordset. ServerName, recordset.
You can use LINQ's .Select() to do that. In your case it would go something like:
string Name = yourDbContext .MyTable .Where(u => u.UserId == 1) .Select(u => u.Name) .SingleOrDefault(); // This is what actually executes the request and return a response If you are expecting more than one entry in response, you can use .ToList() instead, to execute the request. Something like this, to get the Name of everyone with age 30:
string[] Names = yourDbContext .MyTable .Where(u => u.Age == 30) .Select(u => u.Name) .ToList(); If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
