Answered by:
How to use return this.ObjectContext.Student.Where() method

Question
-
User1929428035 posted
I need to filter studentgrades whose grade are grater than 90%. How do I use the objectcontext where method. I've been searching the net and couldn't find any thing useful please help.
Monday, April 15, 2013 2:00 AM
Answers
-
User1938476581 posted
Hi,
try like this
var clients = from client in ObjectContext.Clients join cbc in ObjectContext.Client_Bucket_Client on client.Client_GUID equals cbc.Client_GUID join acb in ObjectContext.Agent_Client_Bucket on cbc.Client_Bucket_GUID equals acb.Client_Bucket_GUID where acb.Agent_GUID == agentGuid orderby client.Last_Change_Date descending, client.File_Under select client;
Source from http://forums.asp.net/t/1797254.aspx/1
ANd refer here
Hope it can help you
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, April 16, 2013 5:56 AM
All replies
-
User-1360095595 posted
Maybe ObjectContext.Student.Where(s => s.Grade > 90)
Monday, April 15, 2013 2:04 AM -
User1929428035 posted
Thank you very much for helping the ignorant. Now how do I include an inner join also I am doing this inside a domainservice.cs file how do I access the user details specifically email. I pray you can help.
Monday, April 15, 2013 6:07 AM -
User1938476581 posted
Hi,
try like this
var clients = from client in ObjectContext.Clients join cbc in ObjectContext.Client_Bucket_Client on client.Client_GUID equals cbc.Client_GUID join acb in ObjectContext.Agent_Client_Bucket on cbc.Client_Bucket_GUID equals acb.Client_Bucket_GUID where acb.Agent_GUID == agentGuid orderby client.Last_Change_Date descending, client.File_Under select client;
Source from http://forums.asp.net/t/1797254.aspx/1
ANd refer here
Hope it can help you
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, April 16, 2013 5:56 AM