GET_FILESTREAM_TRANSACTION_CONTEXT() is null
I'm having issues getting a file from a FILESTREAM varbinary(max) column.
I added it to a table using this:
ALTER TABLE [dbo].News ADD RowGuidColId
UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE DEFAULT (NewId())
GO
ALTER TABLE News ADD NewsPngFile varbinary(max) FILESTREAM NULL
GO
I insert the picture using entity framework. But when I try to query, the GET_FILESTREAM_TRANSACTION_CONTEXT() returns NULL. What might be wrong?
Solution
Have you already committed the transaction? To use this you need to explicity open a transaction, obtain the transaction context with the call to GET_FILESTREAM_TRANSACTION_CONTEXT() and then commit. GET_FILESTREAM_TRANSACTION_CONTEXT() will return NULL if the transaction has not been started, or has been canceled or committed.
There's a bit of documentation with an example available here:
- Cannot connect .NET app with MongoDB (System.MissingMethodException: Method not found:)
- Entity Framework Fluid Query Start and End Dates When Start is Nullable
- Newest version of npgsql with Entity Framework casting enum type error
- Unable to create an object of type 'MyContext'. For the different patterns supported at design time
- How do I control parameter sniffing and/or query hints in entity framework?
- How to add OPTION RECOMPILE into Entity Framework
- How do I view the SQL generated by the Entity Framework?
- Log Queries executed by Entity Framework DbContext
- Use int Id for a bigint column in EF6
- Entity Framework not loading related objects
- What does the DBContext.Entry do?
- "where" clause: entity id is in a potentially null array
- Entity Framework query slow, but same SQL in SqlQuery is fast
- What is the right way to get data from related tables using an entity and business models separately in ASP.NET Core Web API?
- How to add a model in asp.net mvc project
- Entity Framework - Check for pending migrations
- Check for pending migrations in Entity Framework?
- How to use query with quotes inside a parent query
- Constructor injection into IDesignTimeDbContextFactory
- An error occurred while accessing the Microsoft.Extensions.Hosting services when do first migrations
- Can I create an app with swift to controle a go pro camera from the phone?
- EF Core navigation properties to both a collection and a specific item in the collection
- Assign Credentials (user name/password) to EF in Code
- How to get next value of SQL Server sequence in Entity Framework?
- How to set a default value on a Boolean in a Code First model?
- Catch SqlException at the controller level?
- BeginTransaction with IsolationLevel in EF Core
- in entity framework code first, how to use KeyAttribute on multiple columns
- Cannot access a disposed context instance EF core
- Multiple includes using Entity Framework and Repository Pattern