Does OpenAccess have an API for accessing filestream files in SQL Server databases using the win32 API? From doing research here
, it seems that Microsoft highly recommends using the win32 API for larger files for maximum performance, but I haven't been able to find any documentation on how to best integrate that strategy into my OpenAccess supported application.
My application needs to enable users to upload (and later read) large pdfs (sometimes up to ~50MB), and I want to take advantage of best practices where I can to ensure maximum performance.
Note: all database changes are first made directly in SQL Server and then uploaded to the application. I'm concerned about creating code in my application that will get overwritten next time I do that sync, so any tips on how to avoid that would be very welcome.
Note: I'm using SQL Server 2012, Visual Studio 2012, and ASP.NET MVC4. I also have a DevCraft complete license, so I have access to other Telerik tools, if that helps.