Lab 8-Integrate SQL solutions with Azure services- Need improvement in instructions

[madhavichetan2121]

Lab 8- Integrate SQL solutions with Azure services
Issue 1- Lab start with Database creation by connecting Azure SQL database to SSMS/VS Code/SQL server.
But there is now step to create the SQL DB in Azure like other labs.
May me due to that there is no Azure subscription in Skillable platform.
Please add Azure SQL Database createtion task at the start.

Issue 2 - Under task- Test locally
Option B: SQL authentication
Shell | Command
PowerShell | $env:DATABASE_CONNECTION_STRING="Server=your-server.database.windows.net;Database=ProductCatalog;User Id=your-user;Password=your-password;TrustServerCertificate=true"

This gives error - else use the "connection string" as below- tested and worked well

PowerShell | $env:DATABASE_CONNECTION_STRING="Server=tcp:.database.windows.net,1433;Initial Catalog=;Persist Security Info=False;User ID=;Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"

[KDSynergetics]

For Local Server i.e. MS-SQL server installed on Lab VM. I think, below connection string need to be added or update the azure credentials for azure sql db practice.

PS C:\Users\Admin\product-catalog-api> $env:DATABASE_CONNECTION_STRING="Server=localhost;Database=ProductCatalog;Integrated Security=True;Encrypt=True;TrustServerCertificate=true;Connection Timeout=30;"

above connection string worked for me. PFB logs and output snaps for reference.

