I want to fetch an entity by DataAccessAdapter.FetchEntityUsingUniqueConstraint() to get result of the following sql statment. How can I write the code to fecth it?! Thank you very much!!!

Select Top 1 *
From Customer
Where Customer.Balance = (Select Max(Customer.Balance) From Customer)

I don't understand what your query should do, since it is not runnable. Try to run it against your database.

Sorry for typing mistake, I've revised my last message.

Please check the following thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=3382