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.

Answer 1

User-1360095595 posted

Maybe ObjectContext.Student.Where(s => s.Grade > 90)

Answer 2

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.

Answer 3

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

http://stackoverflow.com/questions/7527897/entity-framework-how-to-manually-produce-inner-joins-with-linq-to-entitites

Hope it can help you