PS C:\Users\Admin\product-catalog-api> $env:DATABASE_CONNECTION_STRING="Server=localhost;Database=ProductCatalog;Integrated Security=True;Encrypt=True;TrustServerCertificate=true;Connection Timeout=30;"
PS C:\Users\Admin\product-catalog-api> dab start
info: Microsoft.DataApiBuilder 2.0.8
info: Config not provided. Trying to get default config based on DAB_ENVIRONMENT...
info: Environment variable DAB_ENVIRONMENT is
info: Loaded config file: dab-config.json
info: Setting minimum LogLevel: Debug.
info: Azure.DataApiBuilder.Service.Startup[0]
Response compression enabled with level 'Optimal' for REST, GraphQL, and MCP endpoints.
warn: Azure.DataApiBuilder.Service.Startup[0]
Logs won't be sent to Open Telemetry because a valid Open Telemetry endpoint URI is not available in the runtime config.
info: Azure.DataApiBuilder.Config.FileSystemRuntimeConfigLoader[0]
Loading config file from C:\Users\Admin\product-catalog-api\dab-config.json.
info: Azure.DataApiBuilder.Config.FileSystemRuntimeConfigLoader[0]
Loading config file from C:\Users\Admin\product-catalog-api\dab-config.json.
info: Azure.DataApiBuilder.Config.FileSystemRuntimeConfigLoader[0]
Monitoring config: dab-config.json for hot-reloading.
info: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0]
[Category] REST path: /api/Category
info: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0]
[Product] REST path: /api/Product
info: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0]
[ProductCatalog] REST path: /api/ProductCatalog
dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
Executing query: SELECT STE.type_desc FROM sys.triggers ST inner join sys.trigger_events STE On ST.object_id = STE.object_id AND ST.parent_id = object_id(@param0 + '.' + @param1) WHERE ST.is_disabled = 0;
dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
Executing query: SELECT ifsc.COLUMN_NAME from sys.columns as sc INNER JOIN INFORMATION_SCHEMA.COLUMNS as ifsc ON (sc.is_computed = 1 or ifsc.DATA_TYPE = 'timestamp') AND sc.object_id = object_id(@param0+'.'+@param1) AND ifsc.TABLE_SCHEMA = @param0 AND ifsc.TABLE_NAME = @param1 AND ifsc.COLUMN_NAME = sc.name;
dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
Executing query: SELECT STE.type_desc FROM sys.triggers ST inner join sys.trigger_events STE On ST.object_id = STE.object_id AND ST.parent_id = object_id(@param0 + '.' + @param1) WHERE ST.is_disabled = 0;
dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
Executing query: SELECT ifsc.COLUMN_NAME from sys.columns as sc INNER JOIN INFORMATION_SCHEMA.COLUMNS as ifsc ON (sc.is_computed = 1 or ifsc.DATA_TYPE = 'timestamp') AND sc.object_id = object_id(@param0+'.'+@param1) AND ifsc.TABLE_SCHEMA = @param0 AND ifsc.TABLE_NAME = @param1 AND ifsc.COLUMN_NAME = sc.name;
dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0]
Executing query:
SELECT
ReferentialConstraints.CONSTRAINT_NAME [ForeignKeyDefinition],
ReferencingColumnUsage.TABLE_SCHEMA
[ReferencingSchemaName],
ReferencingColumnUsage.TABLE_NAME [ReferencingSourceDefinition],
ReferencingColumnUsage.COLUMN_NAME [ReferencingColumns],
ReferencedColumnUsage.TABLE_SCHEMA
[ReferencedSchemaName],
ReferencedColumnUsage.TABLE_NAME [ReferencedSourceDefinition],
ReferencedColumnUsage.COLUMN_NAME [ReferencedColumns]
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS ReferentialConstraints
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE ReferencingColumnUsage
ON ReferentialConstraints.CONSTRAINT_CATALOG = ReferencingColumnUsage.CONSTRAINT_CATALOG
AND ReferentialConstraints.CONSTRAINT_SCHEMA = ReferencingColumnUsage.CONSTRAINT_SCHEMA
AND ReferentialConstraints.CONSTRAINT_NAME = ReferencingColumnUsage.CONSTRAINT_NAME
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE ReferencedColumnUsage
ON ReferentialConstraints.UNIQUE_CONSTRAINT_CATALOG = ReferencedColumnUsage.CONSTRAINT_CATALOG
AND ReferentialConstraints.UNIQUE_CONSTRAINT_SCHEMA = ReferencedColumnUsage.CONSTRAINT_SCHEMA
AND ReferentialConstraints.UNIQUE_CONSTRAINT_NAME = ReferencedColumnUsage.CONSTRAINT_NAME
AND ReferencingColumnUsage.ORDINAL_POSITION = ReferencedColumnUsage.ORDINAL_POSITION
WHERE
ReferencingColumnUsage.TABLE_SCHEMA IN (@schemaName0, @schemaName1, @schemaName2)
AND ReferencingColumnUsage.TABLE_NAME IN (@tableName0, @tableName1, @tableName2)
dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0]
Logging primary key information for entity: Category.
dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0]
Primary key column name: CategoryID
Primary key mapped name: CategoryID
Type: Int32
IsNullable: False
IsAutoGenerated: True
dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0]
Logging primary key information for entity: Product.
dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0]
Primary key column name: ProductID
Primary key mapped name: id
Type: Int32
IsNullable: False
IsAutoGenerated: True
dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0]
Logging primary key information for entity: ProductCatalog.
dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0]
Primary key column name: ProductID
Primary key mapped name: ProductID
Type: Int32
IsNullable: False
IsAutoGenerated: False
dbug: Azure.DataApiBuilder.Core.Configurations.RuntimeConfigValidator[0]
Category: dbo.Categories(CategoryID) is related to many Product: dbo.Products(CategoryID).
dbug: Azure.DataApiBuilder.Core.Configurations.RuntimeConfigValidator[0]
Product: dbo.Products(CategoryID) is related to one Category: dbo.Categories(CategoryID).
info: Azure.DataApiBuilder.Service.Startup[0]
Successfully completed runtime initialization.
dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ModelBinderFactory[12]
Registered model binder providers, in the following order: Microsoft.AspNetCore.Mvc.ModelBinding.Binders.BinderTypeModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.ServicesModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.BodyModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.HeaderModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.FloatingPointTypeModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.EnumTypeModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.DateTimeModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.SimpleTypeModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.TryParseModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.CancellationTokenModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.ByteArrayModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.FormFileModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.FormCollectionModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.KeyValuePairModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.DictionaryModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.ArrayModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.CollectionModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.ComplexObjectModelBinderProvider
dbug: Microsoft.AspNetCore.Server.Kestrel[0]
No listening endpoints were configured. Binding to http://localhost:5000 by default.
info: Microsoft.Hosting.Lifetime[14]
Now listening on: http://localhost:5000
dbug: Microsoft.AspNetCore.Hosting.Diagnostics[13]
Loaded hosting startup assembly Azure.DataApiBuilder.Service
info: Microsoft.Hosting.Lifetime[0]
Application started. Press Ctrl+C to shut down.
info: Microsoft.Hosting.Lifetime[0]
Hosting environment: Production
info: Microsoft.Hosting.Lifetime[0]
Content root path: C:\Users\Admin\product-catalog-api
dbug: Microsoft.Extensions.Hosting.Internal.Host[2]
Hosting started
dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[39]
Connection id "0HNMHOCHUODM7" accepted.
dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[1]
Connection id "0HNMHOCHUODM7" started.
dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[39]
Connection id "0HNMHOCHUODM8" accepted.
dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[1]
Connection id "0HNMHOCHUODM8" started.
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 GET http://localhost:5000/api/Product - - -
dbug: Microsoft.AspNetCore.HostFiltering.HostFilteringMiddleware[0]
Wildcard detected, all requests with hosts will be allowed.
warn: Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3]
Failed to determine the https port for redirect.
dbug: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[3]
The request path does not match the path filter
dbug: Microsoft.AspNetCore.Routing.Matching.DfaMatcher[1001]
1 candidate(s) found for the request path '/api/Product'
dbug: Microsoft.AspNetCore.Routing.Matching.DfaMatcher[1005]
Endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' with route pattern '{*route}' is valid for the request path '/api/Product'
dbug: Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware[1]
Request matched endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)'
dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.UnauthenticatedAuthentication.UnauthenticatedAuthenticationHandler[8]
AuthenticationScheme: UnauthenticatedAuthentication was successfully authenticated.
dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0]
cf5d807b-4930-4cdf-a8c0-e4121ca4de69 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[102]
Route matched with {action = "Find", controller = "Rest"}. Executing controller action with signature System.Threading.Tasks.Task1[Microsoft.AspNetCore.Mvc.IActionResult] Find(System.String) on controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service). dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of authorization filters (in the following order): None dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of resource filters (in the following order): None dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of action filters (in the following order): Microsoft.AspNetCore.Mvc.ModelBinding.UnsupportedContentTypeFilter (Order: -3000), Microsoft.AspNetCore.Mvc.Infrastructure.ModelStateInvalidFilter (Order: -2000) dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of exception filters (in the following order): None dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of result filters (in the following order): Microsoft.AspNetCore.Mvc.Infrastructure.ClientErrorResultFilter (Order: -2000), Microsoft.AspNetCore.Mvc.ProducesAttribute (Order: 0) dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Executing controller factory for controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service) dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2] Executed controller factory for controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service) dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[22] Attempting to bind parameter 'route' of type 'System.String' ... dbug: Microsoft.AspNetCore.Mvc.ModelBinding.Binders.SimpleTypeModelBinder[44] Attempting to bind parameter 'route' of type 'System.String' using the name 'route' in request data ... dbug: Microsoft.AspNetCore.Mvc.ModelBinding.Binders.SimpleTypeModelBinder[45] Done attempting to bind parameter 'route' of type 'System.String'. dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[23] Done attempting to bind parameter 'route' of type 'System.String'. dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[26] Attempting to validate the bound parameter 'route' of type 'System.String' ... dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[27] Done attempting to validate the bound parameter 'route' of type 'System.String'. dbug: Microsoft.AspNetCore.Authorization.DefaultAuthorizationService[1] Authorization was successful. dbug: Microsoft.AspNetCore.Authorization.DefaultAuthorizationService[1] Authorization was successful. dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0] cf5d807b-4930-4cdf-a8c0-e4121ca4de69 Executing query: SELECT TOP 101 [dbo_Products].[ProductID] AS [id], [dbo_Products].[ProductName] AS [name], [dbo_Products].[CategoryID] AS [CategoryID], [dbo_Products].[UnitPrice] AS [price], [dbo_Products].[UnitsInStock] AS [stockQuantity], [dbo_Products].[Discontinued] AS [isDiscontinued] FROM [dbo].[Products] AS [dbo_Products] WHERE 1 = 1 ORDER BY [dbo_Products].[ProductID] ASC FOR JSON PATH, INCLUDE_NULL_VALUES dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[11] List of registered output formatters, in the following order: Microsoft.AspNetCore.Mvc.Formatters.HttpNoContentOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.StringOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.StreamOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.SystemTextJsonOutputFormatter dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[4] No information found on request to perform content negotiation. dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[9] Attempting to select the first output formatter in the output formatters list which supports a content type from the explicitly specified content types 'application/json'. dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[2] Selected output formatter 'Microsoft.AspNetCore.Mvc.Formatters.SystemTextJsonOutputFormatter' and content type 'application/json' to write the response. info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1] Executing OkObjectResult, writing value of type '<>f__AnonymousType11[[System.Collections.Generic.List1[[System.Text.Json.JsonElement, System.Text.Json, Version=10.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. dbug: Microsoft.AspNetCore.ResponseCompression.ResponseCompressionProvider[8] The response will be compressed with 'gzip'. info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[105] Executed action Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service) in 1126.6159ms info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1] Executed endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[9] Connection id "0HNMHOCHUODM8" completed keep alive response. info: Microsoft.AspNetCore.Hosting.Diagnostics[2] Request finished HTTP/1.1 GET http://localhost:5000/api/Product - 200 - application/json;+charset=utf-8 4826.3308ms info: Microsoft.AspNetCore.Hosting.Diagnostics[1] Request starting HTTP/1.1 GET http://localhost:5000/favicon.ico - - - dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0] bf37a04f-24ea-49e7-9567-34a7de36db25 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication dbug: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[3] The request path does not match the path filter dbug: Microsoft.AspNetCore.Routing.Matching.DfaMatcher[1001] 1 candidate(s) found for the request path '/favicon.ico' dbug: Microsoft.AspNetCore.Routing.Matching.DfaMatcher[1005] Endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' with route pattern '{*route}' is valid for the request path '/favicon.ico' dbug: Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware[1] Request matched endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.UnauthenticatedAuthentication.UnauthenticatedAuthenticationHandler[8] AuthenticationScheme: UnauthenticatedAuthentication was successfully authenticated. info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0] Executing endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[102] Route matched with {action = "Find", controller = "Rest"}. Executing controller action with signature System.Threading.Tasks.Task1[Microsoft.AspNetCore.Mvc.IActionResult] Find(System.String) on controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service).
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1]
Execution plan of authorization filters (in the following order): None
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1]
Execution plan of resource filters (in the following order): None
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1]
Execution plan of action filters (in the following order): Microsoft.AspNetCore.Mvc.ModelBinding.UnsupportedContentTypeFilter (Order: -3000), Microsoft.AspNetCore.Mvc.Infrastructure.ModelStateInvalidFilter (Order: -2000)
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1]
Execution plan of exception filters (in the following order): None
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1]
Execution plan of result filters (in the following order): Microsoft.AspNetCore.Mvc.Infrastructure.ClientErrorResultFilter (Order: -2000), Microsoft.AspNetCore.Mvc.ProducesAttribute (Order: 0)
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1]
Executing controller factory for controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service)
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Executed controller factory for controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service)
dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[22]
Attempting to bind parameter 'route' of type 'System.String' ...
dbug: Microsoft.AspNetCore.Mvc.ModelBinding.Binders.SimpleTypeModelBinder[44]
Attempting to bind parameter 'route' of type 'System.String' using the name 'route' in request data ...
dbug: Microsoft.AspNetCore.Mvc.ModelBinding.Binders.SimpleTypeModelBinder[45]
Done attempting to bind parameter 'route' of type 'System.String'.
dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[23]
Done attempting to bind parameter 'route' of type 'System.String'.
dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[26]
Attempting to validate the bound parameter 'route' of type 'System.String' ...
dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[27]
Done attempting to validate the bound parameter 'route' of type 'System.String'.
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[11]
List of registered output formatters, in the following order: Microsoft.AspNetCore.Mvc.Formatters.HttpNoContentOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.StringOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.StreamOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.SystemTextJsonOutputFormatter
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[4]
No information found on request to perform content negotiation.
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[9]
Attempting to select the first output formatter in the output formatters list which supports a content type from the explicitly specified content types 'application/json, application/problem+json, application/problem+xml'.
dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[2]
Selected output formatter 'Microsoft.AspNetCore.Mvc.Formatters.SystemTextJsonOutputFormatter' and content type 'application/json' to write the response.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1]
Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'.
dbug: Microsoft.AspNetCore.ResponseCompression.ResponseCompressionProvider[8]
The response will be compressed with 'gzip'.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[105]
Executed action Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service) in 53.6376ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)'
dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[9]
Connection id "0HNMHOCHUODM8" completed keep alive response.
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished HTTP/1.1 GET http://localhost:5000/favicon.ico - 404 - application/json;+charset=utf-8 73.8352ms
dbug: Microsoft.AspNetCore.Server.Kestrel.Transport.Sockets[6]
Connection id "0HNMHOCHUODM7" received FIN.
dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[10]
Connection id "0HNMHOCHUODM7" disconnecting.
dbug: Microsoft.AspNetCore.Server.Kestrel.Transport.Sockets[7]
Connection id "0HNMHOCHUODM7" sending FIN because: "The Socket transport's send loop completed gracefully."
dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[2]
Connection id "0HNMHOCHUODM7" stopped.

