How do MS Access and MS SQL Server communicate?

Question

C++ / C#

There is a MS SQL database with triggers for saving history, tracking INSERT, UPDATE, DELETE. When the client (WinForm) communicates with the database with simple queries (example: DELETE FROM [dbo].[table] WHERE [id]='1'), the trigger writes an event. But if you connect to the database with Access, the triggers do not work or work incorrectly. I assume that Access uses something like LINQ in entity framework. Is it so? And if so what does Access use?

Answer 1

Colleague, triggers are internal mechanisms of ms sql. So that they do not work - this, in principle, does not happen.
Moreover, it does not happen that they worked correctly in one case and did not work in another - rather, I believe that they are crookedly written.
Give examples from a real database. It's also a good idea to specify exactly how you work with the database.

Answer 2

Your assumption cannot be correct for a simple reason. LINQ/ EntityFramework/НЁХ - it's all eventually unfolded anyway into a regular SQL query to the database, wrapped in a transaction.

Answer 3

See profiler, MSSQL has it out of the box. And you don't have to guess.