`Set-SqlDscDatabaseDefaultFullTextCatalog`: New command proposal

[coderabbitai]

Description

Add a new public command Set-SqlDscDatabaseDefaultFullTextCatalog to configure the default full-text catalog for a SQL Server database using the SMO SetDefaultFullTextCatalog() method.

Details

The DefaultFullTextCatalog property on the SMO Database class requires calling the SetDefaultFullTextCatalog() method rather than direct property assignment. This command should be implemented as a separate cmdlet following the pattern established by other method-based commands.

Proposed Implementation

• Command Name: Set-SqlDscDatabaseDefaultFullTextCatalog
• Parameter Sets:
  • ServerObject + Name (with optional Refresh)
  • DatabaseObject (accepting pipeline input)
• Required Parameters:
  • CatalogName: The name of the full-text catalog to set as default
• Optional Parameters:
  • Force: Bypass confirmation prompts
  • PassThru: Return the updated database object
• Behavior:
  • Support ShouldProcess for -WhatIf and -Confirm
  • Call $databaseObject.SetDefaultFullTextCatalog($CatalogName) on the SMO Database object
  • Include proper parameter validation and error handling
  • Follow DSC Community PowerShell coding guidelines

Related Issues and PRs

• Related to issue Set-SqlDscDatabase: Add parameters to command #2177 (Expose settable SMO Database properties)
• Discovered in PR Set-SqlDscDatabaseProperty: Refactor command #2327 (Set-SqlDscDatabase refactoring)
• Comment: Set-SqlDscDatabaseProperty: Refactor command #2327 (comment)

References

• SMO Documentation: Database.SetDefaultFullTextCatalog Method

[github-actions]

This issue has been automatically marked as stale because it has not had activity from the community in the last 30 days. It will be closed if no further activity occurs within 40 days. If the issue is labelled with any of the work labels (e.g bug, enhancement, documentation, or tests) then the issue will not auto-close.

[johlju]

This it proposed in PR #2352 but there is an issue with the command in the integration test, something is missing that I do not understand. Happy if someone in the community can help, that knows what missing or knows a better approach.