[KDSynergetics]

PS C:\Users\Admin\product-catalog-api> $env:DATABASE_CONNECTION_STRING="Server=localhost;Database=ProductCatalog;Integrated Security=True;Encrypt=True;TrustServerCertificate=true;Connection Timeout=30;"

above connection string worked for me. PFB logs and output snaps for reference.

PS C:\Users\Admin\product-catalog-api> $env:DATABASE_CONNECTION_STRING="Server=localhost;Database=ProductCatalog;Integrated Security=True;Encrypt=True;TrustServerCertificate=true;Connection Timeout=30;" PS C:\Users\Admin\product-catalog-api> dab start info: Microsoft.DataApiBuilder 2.0.8 info: Config not provided. Trying to get default config based on DAB_ENVIRONMENT... info: Environment variable DAB_ENVIRONMENT is info: Loaded config file: dab-config.json info: Setting minimum LogLevel: Debug. info: Azure.DataApiBuilder.Service.Startup[0] Response compression enabled with level 'Optimal' for REST, GraphQL, and MCP endpoints. warn: Azure.DataApiBuilder.Service.Startup[0] Logs won't be sent to Open Telemetry because a valid Open Telemetry endpoint URI is not available in the runtime config. info: Azure.DataApiBuilder.Config.FileSystemRuntimeConfigLoader[0] Loading config file from C:\Users\Admin\product-catalog-api\dab-config.json. info: Azure.DataApiBuilder.Config.FileSystemRuntimeConfigLoader[0] Loading config file from C:\Users\Admin\product-catalog-api\dab-config.json. info: Azure.DataApiBuilder.Config.FileSystemRuntimeConfigLoader[0] Monitoring config: dab-config.json for hot-reloading. info: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0] [Category] REST path: /api/Category info: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0] [Product] REST path: /api/Product info: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0] [ProductCatalog] REST path: /api/ProductCatalog dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0] Executing query: SELECT STE.type_desc FROM sys.triggers ST inner join sys.trigger_events STE On ST.object_id = STE.object_id AND ST.parent_id = object_id(@param0 + '.' + @param1) WHERE ST.is_disabled = 0; dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0] Executing query: SELECT ifsc.COLUMN_NAME from sys.columns as sc INNER JOIN INFORMATION_SCHEMA.COLUMNS as ifsc ON (sc.is_computed = 1 or ifsc.DATA_TYPE = 'timestamp') AND sc.object_id = object_id(@param0+'.'+@param1) AND ifsc.TABLE_SCHEMA = @param0 AND ifsc.TABLE_NAME = @param1 AND ifsc.COLUMN_NAME = sc.name; dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0] Executing query: SELECT STE.type_desc FROM sys.triggers ST inner join sys.trigger_events STE On ST.object_id = STE.object_id AND ST.parent_id = object_id(@param0 + '.' + @param1) WHERE ST.is_disabled = 0; dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0] Executing query: SELECT ifsc.COLUMN_NAME from sys.columns as sc INNER JOIN INFORMATION_SCHEMA.COLUMNS as ifsc ON (sc.is_computed = 1 or ifsc.DATA_TYPE = 'timestamp') AND sc.object_id = object_id(@param0+'.'+@param1) AND ifsc.TABLE_SCHEMA = @param0 AND ifsc.TABLE_NAME = @param1 AND ifsc.COLUMN_NAME = sc.name; dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0] Executing query: SELECT ReferentialConstraints.CONSTRAINT_NAME [ForeignKeyDefinition], ReferencingColumnUsage.TABLE_SCHEMA [ReferencingSchemaName], ReferencingColumnUsage.TABLE_NAME [ReferencingSourceDefinition], ReferencingColumnUsage.COLUMN_NAME [ReferencingColumns], ReferencedColumnUsage.TABLE_SCHEMA [ReferencedSchemaName], ReferencedColumnUsage.TABLE_NAME [ReferencedSourceDefinition], ReferencedColumnUsage.COLUMN_NAME [ReferencedColumns] FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS ReferentialConstraints INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE ReferencingColumnUsage ON ReferentialConstraints.CONSTRAINT_CATALOG = ReferencingColumnUsage.CONSTRAINT_CATALOG AND ReferentialConstraints.CONSTRAINT_SCHEMA = ReferencingColumnUsage.CONSTRAINT_SCHEMA AND ReferentialConstraints.CONSTRAINT_NAME = ReferencingColumnUsage.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE ReferencedColumnUsage ON ReferentialConstraints.UNIQUE_CONSTRAINT_CATALOG = ReferencedColumnUsage.CONSTRAINT_CATALOG AND ReferentialConstraints.UNIQUE_CONSTRAINT_SCHEMA = ReferencedColumnUsage.CONSTRAINT_SCHEMA AND ReferentialConstraints.UNIQUE_CONSTRAINT_NAME = ReferencedColumnUsage.CONSTRAINT_NAME AND ReferencingColumnUsage.ORDINAL_POSITION = ReferencedColumnUsage.ORDINAL_POSITION WHERE ReferencingColumnUsage.TABLE_SCHEMA IN (@schemaName0, @schemaName1, @schemaName2) AND ReferencingColumnUsage.TABLE_NAME IN (@tableName0, @tableName1, @tableName2) dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0] Logging primary key information for entity: Category. dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0] Primary key column name: CategoryID Primary key mapped name: CategoryID Type: Int32 IsNullable: False IsAutoGenerated: True dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0] Logging primary key information for entity: Product. dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0] Primary key column name: ProductID Primary key mapped name: id Type: Int32 IsNullable: False IsAutoGenerated: True dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0] Logging primary key information for entity: ProductCatalog. dbug: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0] Primary key column name: ProductID Primary key mapped name: ProductID Type: Int32 IsNullable: False IsAutoGenerated: False dbug: Azure.DataApiBuilder.Core.Configurations.RuntimeConfigValidator[0] Category: dbo.Categories(CategoryID) is related to many Product: dbo.Products(CategoryID). dbug: Azure.DataApiBuilder.Core.Configurations.RuntimeConfigValidator[0] Product: dbo.Products(CategoryID) is related to one Category: dbo.Categories(CategoryID). info: Azure.DataApiBuilder.Service.Startup[0] Successfully completed runtime initialization. dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ModelBinderFactory[12] Registered model binder providers, in the following order: Microsoft.AspNetCore.Mvc.ModelBinding.Binders.BinderTypeModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.ServicesModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.BodyModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.HeaderModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.FloatingPointTypeModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.EnumTypeModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.DateTimeModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.SimpleTypeModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.TryParseModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.CancellationTokenModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.ByteArrayModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.FormFileModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.FormCollectionModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.KeyValuePairModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.DictionaryModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.ArrayModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.CollectionModelBinderProvider, Microsoft.AspNetCore.Mvc.ModelBinding.Binders.ComplexObjectModelBinderProvider dbug: Microsoft.AspNetCore.Server.Kestrel[0] No listening endpoints were configured. Binding to http://localhost:5000 by default. info: Microsoft.Hosting.Lifetime[14] Now listening on: http://localhost:5000 dbug: Microsoft.AspNetCore.Hosting.Diagnostics[13] Loaded hosting startup assembly Azure.DataApiBuilder.Service info: Microsoft.Hosting.Lifetime[0] Application started. Press Ctrl+C to shut down. info: Microsoft.Hosting.Lifetime[0] Hosting environment: Production info: Microsoft.Hosting.Lifetime[0] Content root path: C:\Users\Admin\product-catalog-api dbug: Microsoft.Extensions.Hosting.Internal.Host[2] Hosting started dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[39] Connection id "0HNMHOCHUODM7" accepted. dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[1] Connection id "0HNMHOCHUODM7" started. dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[39] Connection id "0HNMHOCHUODM8" accepted. dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[1] Connection id "0HNMHOCHUODM8" started. info: Microsoft.AspNetCore.Hosting.Diagnostics[1] Request starting HTTP/1.1 GET http://localhost:5000/api/Product - - - dbug: Microsoft.AspNetCore.HostFiltering.HostFilteringMiddleware[0] Wildcard detected, all requests with hosts will be allowed. warn: Microsoft.AspNetCore.HttpsPolicy.HttpsRedirectionMiddleware[3] Failed to determine the https port for redirect. dbug: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[3] The request path does not match the path filter dbug: Microsoft.AspNetCore.Routing.Matching.DfaMatcher[1001] 1 candidate(s) found for the request path '/api/Product' dbug: Microsoft.AspNetCore.Routing.Matching.DfaMatcher[1005] Endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' with route pattern '{*route}' is valid for the request path '/api/Product' dbug: Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware[1] Request matched endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.UnauthenticatedAuthentication.UnauthenticatedAuthenticationHandler[8] AuthenticationScheme: UnauthenticatedAuthentication was successfully authenticated. dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0] cf5d807b-4930-4cdf-a8c0-e4121ca4de69 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0] Executing endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[102] Route matched with {action = "Find", controller = "Rest"}. Executing controller action with signature System.Threading.Tasks.Task1[Microsoft.AspNetCore.Mvc.IActionResult] Find(System.String) on controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service). dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of authorization filters (in the following order): None dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of resource filters (in the following order): None dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of action filters (in the following order): Microsoft.AspNetCore.Mvc.ModelBinding.UnsupportedContentTypeFilter (Order: -3000), Microsoft.AspNetCore.Mvc.Infrastructure.ModelStateInvalidFilter (Order: -2000) dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of exception filters (in the following order): None dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of result filters (in the following order): Microsoft.AspNetCore.Mvc.Infrastructure.ClientErrorResultFilter (Order: -2000), Microsoft.AspNetCore.Mvc.ProducesAttribute (Order: 0) dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Executing controller factory for controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service) dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2] Executed controller factory for controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service) dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[22] Attempting to bind parameter 'route' of type 'System.String' ... dbug: Microsoft.AspNetCore.Mvc.ModelBinding.Binders.SimpleTypeModelBinder[44] Attempting to bind parameter 'route' of type 'System.String' using the name 'route' in request data ... dbug: Microsoft.AspNetCore.Mvc.ModelBinding.Binders.SimpleTypeModelBinder[45] Done attempting to bind parameter 'route' of type 'System.String'. dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[23] Done attempting to bind parameter 'route' of type 'System.String'. dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[26] Attempting to validate the bound parameter 'route' of type 'System.String' ... dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[27] Done attempting to validate the bound parameter 'route' of type 'System.String'. dbug: Microsoft.AspNetCore.Authorization.DefaultAuthorizationService[1] Authorization was successful. dbug: Microsoft.AspNetCore.Authorization.DefaultAuthorizationService[1] Authorization was successful. dbug: Azure.DataApiBuilder.Core.Resolvers.IQueryExecutor[0] cf5d807b-4930-4cdf-a8c0-e4121ca4de69 Executing query: SELECT TOP 101 [dbo_Products].[ProductID] AS [id], [dbo_Products].[ProductName] AS [name], [dbo_Products].[CategoryID] AS [CategoryID], [dbo_Products].[UnitPrice] AS [price], [dbo_Products].[UnitsInStock] AS [stockQuantity], [dbo_Products].[Discontinued] AS [isDiscontinued] FROM [dbo].[Products] AS [dbo_Products] WHERE 1 = 1 ORDER BY [dbo_Products].[ProductID] ASC FOR JSON PATH, INCLUDE_NULL_VALUES dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[11] List of registered output formatters, in the following order: Microsoft.AspNetCore.Mvc.Formatters.HttpNoContentOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.StringOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.StreamOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.SystemTextJsonOutputFormatter dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[4] No information found on request to perform content negotiation. dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[9] Attempting to select the first output formatter in the output formatters list which supports a content type from the explicitly specified content types 'application/json'. dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[2] Selected output formatter 'Microsoft.AspNetCore.Mvc.Formatters.SystemTextJsonOutputFormatter' and content type 'application/json' to write the response. info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1] Executing OkObjectResult, writing value of type '<>f__AnonymousType11[[System.Collections.Generic.List1[[System.Text.Json.JsonElement, System.Text.Json, Version=10.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51]], System.Private.CoreLib, Version=8.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. dbug: Microsoft.AspNetCore.ResponseCompression.ResponseCompressionProvider[8] The response will be compressed with 'gzip'. info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[105] Executed action Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service) in 1126.6159ms info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1] Executed endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[9] Connection id "0HNMHOCHUODM8" completed keep alive response. info: Microsoft.AspNetCore.Hosting.Diagnostics[2] Request finished HTTP/1.1 GET http://localhost:5000/api/Product - 200 - application/json;+charset=utf-8 4826.3308ms info: Microsoft.AspNetCore.Hosting.Diagnostics[1] Request starting HTTP/1.1 GET http://localhost:5000/favicon.ico - - - dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.ClientRoleHeaderAuthenticationMiddleware[0] bf37a04f-24ea-49e7-9567-34a7de36db25 AuthN state: Anonymous. Role: Anonymous. Scheme: UnauthenticatedAuthentication dbug: Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware[3] The request path does not match the path filter dbug: Microsoft.AspNetCore.Routing.Matching.DfaMatcher[1001] 1 candidate(s) found for the request path '/favicon.ico' dbug: Microsoft.AspNetCore.Routing.Matching.DfaMatcher[1005] Endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' with route pattern '{*route}' is valid for the request path '/favicon.ico' dbug: Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware[1] Request matched endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' dbug: Azure.DataApiBuilder.Core.AuthenticationHelpers.UnauthenticatedAuthentication.UnauthenticatedAuthenticationHandler[8] AuthenticationScheme: UnauthenticatedAuthentication was successfully authenticated. info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0] Executing endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[102] Route matched with {action = "Find", controller = "Rest"}. Executing controller action with signature System.Threading.Tasks.Task1[Microsoft.AspNetCore.Mvc.IActionResult] Find(System.String) on controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service). dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of authorization filters (in the following order): None dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of resource filters (in the following order): None dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of action filters (in the following order): Microsoft.AspNetCore.Mvc.ModelBinding.UnsupportedContentTypeFilter (Order: -3000), Microsoft.AspNetCore.Mvc.Infrastructure.ModelStateInvalidFilter (Order: -2000) dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of exception filters (in the following order): None dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Execution plan of result filters (in the following order): Microsoft.AspNetCore.Mvc.Infrastructure.ClientErrorResultFilter (Order: -2000), Microsoft.AspNetCore.Mvc.ProducesAttribute (Order: 0) dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[1] Executing controller factory for controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service) dbug: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2] Executed controller factory for controller Azure.DataApiBuilder.Service.Controllers.RestController (Azure.DataApiBuilder.Service) dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[22] Attempting to bind parameter 'route' of type 'System.String' ... dbug: Microsoft.AspNetCore.Mvc.ModelBinding.Binders.SimpleTypeModelBinder[44] Attempting to bind parameter 'route' of type 'System.String' using the name 'route' in request data ... dbug: Microsoft.AspNetCore.Mvc.ModelBinding.Binders.SimpleTypeModelBinder[45] Done attempting to bind parameter 'route' of type 'System.String'. dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[23] Done attempting to bind parameter 'route' of type 'System.String'. dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[26] Attempting to validate the bound parameter 'route' of type 'System.String' ... dbug: Microsoft.AspNetCore.Mvc.ModelBinding.ParameterBinder[27] Done attempting to validate the bound parameter 'route' of type 'System.String'. dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[11] List of registered output formatters, in the following order: Microsoft.AspNetCore.Mvc.Formatters.HttpNoContentOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.StringOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.StreamOutputFormatter, Microsoft.AspNetCore.Mvc.Formatters.SystemTextJsonOutputFormatter dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[4] No information found on request to perform content negotiation. dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[9] Attempting to select the first output formatter in the output formatters list which supports a content type from the explicitly specified content types 'application/json, application/problem+json, application/problem+xml'. dbug: Microsoft.AspNetCore.Mvc.Infrastructure.DefaultOutputFormatterSelector[2] Selected output formatter 'Microsoft.AspNetCore.Mvc.Formatters.SystemTextJsonOutputFormatter' and content type 'application/json' to write the response. info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1] Executing ObjectResult, writing value of type 'Microsoft.AspNetCore.Mvc.ProblemDetails'. dbug: Microsoft.AspNetCore.ResponseCompression.ResponseCompressionProvider[8] The response will be compressed with 'gzip'. info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[105] Executed action Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service) in 53.6376ms info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1] Executed endpoint 'Azure.DataApiBuilder.Service.Controllers.RestController.Find (Azure.DataApiBuilder.Service)' dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[9] Connection id "0HNMHOCHUODM8" completed keep alive response. info: Microsoft.AspNetCore.Hosting.Diagnostics[2] Request finished HTTP/1.1 GET http://localhost:5000/favicon.ico - 404 - application/json;+charset=utf-8 73.8352ms dbug: Microsoft.AspNetCore.Server.Kestrel.Transport.Sockets[6] Connection id "0HNMHOCHUODM7" received FIN. dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[10] Connection id "0HNMHOCHUODM7" disconnecting. dbug: Microsoft.AspNetCore.Server.Kestrel.Transport.Sockets[7] Connection id "0HNMHOCHUODM7" sending FIN because: "The Socket transport's send loop completed gracefully." dbug: Microsoft.AspNetCore.Server.Kestrel.Connections[2] Connection id "0HNMHOCHUODM7" stopped.