Joins, OrderBy, etc on Find and FindBy statements?

[Kyle Fisher]

Is there a way to do a Join or an OrderBy when using a Find or
FindBy? I want to return a single record, but it seems that after the
Find(expr), the rest of the statement does not get evaluated?

// Sample join
var result =
db.Table.Find(db.Table.Field1 == "A")
.Join(db.Table2)
.On(db.Table.Field2 == db.Table2.Field2 &&
db.Table2.Field3 == "N");

Ideally trying to reproduce something like this:

SELECT TOP 1 [fields] FROM Table
JOIN Table ON Table.Field2 == Table2.Field2 AND Table2.Field3 = 'N'
WHERE Table.Field1 = 'A'

// Sample Order By
var result = db.Table.FindByField1("A").OrderByField2();

Trying to do something like this:
SELECT TOP 1 [fields] FROM Table WHERE Field1 = 'A' ORDER BY Field2

Thanks for the help!

Kyle

[Mark Rendle]

Do a FindAll or FindAllBy and call .Take(1).SingleOrDefault() on the end and it will do the TOP 1 bit in the SQL.

M

[nkaiseng safnate]

Please remove me from Simpl...@googlegroups.com

 

"Don't be afraid to be wrong; otherwise you'll never be right."

---

From: Mark Rendle <ma...@markrendle.net>
To: simpl...@googlegroups.com
Sent: Thursday, April 26, 2012 8:21 PM
Subject: Re: Joins, OrderBy, etc on Find and FindBy statements?

[Mark Rendle]

You can unsubscribe from the Google Groups page.

Sent from my iPad (until Win8 gets a mail app)