c# - SQL Server 2014 in memory table and transactions -


i'm using entity framework 6.1.0 sql server 2014.

i'm attempting perform several operations under transaction i've created this:

(var transaction = context.database.begintransaction()) {   } 

but i'm getting error

accessing memory optimized tables using read committed isolation level supported autocommit transactions. not supported explicit or implicit transactions. provide supported isolation level memory optimized table using table hint, such (snapshot).

i have tried possible isolation levels (those allowed in memory tables) no avail.

how can perform atomic transactions code in memory tables?

the solution enable memory_optimized_elevate_to_snapshot

resource: http://msdn.microsoft.com/en-us/library/dn133175(v=sql.120).aspx


Comments

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

git - Initial Commit: "fatal: could not create leading directories of ..." -