Jovan Popovic

Hi Sudhaa, Dependency injection is used as a convenience method and something that is standard in ASP.NET. If you need to provide different connection string on every query, I would...

I have investigated this, but it is not a problem in data access. Callback catches the exception (I have added a test that verifies this), but it seems that in...

There is a bug that might cause this and it is fixed in NuGet version 5.1: https://www.nuget.org/packages/MsSql.RestApi/0.5.1 However, I have not reproduced your issue. - Try to use version 0.5.1...

@Rich-AU @EagleSmith - if you are still interested for this here is example that you can try: https://github.com/JocaPC/sql-server-rest-api/tree/belgrade-odata-min-metadata-api This sample exposes system views `sys.objects`, `sys.columns`, and `sys.parameters` as OData api...

Here is [example of OData controller](https://github.com/JocaPC/sql-server-rest-api/blob/master/TestApp/Controllers/SysODataController.cs) that can provide OData content to Excel and LinqPad in main branch.

Actually it works. You just need to explicitly add a route that accepts $count: (see https://github.com/JocaPC/sql-server-rest-api/blob/master/TestApp/Controllers/RestApiController.cs#L88) ``` [HttpGet("[controller]/odata/objects")] [HttpGet("[controller]/odata/objects/$count")] public async Task Objects() ``` Count is not one of the...

Thanks @datahai - I fixed the script.

You can a create stored procedure that parses input JSON using OPENJSON and insert it into a table. Take a look at SQL Server GitHub samples: - Controller: https://github.com/Microsoft/sql-server-samples/blob/master/samples/features/json/product-catalog/dotnet-rest-api/Controllers/ProductController.cs -...