.net - Is there a SqlFileStream like class that works with Sql Server 2005? -

For the background of this question, check that it is now a big reward .

Sits above a blob () value stored in the database that gives you however, due to limitations on SqlFileStream implementation it will only work with SQL Server 2008.

Logically I can not see any reason because some APIs can not be made available on SQL Server 2000 and SQL Server 2005.

Does anyone know that this has been done?

Is there an open source implementation of this anywhere?

What am I missing in thinking that this should be possible

I do not know about any other class except SQL Server 2008 I suspect that it is completely below the fact that SqlFileStream class is especially "at the top Sitting is created for "SQL type 2008" column type FILESTREAM within SQL Server 2008.

This is only available in SQL Server 2008 and essentially allows to store large amounts of data in this column. A FILESTREAM column is actually a varbinary (max) column with a FILESTREAM modifier. This is essentially the RDBMS storage Bypass subsystem and store binary data directly on the built-in NTFS file system, which is in retaining transactional integrity from RDBMS perspective for this data.

It says this way:

The FILESTREAM attribute would cause the data to be stored in the local NTFS file system in place of the database file on a varbinary (max) column is. Transact-SQL statements provide data overwriting capabilities within the server, and Win32 file system interface provides streaming access to data.

The MSDN article also states that:

The SqlFileStream API works in the context of a SQL Server transaction.

But also that:

inherits.IO.Stream class from the SqlFileStream system, which provides ways to read and write streams of data. Moves the data from the Stream from the Stream to the data structure, such as transferring an array of data from the data structure into a stream.

It is suggesting that, internally, the SQLFileStream works in the same manner as a "bog-standard"

However, perhaps the most The information told is why this functionality is not available in previous versions of SQL Server (which does not apply to any type of FILESTREAM or "direct-to-built-archive" column type) MSDN article which states: / P>

FILESTREAM file system As files on Tm varbinary (max) binary large object (BLOB) to store data integrates SQL Server Database Engine with an NTFS file system. Transact-SQL statement FILESTREAM can insert, update, query, search, and back up data. Win32 File System Interfaces provide streaming access to data.

The FILESTREAM file system uses the NT system caching for caching. It helps to reduce any effect that the database engine performance on FILESTREAM data may not be used in the SQL server buffer pool; Therefore, this memory is available for query processing.

It essentially says that the use of a SqlFileStream object will work just like a "standard" filestream object, except that SQL Server (for transactional integrity purposes) is a very Will act as a light "gatekeeper" (or "cover), which is to read and write binary data in an underlying NTFS file system file." Since no previous version of SQL Server has such functionality and built-in The interest does not offer direct integration with the NTFS file system, I can say that it will not be possible to execute the SQLFileStream against any version of SQL Server before the SQL Server. (At least one is not the "file" Write in, but maintaining RDBMS transactional integrity "features).