I need to use the FILESTREAM feature of SQL Server Express 2008 feature. In order to use this, I must be able to generate the following query. And I need to be able to execute this inside an existing LLBLGen transaction. When I add a row to a table with a FILESTREAM field, I need to subsequently invoke this SQL to find the pathname to be used to stream a blob into that field.

select MyField.PathName() from MyTable where MyTable.MyGuidField='004A0341-E760-4F9B-ADE7-A33B46CC21D7'

I've searched hi and lo for a way to invoke my own SQL with LLBLGen and have had no luck. Also, tried concocting it by building fields and filters, also with no luck. I really would like to stay away from stored procs and UDTs. But if LLBLGen wont' let me build this SQL, then I guess I might have to punt.

Please check the following links: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14784 http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14203

Thanks Walaa. I had found those messages and understand that the FILESTREAM is not directly supported. This makes sense since for the reasons mentioned.

However, I'm just wanting to know how to invoke the query I posted in the original message. Just consider this a question totally unrelated to FILESTREAM. How does one invoke that SQL statement inside an existing transaction that was created by calls to the LLBLGen created objects.

mmm. Check this thread: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=15420 Idea: Derive from the DataAccessAdapter and override the CreateSelectDQ