MassTransit JobConsumer: (0x80131904): Incorrect syntax near the keyword 'UPDATE'

Question

I try to start MassTransit/Sample-JobConsumer on EntityFramework Core, but having strange error

(0x80131904): Incorrect syntax near the keyword 'UPDATE'

Steps to reproduce:

1. Clone MassTransit/Sample-JobConsumer

2. Remove PostgreSQL an install EntityFrameworkCore

3. Command Update-Database creates a correct database

4. Start project JobService.Service

5. Post request from Postman (response is valid):

6. RabbitMQ accept requests:

7. But error occured during processing (in console):

Please, anyone help me to understand what is happened.

You can see repository on github with EntityFrameworkCore storage implemented

P.S. With default configuration the error was different

[Update 1]

After I changed PostgresLockStatementProvider to SqlServerLockStatementProvider (Thanks to Chris Patterson for help). But I`ve got another error:

[Update 2]

After I was installed plugin for RabbitMQ everything became works fine with EntityFrameworkCore too! (Thanks to Chris Patterson)

Answer 1

To change to SQL Server, you'd need to change the EF Core configuration to UseSqlServer, you also need to remove the PostgreSQL lock provider (the default lock provider is SqlServer). There are three lines where this change is needed, one for each state machine.