1. Create database and tables2. Create stored procedure 3. Create BizTalk project 4. Create orchestration 5. Consume WCF-SQL 6. Write received data to file share
First create TESTWCFSQL database from you SQL Management studio Run the script to create table: USE TESTWCFSQLGO IF OBJECT_ID('dbo.MainData', 'U') IS NOT NULL DROP TABLE dbo.MainDataGO CREATE TABLE dbo.MainData(MainDataID int primary key identity(1,1),FirstName nvarchar(30),LastName nvarchar(30),Amount int)GO Run script in SQL management studio to create procedure IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE SPECIFIC_SCHEMA = N'dbo' AND SPECIFIC_NAME = N'PollData' ) DROP PROCEDURE dbo.PollData GO CREATE PROCEDURE dbo.PollData AS select MainDataID, FirstName, LastName, Amount from dbo.MainData delete from dbo.MainData GO insert some sample lines executing use TESTWCFSQL insert into MainData (FirstName, LastName, Amount) values (N'Patrick', N'Cash', 1000), (N…
Next click on TypePolling which is the root for schema In properties find Body XPath and edit it as in picture is Then change the last node to have Max Occurs = 1 Now we should remove hidden stones :-) When you added adapter metadata f…
While working on small chess application had an idea to integrate Stockfish engine, so it will be possible to play with engine. More about Stockfish here : https://stockfishchess.org/
and here https://github.com/mcostalba/Stockfish
The idea is to pass FEN and Depth for calculation to some API which will suggest the best move.
My main problem is that the goal is to host engine in Azure, as function written in C# while Stockfish is in C++. There are of course some .net ports but really outdated and did not want to experiment with them.
First step is just to clone git repo of Stockfish and build exe file, put it into separate folder in my solution. Stockfish is a command line tool. I will send the commands to console and read the output.
This is what I will send and get:
And in the solution it will look like this:
With "No build" and "Copy to output" options
The function by itself to get the request is pretty simple: [FunctionName("stockfish")] public stat…