Main Page | Report this Page
.NET DotNet Forum Index  »  ADO .NET Forum  »  How to do this query in EF?...
Page 1 of 1    

How to do this query in EF?...
Author Message
John...
Posted: Tue Jul 28, 2009 4:20 pm
Guest
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
Back to top  
dotNetDave...
Posted: Mon Aug 03, 2009 12:49 pm
Guest
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


"John" wrote:

Quote:
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


Back to top  
 
    Display posts from previous:  
Page 1 of 1    
All times are GMT - 5 Hours
The time now is Sun Mar 21, 2010 2:25 am
.NET DotNet Forum Index
 

Powered by phpBB & ML | Privacy Policy / Disclaimer



Contact Us