Does LLBLGen support SQL Server 2008 Filestream feature?

Posts   
 
    
w3stfa11
User
Posts: 13
Joined: 01-Jul-2010
# Posted on: 15-Jul-2010 22:31:03   

Does the latest 3.0 version support Filestream in SQL Server 2008?

If not, what other options are available? Just use ADO.NET when dealing with those files?

Thanks

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 16-Jul-2010 01:32:09   

At the moment I don't think we do, but I'll check properly with the dev team for you. What happens if you point the designer at a field of type FILESTREAM - it could be that it is handled transparently...?

Matt

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39903
Joined: 17-Aug-2003
# Posted on: 16-Jul-2010 09:51:16   

We don't support FILESTREAM, like we also don't support BFILE on oracle. The main issue is that when fetching the data with a column containing a FILESTREAM or BFILE type, the entity isn't fetched when the data is read: it's to be read separately, so this creates a situation where an entity object has to be returned but it can't be returned yet because the filestream /bfile hasn't been read yet, however reading it later on would require a db connection, which is also not ideal/perhaps not even possible (entity is higher up the call stack)

Our recommendation is to use varbinary(max) fields on sqlserver and BLOB fields on oracle instead: one can fetch these fields later on and exclude them from the fetch process using the excluded fields feature.

Frans Bouma | Lead developer LLBLGen Pro