asp.net-mvc - 如何在 EF Code First 中使用 FileTable

Question

我在 SQL Server 2014 中使用 FileTable，在我的项目中首先使用 EF 代码。

当我使用这个命令时

USE [master]
GO
ALTER DATABASE [OnlineStore] 
SET FILESTREAM( DIRECTORY_NAME = N'OnlineStore',
    NON_TRANSACTED_ACCESS = FULL) WITH NO_WAIT
GO

它在sql中显示了这个警告

When the FILESTREAM database option NON_TRANSACTED_ACCESS is set to FULL and the READ_COMMITTED_SNAPSHOT or the ALLOW_SNAPSHOT_ISOLATION options are on, T-SQL and transactional read access to FILESTREAM data in the context of a FILETABLE is blocked.

现在我继续创建表，插入文件夹和文件没问题。

我读取数据的问题，读取数据时显示此错误:

Msg 33447, Level 16, State 1, Line 2
Cannot access file_stream column in FileTable 'File', because FileTable doesn't support row versioning. Either set transaction level to something other than READ COMMITTED SNAPSHOT or SNAPSHOT, or use READCOMMITTEDLOCK table hint.

我首先使用 EF 代码 - 如何解决这个问题？

Answer 1

您必须运行此命令才能选择表。使用[主人]去ALTER DATABASE [dbname] SET READ_COMMITTED_SNAPSHOT OFF WITH NO_WAIT