How to do this query in EF?

[John]

Hi

I have a tblCLeinst entity in my model. What is the query equivalent to the
following conventional SQL?

SELECT TOP 1 <fields list> FROM tblClients WHERE (ID > 1234) AND (Status =
"Current") ORDER BY ID

Thanks

Regards

 

[dotNetDave]

Check this out on MSDN:

http://msdn.microsoft.com/en-us/library/bb896272.aspx

David

======================================
David McCarter [Microsoft MVP]
www.dotNetTips.com
David McCarter''''s .NET Coding Standards available at:
http://codingstandards.notlong.com