Call a C# function from MySQL

Question

Is it possible to call a C# function from MySQL ?

For instance, if a table changed, I'd like to call a C# function, instead of having C# constantly polling MySQL to check if a change occurred.

What does the C# function do on change occurred in the database? — Hkachhia, Mar 03 '21 at 12:41
You could try to use a store procedure instead. that might just work. But C# in SQL, NOPE! not yet. maybe someone is working on that project but not released. :) — mw509, Mar 03 '21 at 12:44
Why don't use MQTT? with publish and subscribe method which decrease your polling from the frontend side. — Hkachhia, Mar 03 '21 at 12:45
There is SqlDependency for SQL Server, I think there should be something similar for MYSQL also — Vivek Nuna, Mar 03 '21 at 13:08
@viveknuna There isn't: https://stackoverflow.com/questions/55057725/how-to-push-mysql-database-data-to-a-mvc-net-web-application — Bradley Grainger, Mar 03 '21 at 16:59

score 1 · Answer 1 · answered Mar 03 '21 at 13:13

1

No, you can't call a c# method from MySQL.

You'll need to re-architect your software with another approach.

answered Mar 03 '21 at 13:13

gunr2171

score 0 · Answer 2 · answered Mar 03 '21 at 14:19

It is possible

You can execute an external process from inside MySql, see for example: Execute shell commands from MySQL stored procedure

That process could then initiate a callback to the originating c# client, for example over a network socket.

But just because something is possible, does not mean it is a good idea!

2 Answers2