[Repo Assist] Monthly Activity 2026-03

[github-actions]

🤖 Repo Assist here — I'm an automated AI assistant for this repository.

Activity for March 2026

Suggested Actions for Maintainer

Comprehensive list of all pending actions requiring maintainer attention:

• Review PR (new, branch repo-assist/fix-issue-272-bulkcopy-computed-columns): fix: exclude computed columns from BulkCopy column mappings (Closes SqlProgrammability provider fails to update/bulk copy into tables with computed persistent columns #272) — Branch
• Review PR [Repo Assist] fix: resolve FSharp.Core version mismatch in item type resolution (Closes #433) #471: fix: resolve FSharp.Core version mismatch in item type resolution (Closes dotnet SDK projects using FSharp.Core version 7.0.0 breaks at runtime #433) — Review
• Review PR [Repo Assist] improve: replace silent assert with descriptive error in QuotationsFactory.GetBody; remove dead assert in MapArrayNullableItems #470: improve: replace silent assert with descriptive error in QuotationsFactory.GetBody — Review
• Review PR [Repo Assist] feat: add appsettings.json support to DesignTimeConnectionString (Closes #370) #468: feat: add appsettings.json support to DesignTimeConnectionString (Closes Add support working with appsettings.json in Asp.Net Core 2.x and above #370) — Review
• Review PR [Repo Assist] fix: activate empty-string guard in DesignTimeConnectionString.Parse; add parse edge-case tests #466: fix: activate empty-string guard in DesignTimeConnectionString.Parse; add parse edge-case tests — Review
• Review PR use appveyor vs2026 image. #465: use appveyor vs2026 image — Review
• Review PR [Repo Assist] fix: replace assertions with descriptive exceptions in findTypeInfoBySqlEngineTypeId #463: fix: replace assertions with descriptive exceptions in findTypeInfoBySqlEngineTypeId (Closes Assertion in findTypeInfoBySqlEngineTypeId #354) — Review
• Review PR [Repo Assist] fix: only exclude nullable columns from DataTable PK when they have a default constraint #462: fix: only exclude nullable columns from DataTable PK when they have a default constraint (Closes Multi column PK may result in System.Data.ConstraintException when PK is widened  #376) — Review
• Review PR [Repo Assist] chore: fix ToCommantText typo, simplify getSqlDbType, fix TempTableLoader.Close #459: chore: fix ToCommantText typo, simplify getSqlDbType, fix TempTableLoader.Close — Review
• Review PR [Repo Assist] test: expand DesignTimeConnectionStringTests and add net8.0 multi-targeting #455: test: expand DesignTimeConnectionStringTests and add net8.0 multi-targeting — Review
• Review PR [Repo Assist] perf: cache Type.GetType calls in VerifyResultsetColumns #454: perf: cache Type.GetType calls in VerifyResultsetColumns — Review
• Review PR [Repo Assist] fix: make connection parameter optional when literal connection string is configured (Closes #245) #452: fix: make connection optional when literal connection string configured (Closes SqlProgrammabilityProvider requires open SqlConnection #245) — Review
• Review PR [Repo Assist] improve: cache TVP reflection lookups in SetParameters #448: cache TVP reflection lookups in SetParameters — Review
• Review PR 🔧 Engineering overhaul: drop .NET Framework, migrate to .NET 9, add Fantomas #444: Engineering overhaul — drop .NET Framework, migrate to .NET 9, add Fantomas — Review
• Action needed [Repo Assist] ci: upgrade setup-dotnet to v4 and use 8.0.x version specifier #467: CI workflow patch (setup-dotnet v3→v4, 8.0.x) needs workflows write permission — human must apply manually — View
• Close issue [aw] Repo Assist failed #447: Workflow failure issue (expired Mar 15, 2026) — View
• Check comment SqlProgrammability provider fails to update/bulk copy into tables with computed persistent columns #272: Repo Assist traced root cause of BulkCopy computed column failure; fix PR submitted — View
• Check comment SQL LIKE operation doesn't recognize variable #437: Repo Assist provided concrete LIKE parameter workaround code example — View
• Check comment support asyncSeq or IAsyncEnumerator #15: Repo Assist noted IAsyncEnumerable(T) as the modern BCL approach for async streaming — View
• Check comment .NET 4.5 optimized version #16: Repo Assist noted .NET 4.5 async is now the baseline; issue effectively resolved — View
• Check comment Add AllParametersOption as safer alternative to AllParametersOptional #327: Repo Assist explained AllParametersOptional already gives safer required-but-option-typed behavior in current code — View
• Check comment Provide types with measures #65: Repo Assist explained existing units-of-measure support via (unitname) SQL type naming convention — View
• Check comment Switch to Microsoft.Data.SqlClient  #374: Repo Assist noted active Microsoft.Data.SqlClient migration progress (fork ready, 🔧 Engineering overhaul: drop .NET Framework, migrate to .NET 9, add Fantomas #444/Requirements going forward? #445 discussion) — View
• Check comment The azure database used on CI / unit tests is not there anymore #387: Repo Assist confirmed CI failures caused by missing AdventureWorks Person schema; docker CI from Requirements going forward? #445 is the fix — View
• Check comment Conversion failed when using User Defined Table Types #424: Repo Assist identified duplicate [C2] column in INSERT list as likely root cause — View
• Check comment SqlEnumProvider breaks VS 2019 #410: Repo Assist explained generative TP limitation and DbProviderFactories flag — View
• Check comment Multi column PK may result in System.Data.ConstraintException when PK is widened  #376: Repo Assist traced root cause; PR [Repo Assist] fix: only exclude nullable columns from DataTable PK when they have a default constraint #462 created — View
• Check comment Extremely long intellisense on errors #328: Repo Assist noted issue is stale; suggested closing — View
• Check comment Support for 'Active Directory Interactive' authentication #429: Repo Assist noted Microsoft.Data.SqlClient migration resolves AD Interactive auth — View
• Check comment Assertion in findTypeInfoBySqlEngineTypeId #354: Repo Assist explained cache invalidation race; PR [Repo Assist] fix: replace assertions with descriptive exceptions in findTypeInfoBySqlEngineTypeId #463 created — View
• Check comment Allow use pre-existing type for SqlCommandProvider #334: Repo Assist noted fslang-suggestions#212 status + unbox workaround — View
• Check comment Add support for netcore/netstandard based tooling (for example FAKE) #337: Repo Assist noted PR 🔧 Engineering overhaul: drop .NET Framework, migrate to .NET 9, add Fantomas #444 as path forward + DACFx standalone option — View
• Check comment Needs an AllParametersOptional on SqlProgrammabilityProvider or? #265: Repo Assist explained AllParametersOptional is available on CreateCommand — View
• Check comment cannot build netstandard2.0 project with the dotnet SDK build #366: Repo Assist noted workaround and long-term fix via PR 🔧 Engineering overhaul: drop .NET Framework, migrate to .NET 9, add Fantomas #444 — View
• Check comment Question: For what reason would a SPROC not have an available constructor? #368: Repo Assist explained AddMembersDelayed failure scenarios — View
• Check comment Include Task-based execution on SqlCommandProvider #371: Repo Assist noted FSharp.Core task CE approach — View
• Check comment Is it possible to turn off concurrency violation checking? #311: Repo Assist explained SqlCommandBuilder ConflictOption root cause — View
• Check comment SqlProgrammabilityProvider requires open SqlConnection #245: Repo Assist posted fix PR link (PR [Repo Assist] fix: make connection parameter optional when literal connection string is configured (Closes #245) #452) — View
• Check comment SqlProgrammabilityProvider generates wrong Execute method if SP has default to null output parameter #246: Repo Assist explained F# TP limitation for non-primitive output parameters — View
• Check comment Sql Errors not bubbling up - System.TypeInitializationException #268: Repo Assist explained TypeInitializationException wrapping root cause — View
• Check comment Must System.Configuration.ConfigurationManager be manually installed? #358: Repo Assist explained System.Configuration.ConfigurationManager NuGet requirement — View
• Check comment Could not load file or assembly System.Data.SqlClient if building using dotnet build #373: Repo Assist noted PR 🔧 Engineering overhaul: drop .NET Framework, migrate to .NET 9, add Fantomas #444 as fix path + current workaround — View
• Check comment Add SqlCommand.Table type for ResultType.DataReader and ExecuteReader for ResultType.DataTable #336: Repo Assist explained implementation approach for Table factory feature — View
• Check comment Build is broken without full VS installation #412: Repo Assist explained System.Runtime.Caching GAC issue — View
• Check comment Any 2023 tricks for running on Windows? #427: Repo Assist explained Windows sni.dll probing failure — View
• Check comment NullReferenceException in SqlConnection.UseLocally #428: Repo Assist noted NullReferenceException root cause in UseLocally — View
• Check comment dotnet SDK projects using FSharp.Core version 7.0.0 breaks at runtime #433: Repo Assist noted FSharp.Core version mismatch root cause; PR created — View
• Check comment Wrong inferred constraint on composite primary key with a default #283: Repo Assist noted wrong PK constraint for DEFAULT columns — View
• Check comment Microsoft.Data.SqlClient #441: Repo Assist technical analysis of TVP/UDTT SqlDataRecord fix — View
• Check comment Add support for NetTopologySuite #369: Repo Assist explained NetTopologySuite extension-point design needed — View
• Check comment Not platform detection Fable #411: Repo Assist explained Fable detection error is expected (not a SqlClient bug) — View
• Check comment Add support working with appsettings.json in Asp.Net Core 2.x and above #370: Repo Assist linked new appsettings.json PR ([Repo Assist] feat: add appsettings.json support to DesignTimeConnectionString (Closes #370) #468) — View
• Check comment Question: Creating a provider without an access to DB #409: Repo Assist summarised offline-schema options (LocalDB, DACPAC, generated types) — View
• Check comment ExecuteNonQuery requires an open and available connection #306: Repo Assist noted LoadTempTables connection issue root cause — View
• Check comment Fixed length binary columns in user defined table types fail when constructed #413: Repo Assist noted fix was shipped in 2.1.1, suggested closing — View
• Check comment Option not inferred for optional sproc parameters of type binary and nvarchar #377: Repo Assist explained Optional wrapping is value-type only — View
• Check comment SqlProgrammabilityProvider design-time: "The given key was not present in the dictionary" and then "No constructors are available" the first time an sproc is used until project reload #379: Repo Assist explained design-time race condition root cause — View

Future Work for Repo Assist

• Continue commenting on older unaddressed issues (Generated types SqlCommand type provider. Records only. #162, Metadata from SqlCommandProvider #188 and others)
• Note: CI workflow upgrades require workflows write permission — Repo Assist cannot push these directly (see [Repo Assist] ci: upgrade setup-dotnet to v4 and use 8.0.x version specifier #467)

Run History

2026-03-15 07:15 UTC — Run

• 🔧 Created PR (branch repo-assist/fix-issue-272-bulkcopy-computed-columns): fix: exclude computed columns from BulkCopy column mappings (Closes SqlProgrammability provider fails to update/bulk copy into tables with computed persistent columns #272)
• 💬 Commented on SqlProgrammability provider fails to update/bulk copy into tables with computed persistent columns #272: traced root cause (ReadOnly DataColumn flag already set from is_computed), linked fix PR
• 💬 Commented on SQL LIKE operation doesn't recognize variable #437: provided concrete code example for the LIKE parameter workaround

2026-03-15 01:24 UTC — Run

• 🔧 Created PR [Repo Assist] fix: resolve FSharp.Core version mismatch in item type resolution (Closes #433) #471 (branch repo-assist/fix-issue-433-fsharpcore-version): fix: resolve FSharp.Core version mismatch in item type resolution (Closes dotnet SDK projects using FSharp.Core version 7.0.0 breaks at runtime #433)
• 💬 Commented on support asyncSeq or IAsyncEnumerator #15: noted IAsyncEnumerable(T) as the modern BCL approach for async streaming
• 💬 Commented on .NET 4.5 optimized version #16: noted .NET 4.5 async is now the baseline; issue effectively resolved

2026-03-14 19:06 UTC — Run

• 🔧 Created PR [Repo Assist] improve: replace silent assert with descriptive error in QuotationsFactory.GetBody; remove dead assert in MapArrayNullableItems #470 (branch repo-assist/improve-quotations-factory-errors-20260314): replace silent assert with descriptive error in QuotationsFactory.GetBody; remove dead assert in MapArrayNullableItems
• 💬 Commented on Add AllParametersOption as safer alternative to AllParametersOptional #327: explained AllParametersOptional already gives required-but-option-typed (safe) behavior in current code
• 💬 Commented on Provide types with measures #65: explained existing units-of-measure support via (unitname) SQL type naming convention

2026-03-14 13:16 UTC — Run

• 💬 Commented on Switch to Microsoft.Data.SqlClient  #374: noted active Microsoft.Data.SqlClient migration progress (fork FSharp.Data.MicrosoftSqlClient ready, 🔧 Engineering overhaul: drop .NET Framework, migrate to .NET 9, add Fantomas #444/Requirements going forward? #445 discussion)
• 🔧 Attempted CI upgrade PR: setup-dotnet v3→v4 and 8.0.x patch channel (may require human action due to workflows permission)

2026-03-14 07:10 UTC — Run

• 🔧 Created PR [Repo Assist] feat: add appsettings.json support to DesignTimeConnectionString (Closes #370) #468: feat: add appsettings.json support to DesignTimeConnectionString (Closes Add support working with appsettings.json in Asp.Net Core 2.x and above #370)
• 💬 Commented on Add support working with appsettings.json in Asp.Net Core 2.x and above #370: linked new appsettings.json PR and explained design-time-only limitation
• 💬 Commented on Question: Creating a provider without an access to DB #409: summarised offline-schema options (LocalDB SSDT, DACPAC, generated types, metadata caching)

2026-03-14 01:24 UTC — Run

• 🔧 Attempted CI upgrade PR → failed due to workflows permission; issue [Repo Assist] ci: upgrade setup-dotnet to v4 and use 8.0.x version specifier #467 created with manual patch instructions
• 💬 Commented on Add support for NetTopologySuite #369: explained NetTopologySuite integration requires custom CLR-type mapping extension point
• 💬 Commented on Not platform detection Fable #411: explained Fable detection error is expected — SqlClient is server-side only

2026-03-13 19:08 UTC — Run

• 🔧 Created PR [Repo Assist] fix: activate empty-string guard in DesignTimeConnectionString.Parse; add parse edge-case tests #466: fix: activate empty-string guard in DesignTimeConnectionString.Parse; add parse edge-case tests

2026-03-13 13:21 UTC — Run

• 💬 Commented on The azure database used on CI / unit tests is not there anymore #387: confirmed current CI failures are caused by missing AdventureWorks Person schema; docker-based CI from Requirements going forward? #445 is the fix path
• 📋 Task 6: all Repo Assist PRs have infrastructure-only CI failures (no code changes needed)

2026-03-13 07:14 UTC — Run

• 🔧 Pushed net8.0 CI fix to PR [Repo Assist] fix: only exclude nullable columns from DataTable PK when they have a default constraint #462 and PR [Repo Assist] fix: replace assertions with descriptive exceptions in findTypeInfoBySqlEngineTypeId #463
• 🔧 Created PR [Repo Assist] fix: correct SqlMetaData constructor selection for datetime2/datetimeoffset/time TVP columns #464: fix: correct SqlMetaData constructor selection for datetime2/datetimeoffset/time TVP columns (Closes Lots of ArgumentException in 2.0.7: "Metadata for field 'FieldName' of record '2' did not match the original record's metadata" #393)
• 💬 Commented on Lots of ArgumentException in 2.0.7: "Metadata for field 'FieldName' of record '2' did not match the original record's metadata" #393

2026-03-13 01:24 UTC — Run

• 💬 Commented on Conversion failed when using User Defined Table Types #424, SqlEnumProvider breaks VS 2019 #410
• 🔧 Created PR [Repo Assist] fix: replace assertions with descriptive exceptions in findTypeInfoBySqlEngineTypeId #463: fix: replace assertions with descriptive exceptions in findTypeInfoBySqlEngineTypeId (Closes #354)

2026-03-12 19:14 UTC — Run

• 🔧 Created PR [Repo Assist] fix: only exclude nullable columns from DataTable PK when they have a default constraint #462: fix: only exclude nullable columns from DataTable PK when they have a default constraint (Closes #376)
• 💬 Commented on Multi column PK may result in System.Data.ConstraintException when PK is widened  #376, Extremely long intellisense on errors #328

2026-03-12 13:21 UTC — Run

• 💬 Commented on Support for 'Active Directory Interactive' authentication #429
• 🔧 Created PR [Repo Assist] ci: update FAKE build script target from net6.0 to net8.0 #461: ci: update FAKE build script from net6.0→net8.0

2026-03-12 07:16 UTC — Run

• 💬 Commented on Question: For what reason would a SPROC not have an available constructor? #368, Any 2023 tricks for running on Windows? #427

2026-03-12 01:24 UTC — Run

• 🔧 Created PR [Repo Assist] fix: improve error when Microsoft.SqlServer.Types assembly is missing #460: fix: improve error when Microsoft.SqlServer.Types assembly is missing (Closes #264)
• 💬 Commented on Improve error if SQL Types dependency is missing #264, Add support for netcore/netstandard based tooling (for example FAKE) #337, Allow use pre-existing type for SqlCommandProvider #334

2026-03-11 19:14 UTC — Run

• 🔧 Created PR [Repo Assist] chore: fix ToCommantText typo, simplify getSqlDbType, fix TempTableLoader.Close #459: chore: fix ToCommantText typo, simplify getSqlDbType, fix TempTableLoader.Close
• 💬 Commented on Needs an AllParametersOptional on SqlProgrammabilityProvider or? #265

2026-03-11 13:22 UTC — Run

• 🔧 Extended PR [Repo Assist] perf: cache Type.GetType calls in VerifyResultsetColumns #454: added TypeInfo.ClrType cache
• 💬 Commented on cannot build netstandard2.0 project with the dotnet SDK build #366, Include Task-based execution on SqlCommandProvider #371

2026-03-11 01:24 UTC — Run

• 💬 Commented on Is it possible to turn off concurrency violation checking? #311

2026-03-10 and earlier

• 💬 Commented on many issues including ExecuteNonQuery requires an open and available connection #306, Option not inferred for optional sproc parameters of type binary and nvarchar #377, SqlProgrammabilityProvider design-time: "The given key was not present in the dictionary" and then "No constructors are available" the first time an sproc is used until project reload #379, Must System.Configuration.ConfigurationManager be manually installed? #358, Could not load file or assembly System.Data.SqlClient if building using dotnet build #373, Add SqlCommand.Table type for ResultType.DataReader and ExecuteReader for ResultType.DataTable #336, Build is broken without full VS installation #412, Microsoft.Data.SqlClient #441, NullReferenceException in SqlConnection.UseLocally #428, dotnet SDK projects using FSharp.Core version 7.0.0 breaks at runtime #433, Wrong inferred constraint on composite primary key with a default #283, SqlProgrammability provider fails to update/bulk copy into tables with computed persistent columns #272, SqlProgrammabilityProvider requires open SqlConnection #245, SqlProgrammabilityProvider generates wrong Execute method if SP has default to null output parameter #246, Sql Errors not bubbling up - System.TypeInitializationException #268, Assertion in findTypeInfoBySqlEngineTypeId #354, docs of SqlCommandProvider is missing info on TempTableDefinitions and TableVarMapping #350, Provide types with measures #65, Add AllParametersOption as safer alternative to AllParametersOptional #327 and others
• 🔧 Created PRs [Repo Assist] improve: cache TVP reflection lookups in SetParameters #448, [Repo Assist] docs: document TempTableDefinitions and TableVarMapping parameters #450, [Repo Assist] fix: make connection parameter optional when literal connection string is configured (Closes #245) #452, [Repo Assist] perf: cache Type.GetType calls in VerifyResultsetColumns #454, [Repo Assist] test: expand DesignTimeConnectionStringTests and add net8.0 multi-targeting #455, [Repo Assist] chore: minor code clarity improvements #456, [Repo Assist] docs: fix broken tool links in website navigation template #457, [Repo Assist] ci: update setup-dotnet v3→v4 and use 8.0.x patch channel #458, [Repo Assist] chore: fix ToCommantText typo, simplify getSqlDbType, fix TempTableLoader.Close #459, [Repo Assist] fix: improve error when Microsoft.SqlServer.Types assembly is missing #460
• 🏷️ Labelled 29 previously-unlabelled issues

Generated by Repo Assist · ◷

To install this agentic workflow, run

gh aw add githubnext/agentics/workflows/repo-assist.md@346204513ecfa08b81566450d7d599556807389f