locked
How to use return this.ObjectContext.Student.Where() method RRS feed

  • 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

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

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

    Hope it can help you
     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, April 16, 2013 5:56 AM