1.1.7: Data API builder for Azure Databases

What's Changed

New Features

• Multiple db support for REST scenario #2169
• .NET 8 multi-targetting #2181
• GraphQL Multiple Create for MSSQL #2122
  • Request Validation #2057
  • Order determination for create mutations #2056
  • Database query generation and GraphQL selection set resolution #1994
• Pagination limits with config properties default-page-size and max-page-size #2153
• Root / endpoint returns DAB Version/App User Agent #2086
• PostgreSQL: Supplement application name in connection string #2208
• Cosmos DB: Patch Support (via new patchEntity mutation) #2161
• Cosmos DB: Item Level AuthZ enabled by database policies #2106
• Cosmos DB: Adding In-Memory cache support #2015

New Config Validation

• Validation for relationship defined fields #2139
  • {source/target}
  • {source/linking-source}
  • {target/linking-target}
• CosmosDB circular reference validation for entities in GraphQL schema #2192
• Validation against unsupported scenario: multiple create on related entities backed by same database table #2189

Bug Fixes

• dab validate now properly resolves environment variables in dab-config.json #2215

• dab validate Returns proper error message when validations can't proceed due to invalid/no connection string. #2202

• dab validate Relationships must define source/target/linking fields using table column names (not field aliases) #2175

• dab validate Fix dataSourceName not found exception #2040

• dab validate Fix error fetching schema from URL error emitted #2099

• GraphQL - Entities with self-joining relationships get expected query responses #2138

• GraphQL - Coerce integer values to float/decimal for float/decimal fields in GraphQL requests #2205

• GraphQL - Ensure endCursor is NULL when hasNextPage is FALSE in response #2121

• Cosmos DB: Emit user-readable error message when user provided GraphQL schema (schema.gql) references an entity not defined in dab-config.json #2186

• Cosmos DB: DAB no longer emits an OpenAPI init error message in the console when DAB is configured to use CosmosDB #2072

• DAB CLI - Returns appropriate exit code based upon exit reason #2084

• DAB CLI - dab start --help loglevel link is now user-readable #2083

• Container App Deployment - Upgraded containerApp API version so deployments no longer throw WorkloadProfilePropertyNotSupportedInApiVersion #2114

• Relationship Config Processing - No longer hangs nor throws unhandled exception when a table definition is not found in the database #2100

• Fix Performance Issue for filtering on varchar columns in MS_SQL database #2052

• Updating order of variable evaluation in Multiple create order helper #2195

• Ensure environment variables works for child files #2201

• Correctly resolve uniqueidentifier database type from dab-config.json defined stored proc parameter default values instead of erroring out. #2042

• DAB correctly handles tables with the same name, in different schemas #1990

• No longer adds redundant join condition to some t-sql queries generated when traversing a relationship in GraphQL #2051

Engineering Maintenance

• Update Npgsql to 7.0.7 for .NET6 #2214
• Update Npgsql to 8.0.3 for .NET8 #2207
• Set DAB version to 1.1 in directory.build.props #2209
• GitHub Codespaces support for Pull Request review (.NET6 SDK included in image) #2149

Documentation

• Updates support.md page #2216

See More (non-user facing changes)

MSSQL Engineering Fundamentals

• Perform recursive authz and request validation only when multiple-create is enabled #2199
• DatabaseObject Serialization now simplifies value of type name #2154
• Update notice-generation.ps1 to reference latest dependency versions #2151
• Maintain Default Data Source Name from Original Config after Hot Reloading #2069
• Only instantiate the file watcher in a hot reloadable scenario #2108

DW

• Introduce new metadata provider initialize method #2101
• Multi-DB: Making datasourcename mandatory during executequeryasync #2112
• executionHelper access modifer set to public #2102
• Stored proc support test cases REST DW. #2048
• Fixing nit comments from previous DW mutation support prs. #2043

CosmosDB - Engineering Fundamentals

• Cosmos DB: refactoring tests queries #2060
• Cosmos DB: Added Authorization related tests #2034
• Cosmos DB: Upgrade Cosmos DB SDK to latest version i.e. 3.38.1 #2073