[BUG] Using Azure.Provisioning.Sql.SqlServerAzureADAdministrator throws exception

[eerhardt]

Library name and version

Azure.Provisioning.Sql 1.0.0

Describe the bug

When trying to use the

azure-sdk-for-net/sdk/provisioning/Azure.Provisioning.Sql/src/Generated/SqlServerAzureADAdministrator.cs

Line 18 in f01e2fe

public partial class SqlServerAzureADAdministrator : ProvisionableResource

class in any meaningful way, it throws an exceptoin.

Expected behavior

Valid bicep should be produced.

Actual behavior

Unhandled exception. System.InvalidOperationException: Cannot assign to output value Name
   at Azure.Provisioning.BicepValue.Assign(IBicepValue source)
   at Azure.Provisioning.BicepValue`1.Assign(IBicepValue source)
   at Azure.Provisioning.BicepValue`1.Assign(BicepValue`1 source)
   at Azure.Provisioning.Primitives.ProvisionableConstruct.DefineProperty[T](String propertyName, String[] bicepPath, Boolean isOutput, Boolean isRequired, Boolean isSecure, BicepValue`1 defaultValue, String format)
   at Azure.Provisioning.Sql.SqlServerAzureADAdministrator.DefineProvisionableProperties()
   at Azure.Provisioning.Primitives.ProvisionableConstruct.Initialize()
   at Azure.Provisioning.Sql.SqlServerAzureADAdministrator.set_Parent(SqlServer value)
   at Program.<Main>$(String[] args) in D:\source\AspireApp6\AspireApp6.AppHost\Program.cs:line 17

Reproduction Steps

Run the following program:

using Azure.Provisioning;
using Azure.Provisioning.Sql;

var infra = new Infrastructure();

var principalIdParameter = new ProvisioningParameter("principalId", typeof(string));
infra.Add(principalIdParameter);
var principalNameParameter = new ProvisioningParameter("principalName", typeof(string));
infra.Add(principalNameParameter);

var sql = SqlServer.FromExisting("sql");
sql.Name = "sql1-yfs36ajays";
infra.Add(sql);

var admin = new SqlServerAzureADAdministrator($"{sql.BicepIdentifier}_admin");
admin.Parent = sql;
admin.Login = principalNameParameter;
admin.Sid = principalIdParameter;
infra.Add(admin);

Environment

❯ dotnet --info
.NET SDK:
Version: 9.0.200
Commit: 90e8b202f2
Workload version: 9.0.200-manifests.b6391994
MSBuild version: 17.13.8+cbc39bea8

Runtime Environment:
OS Name: Windows
OS Version: 10.0.26100
OS Platform: Windows
RID: win-x64
Base Path: C:\Program Files\dotnet\sdk\9.0.200\

cc @tg-msft @captainsafia

[github-actions]

Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @azureSQLGitHub.

[eerhardt]

I'm unsure if this is related (or possibly the same?) bug as [BUG] CosmosDBSqlRoleAssignment doesn't support setting name property (Azure/azure-sdk-for-net#47979). Both issues involve the "Name" property being isOutput: true incorrectly.

[jsquire]

//cc: @m-nash, @ArthurMa1978