Is there way to get SQL to launch a C# application

Question

I am making an application, I would like to be able to get a script to put data into the database, but i was wondering can i get SQL to Launch a C# application to get information from the web and return that into the database without having to interact with the SQL database.

Realistically I would like the operation to run like so:

Query -> Launch c# -> input the data to DB

but i would like this all to work from the initial procedure, is something like this possible?

Does this answer your question? How to run a program from SQL? — DudeWhoWantsToLearn
– DudeWhoWantsToLearn, Commented Jan 9, 2020 at 8:02
DBAs everywhere will genuinely hate you if you do this... in almost any scenario, the flow should be "C# fetches / formats data from external source -> C# invokes SQL -> SQL stores (or whatever) the data". There is a capability to run .NET directly inside SQL Server, but : that is also no longer recommended, and is disabled by default on new versions, IIRC — Marc Gravell
– Marc Gravell, Commented Jan 9, 2020 at 8:04
Look at Sql clr integration learn.microsoft.com/en-us/sql/relational-databases/… — Serg
– Serg, Commented Jan 9, 2020 at 8:13

Murray Foxcroft · Accepted Answer · 2020-01-09 08:09:09Z

1

It it not favoured practice but you can use the below stored procedure to call a C# executable. Some times it is unavoidable if you are constrained.

xp_cmdshell { 'command_string' } [ , no_output ]

You can find the documentation here

answered Jan 9, 2020 at 8:09

Murray Foxcroft

13.9k7 gold badges66 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is there way to get SQL to launch a C# application

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related