Hi,

I want to execute a raw SQL statment through LLBL. (adapter)

For eg:

SELECT EmpId FROM Empolyees;

Can you please tell me how to do it.I checked some of the threads here regarding this topic but could not find the answer.

Please help. Thanks.

Have you considered using DynamicLists or your case is more complex than what you have posted?

Hello Walaa,

My case is I have to get the SQL statements from a TextBox (multiline) which is entred by user.My work requires that I save these SQL statements in a table in the DB.Before saving these statements I have to make sure that these SQL statement gets executed successfully in the DB without any error.The user will enter only the SELECT statements of any table in the DB.

So this is the scenario.I hope I'm clear to you.

can you please help me with some examples.

Thanks.

In this case I think you'll be better passing directly the sql to the driver of your Database and later you could llbgen to persist the query to your DB.

You could create a RetrievalQuery object and pass it to the FetchProjection / GetAsProjection routine to fetch it and then use one of the projection classes to project it to the object of choice, e.g. entities, datatable, custom class...

Thanks for your replies.

But i kind of had to stop that work.I directly used ADO.net to get the desired results.

But still if there is any example, it would be really helpful.

I think the following thread has everything you need to know about executing raw SQL: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=9173