yoyo wrote:
Sorry for this basic questions! This is my first time using LLBL. I am using adapter
Ok, if it's your first time, are you sure you want to execute a raw SQL statement, or that you want to run a query using predicates? What's the query you want to run exactly?
Using adapter, you can obtain a connection by using a derived class from DataAccessAdapter and in there place your method which will execute the raw SQL. Then create a new physical connection object by using base.CreateNewPhysicalConnection(), and write normal ADO.NET code using that connection.
Though if you want to do something else, please be more specific. I have the feeling you want to know how to fetch data/update data for example, as it's not recommended to execute raw sql via the framework.
