Scaffolding fails when a column exists with a default constraint name and a value equal to the CLR default

[vasquezjames]

Bug description

I'm using .NET 10.0.0-preview.7.25380.108 to use the command dotnet ef dbcontext scaffold to get the schema of some tables, but I'm getting the error: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.EntityFrameworkCore.SqlServer.Design.Internal.SqlServerAnnotationCodeGenerator.GenerateFluentApiCalls(IProperty property, IDictionary`2 annotations)

The same command work fine with .NET 9.0.7

Your code

I'm usign the following command in power shell:

PS C:\Users\jvasquez\source\repos\cmdContabiliza4\cmdContabiliza4> dotnet ef dbcontext scaffold --force --no-pluralize --use-database-names "Server=SERVIDOR;Database=nts_tarjcred;User Id=sa;Password=xxxxxx;Persist Security Info=False;Trust Server Certificate=true" Microsoft.EntityFrameworkCore.SqlServer -o nts_tarjcred -t tc_maestro -t tc_maestro_saldos -t tc_tdiferidos -t tc_bines -t tc_comercios -t tc_tarjetas -t tc_ttdiferidos -t tc_empresa -t tc_ptipoplasticos -t tc_binafinidadsub -t tc_ptipoconfig -t tc_ttipoconfig -t tc_binafinidad -t tc_tciclofactura -t tc_tciclofacturactual -t tc_ttipotrxrazon -t tc_negociadores -t tc_transacciones -t tc_tprocesotipotrx --verbose

Stack traces

System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.EntityFrameworkCore.SqlServer.Design.Internal.SqlServerAnnotationCodeGenerator.GenerateFluentApiCalls(IProperty property, IDictionary`2 annotations)
   at Microsoft.EntityFrameworkCore.Design.IAnnotationCodeGenerator.GenerateFluentApiCallsInternal(IAnnotatable annotatable, IDictionary`2 annotations)
   at Microsoft.EntityFrameworkCore.Design.AnnotationCodeGenerator.GenerateFluentApiCalls(IAnnotatable annotatable, IDictionary`2 annotations)
   at Microsoft.EntityFrameworkCore.ScaffoldingModelExtensions.GenerateAnnotations(IAnnotatable annotatable, Dictionary`2 annotations, IAnnotationCodeGenerator annotationCodeGenerator, Boolean isHandledByDataAnnotations)
   at Microsoft.EntityFrameworkCore.ScaffoldingModelExtensions.GetFluentApiCalls(IProperty property, IAnnotationCodeGenerator annotationCodeGenerator)
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.CSharpDbContextGenerator.TransformText()
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.CSharpModelGenerator.ProcessTemplate(ITextTransformation transformation)
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.CSharpModelGenerator.GenerateModel(IModel model, ModelCodeGenerationOptions options)
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.ReverseEngineerScaffolder.ScaffoldModel(String connectionString, DatabaseModelFactoryOptions databaseOptions, ModelReverseEngineerOptions modelOptions, ModelCodeGenerationOptions codeOptions)
   at Microsoft.EntityFrameworkCore.Design.Internal.DatabaseOperations.ScaffoldContext(String provider, String connectionString, String outputDir, String outputContextDir, String dbContextClassName, IEnumerable`1 schemas, IEnumerable`1 tables, String modelNamespace, String contextNamespace, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames, Boolean suppressOnConfiguring, Boolean noPluralize)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContextImpl(String provider, String connectionString, String outputDir, String outputDbContextDir, String dbContextClassName, IEnumerable`1 schemaFilters, IEnumerable`1 tableFilters, String modelNamespace, String contextNamespace, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames, Boolean suppressOnConfiguring, Boolean noPluralize)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContext.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
Object reference not set to an instance of an object.
PS C:\Users\jvasquez\source\repos\cmdContabiliza4\cmdContabiliza4>

Verbose output

Found primary key on table 'PK_tc_empresa' with name 'dbo.tc_empresa'.
Found primary key on table 'PK_tc_maestro' with name 'dbo.tc_maestro'.
Found index on table 'IX_tc_maestro' with name 'dbo.tc_maestro', is unique: False.
Found index on table 'IX_tc_maestro_01' with name 'dbo.tc_maestro', is unique: False.
Found index on table 'IX_tc_maestro_02' with name 'dbo.tc_maestro', is unique: False.
Found index on table 'IX_tc_maestro_03' with name 'dbo.tc_maestro', is unique: False.
Found index on table 'IX_tc_maestro_04' with name 'dbo.tc_maestro', is unique: False.
Found primary key on table 'PK_tc_maestro_saldos' with name 'dbo.tc_maestro_saldos'.
Found index on table 'IX_tc_maestro_saldos_02' with name 'dbo.tc_maestro_saldos', is unique: False.
Found index on table 'IX_tc_maestro_saldos_03' with name 'dbo.tc_maestro_saldos', is unique: False.
Found index on table 'IX_tc_maestro_saldos_04' with name 'dbo.tc_maestro_saldos', is unique: False.
Found index on table 'IX_tc_maestro_saldos_05' with name 'dbo.tc_maestro_saldos', is unique: False.
Found index on table 'tc_maestro_saldos_01' with name 'dbo.tc_maestro_saldos', is unique: False.
Found primary key on table 'PK_tc_negociadores' with name 'dbo.tc_negociadores'.
Found index on table 'IX_tc_negociadores' with name 'dbo.tc_negociadores', is unique: False.
Found index on table 'IX_tc_negociadores03' with name 'dbo.tc_negociadores', is unique: False.
Found primary key on table 'PK_tc_ptipoconfig' with name 'dbo.tc_ptipoconfig'.
Found primary key on table 'PK_tc_ptipoplasticos' with name 'dbo.tc_ptipoplasticos'.
Found primary key on table 'PK_tc_tarjetas' with name 'dbo.tc_tarjetas'.
Found index on table 'IX_tc_tarjetas_1' with name 'dbo.tc_tarjetas', is unique: False.
Found index on table 'IX_tc_tarjetas_2' with name 'dbo.tc_tarjetas', is unique: False.
Found index on table 'IX_tc_tarjetas_3' with name 'dbo.tc_tarjetas', is unique: False.
Found primary key on table 'PK_tc_tciclofactura' with name 'dbo.tc_tciclofactura'.
Found index on table 'tc_tciclofactura_01' with name 'dbo.tc_tciclofactura', is unique: False.
Found primary key on table 'PK_tc_tciclofacturactual' with name 'dbo.tc_tciclofacturactual'.
Found primary key on table 'PK_tc_tdiferidos' with name 'dbo.tc_tdiferidos'.
Found index on table 'ix1' with name 'dbo.tc_tdiferidos', is unique: False.
Found index on table 'ix2' with name 'dbo.tc_tdiferidos', is unique: False.
Found index on table 'ix3' with name 'dbo.tc_tdiferidos', is unique: False.
Found index on table 'ix4' with name 'dbo.tc_tdiferidos', is unique: False.
Found index on table 'ix5' with name 'dbo.tc_tdiferidos', is unique: False.
Found primary key on table 'PK_tc_tprocesotipotrx' with name 'dbo.tc_tprocesotipotrx'.
Found index on table 'IX_tc_tprocesotipotrx_01' with name 'dbo.tc_tprocesotipotrx', is unique: False.
Found primary key on table 'PK_tc_transacciones' with name 'dbo.tc_transacciones'.
Found index on table 'ix1' with name 'dbo.tc_transacciones', is unique: False.
Found index on table 'ix2' with name 'dbo.tc_transacciones', is unique: False.
Found index on table 'ix3' with name 'dbo.tc_transacciones', is unique: False.
Found index on table 'ix4' with name 'dbo.tc_transacciones', is unique: False.
Found index on table 'ix5' with name 'dbo.tc_transacciones', is unique: False.
Found index on table 'Ix6' with name 'dbo.tc_transacciones', is unique: False.
Found primary key on table 'PK_tc_ttdiferidos' with name 'dbo.tc_ttdiferidos'.
Found primary key on table 'PK_tc_ttipoconfig' with name 'dbo.tc_ttipoconfig'.
Found primary key on table 'PK_tc_ttipotrxrazon' with name 'dbo.tc_ttipotrxrazon'.
Found index on table 'IX_tc_ttipotrxrazon_01' with name 'dbo.tc_ttipotrxrazon', is unique: False.
Found foreign key on table 'FK_tc_binafinidad_tc_tciclofacturactual' with name 'dbo.tc_binafinidad', principal table 'dbo.tc_tciclofacturactual', delete action NO_ACTION.
Found foreign key on table 'FK_tc_binafinidadsub_tc_binafinidad' with name 'dbo.tc_binafinidadsub', principal table 'dbo.tc_binafinidad', delete action NO_ACTION.
Found foreign key on table 'FK_tc_binafinidadsub_tc_ptipoplasticos' with name 'dbo.tc_binafinidadsub', principal table 'dbo.tc_ptipoplasticos', delete action NO_ACTION.
Found foreign key on table 'FK_tc_bines_tc_binesfuente' with name 'dbo.tc_bines', principal table 'dbo.tc_bines', delete action NO_ACTION.
Found foreign key on table 'FK_tc_bines_tc_binesintercambio' with name 'dbo.tc_bines', principal table 'dbo.tc_bines', delete action NO_ACTION.
Found foreign key on table 'FK_tc_bines_tc_empresa' with name 'dbo.tc_bines', principal table 'dbo.tc_empresa', delete action NO_ACTION.
Found foreign key on table 'FK_tc_empresa_tc_empresaadq' with name 'dbo.tc_empresa', principal table 'dbo.tc_empresa', delete action NO_ACTION.
Found foreign key on table 'FK_tc_empresa_tc_ttipoconfig' with name 'dbo.tc_empresa', principal table 'dbo.tc_ttipoconfig', delete action NO_ACTION.
Found foreign key on table 'FK_tc_maestro_saldos_tc_maestro' with name 'dbo.tc_maestro_saldos', principal table 'dbo.tc_maestro', delete action NO_ACTION.
Found foreign key on table 'FK_tc_negociadores_tc_empresa' with name 'dbo.tc_negociadores', principal table 'dbo.tc_empresa', delete action NO_ACTION.
Found foreign key on table 'FK_tc_ptipoplasticos_tc_ptipoconfig1' with name 'dbo.tc_ptipoplasticos', principal table 'dbo.tc_ptipoconfig', delete action NO_ACTION.
Found foreign key on table 'FK_tc_tarjetas_tc_binafinidadsub' with name 'dbo.tc_tarjetas', principal table 'dbo.tc_binafinidadsub', delete action NO_ACTION.
Found foreign key on table 'FK_tc_tarjetas_tc_maestro' with name 'dbo.tc_tarjetas', principal table 'dbo.tc_maestro', delete action NO_ACTION.
Found foreign key on table 'FK_tc_tciclofactura_tc_tciclofacturactual' with name 'dbo.tc_tciclofactura', principal table 'dbo.tc_tciclofacturactual', delete action NO_ACTION.
Found foreign key on table 'FK_tc_tciclofacturactual_tc_empresa' with name 'dbo.tc_tciclofacturactual', principal table 'dbo.tc_empresa', delete action NO_ACTION.
Found foreign key on table 'FK_tc_tdiferidos_tc_comercios' with name 'dbo.tc_tdiferidos', principal table 'dbo.tc_comercios', delete action NO_ACTION.
Found foreign key on table 'FK_tc_tdiferidos_tc_maestro_saldos' with name 'dbo.tc_tdiferidos', principal table 'dbo.tc_maestro_saldos', delete action NO_ACTION.
Found foreign key on table 'FK_tc_tdiferidos_tc_tarjetas' with name 'dbo.tc_tdiferidos', principal table 'dbo.tc_tarjetas', delete action NO_ACTION.
Found foreign key on table 'FK_tc_tdiferidos_tc_ttdiferidos' with name 'dbo.tc_tdiferidos', principal table 'dbo.tc_ttdiferidos', delete action NO_ACTION.
Found foreign key on table 'FK_tc_tprocesotipotrx_tc_ttipotrxrazon1' with name 'dbo.tc_tprocesotipotrx', principal table 'dbo.tc_ttipotrxrazon', delete action NO_ACTION.
Found foreign key on table 'FK_tc_transacciones_tc_comercios' with name 'dbo.tc_transacciones', principal table 'dbo.tc_comercios', delete action NO_ACTION.
Found foreign key on table 'FK_tc_transacciones_tc_maestro_saldos' with name 'dbo.tc_transacciones', principal table 'dbo.tc_maestro_saldos', delete action NO_ACTION.
Found foreign key on table 'FK_tc_transacciones_tc_negociadores' with name 'dbo.tc_transacciones', principal table 'dbo.tc_negociadores', delete action NO_ACTION.
Found foreign key on table 'FK_tc_transacciones_tc_tarjetas' with name 'dbo.tc_transacciones', principal table 'dbo.tc_tarjetas', delete action NO_ACTION.
Found foreign key on table 'FK_tc_transacciones_tc_ttdiferidos' with name 'dbo.tc_transacciones', principal table 'dbo.tc_ttdiferidos', delete action NO_ACTION.
Found foreign key on table 'FK_tc_transacciones_tc_ttipotrxrazon' with name 'dbo.tc_transacciones', principal table 'dbo.tc_ttipotrxrazon', delete action NO_ACTION.
Found foreign key on table 'FK_tc_ttipotrxrazon_tc_empresa' with name 'dbo.tc_ttipotrxrazon', principal table 'dbo.tc_empresa', delete action NO_ACTION.
System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.EntityFrameworkCore.SqlServer.Design.Internal.SqlServerAnnotationCodeGenerator.GenerateFluentApiCalls(IProperty property, IDictionary`2 annotations)
   at Microsoft.EntityFrameworkCore.Design.IAnnotationCodeGenerator.GenerateFluentApiCallsInternal(IAnnotatable annotatable, IDictionary`2 annotations)
   at Microsoft.EntityFrameworkCore.Design.AnnotationCodeGenerator.GenerateFluentApiCalls(IAnnotatable annotatable, IDictionary`2 annotations)
   at Microsoft.EntityFrameworkCore.ScaffoldingModelExtensions.GenerateAnnotations(IAnnotatable annotatable, Dictionary`2 annotations, IAnnotationCodeGenerator annotationCodeGenerator, Boolean isHandledByDataAnnotations)
   at Microsoft.EntityFrameworkCore.ScaffoldingModelExtensions.GetFluentApiCalls(IProperty property, IAnnotationCodeGenerator annotationCodeGenerator)
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.CSharpDbContextGenerator.TransformText()
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.CSharpModelGenerator.ProcessTemplate(ITextTransformation transformation)
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.CSharpModelGenerator.GenerateModel(IModel model, ModelCodeGenerationOptions options)
   at Microsoft.EntityFrameworkCore.Scaffolding.Internal.ReverseEngineerScaffolder.ScaffoldModel(String connectionString, DatabaseModelFactoryOptions databaseOptions, ModelReverseEngineerOptions modelOptions, ModelCodeGenerationOptions codeOptions)
   at Microsoft.EntityFrameworkCore.Design.Internal.DatabaseOperations.ScaffoldContext(String provider, String connectionString, String outputDir, String outputContextDir, String dbContextClassName, IEnumerable`1 schemas, IEnumerable`1 tables, String modelNamespace, String contextNamespace, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames, Boolean suppressOnConfiguring, Boolean noPluralize)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContextImpl(String provider, String connectionString, String outputDir, String outputDbContextDir, String dbContextClassName, IEnumerable`1 schemaFilters, IEnumerable`1 tableFilters, String modelNamespace, String contextNamespace, Boolean useDataAnnotations, Boolean overwriteFiles, Boolean useDatabaseNames, Boolean suppressOnConfiguring, Boolean noPluralize)
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.ScaffoldContext.<>c__DisplayClass0_0.<.ctor>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
   at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
Object reference not set to an instance of an object.
PS C:\Users\jvasquez\source\repos\cmdContabiliza4\cmdContabiliza4>

EF Core version

10.0.0-preview.7.25380.108

Database provider

No response

Target framework

.NET 10

Operating system

No response

IDE

No response

[MihuBot]

Possible related and/or duplicate issue:

• NullReferenceException scaffolding when no primary key set #29516

[vasquezjames]

Ok. I delete table by table from the command until I found the table with the problem. The table have primary key, but have compute columns:

CREATE TABLE [dbo].[tc_maestro_saldos](
[ms_empresa] [smallint] NOT NULL,
[ms_cuenta] [int] NOT NULL,
[ms_moneda] [dbo].[Catalogo] NOT NULL,
[ms_estados] varchar NOT NULL,
[ms_estadocontable] AS ([dbo].fn_estadocontable),
[ms_flgprocesacta] AS (case when substring([ms_estados],(1),(1))='0' OR substring([ms_estados],(1),(1))<>'0' AND ([ms_saldoanterior]<>(0) OR [ms_saldoactual]<>(0) OR [ms_diferidos]<>(0)) then (1) else (0) end),
[ms_formacobro] [dbo].[Catalogo] NULL,
[ms_calpagominimo] [dbo].[Catalogo] NULL,
[ms_cuporotativo] [money] NOT NULL,
[ms_cupodiferido] [money] NOT NULL,
[ms_disponiblerotativo] [money] NOT NULL,
[ms_disponiblediferido] [money] NOT NULL,
[ms_autorizacionesrot] [money] NOT NULL,
[ms_autorizacionesdif] [money] NOT NULL,
[ms_sobregiro] [money] NOT NULL,
[ms_saldocontadocorte] AS (case when ([ms_saldoanterior]-[ms_intantbonificable])>(0) then [ms_saldoanterior]-[ms_intantbonificable] else (0) end),
[ms_saldoactual] [money] NOT NULL,

CONSTRAINT [PK_tc_maestro_saldos] PRIMARY KEY CLUSTERED
(
[ms_cuenta] ASC,
[ms_moneda] ASC,
[ms_empresa] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO

There is a problem with compute columns in EF .NET 10?
As I said, the same table works fine with EF .NET 9

[vasquezjames]

Possible related and/or duplicate issue:

• NullReferenceException scaffolding when no primary key set #29516

In my case all The tables have primary key, but one have compute columns.

[roji]

@vasquezjames I'd like to investigate this - especially as you're reporting a possible regression from EF 9 to 10, but the SQL script you provided above does not work: there are various columns and types/aliases referenced there which do not exist, probably because you copy-pasted a partial script.

Can you please provide a minimal, self-contained SQL script which creates a database that reproduces the problem when scaffolding?

[vasquezjames]

@vasquezjames I'd like to investigate this - especially as you're reporting a possible regression from EF 9 to 10, but the SQL script you provided above does not work: there are various columns and types/aliases referenced there which do not exist, probably because you copy-pasted a partial script.

Can you please provide a minimal, self-contained SQL script which creates a database that reproduces the problem when scaffolding?

Thanks! Ok. I create a clean databse for test inside that database I put all SQL scripts necesary:

USE db_test
GO
/****** Object: Table [dbo].[tc_maestro_saldos] Script Date: 8/13/2025 7:51:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
drop TABLE [dbo].[tc_maestro_saldos]
go
drop TYPE [dbo].[usuario]
go
drop TYPE [dbo].[Catalogo]
go
drop function [dbo].[fn_estadocontable]
go
CREATE TYPE [dbo].[usuario] FROM varchar NOT NULL
go
CREATE TYPE [dbo].[Catalogo] FROM varchar NOT NULL
GO
CREATE function [dbo].[fn_estadocontable]
(@pp_estados varchar(10))
RETURNS varchar(8)

BEGIN
declare @es_estadocontable catalogo
select @es_estadocontable = '0' -- 0=Normal, otros estados.
RETURN @es_estadocontable
END
GO
CREATE TABLE [dbo].[tc_maestro_saldos](
[ms_empresa] [smallint] NOT NULL,
[ms_cuenta] [int] NOT NULL,
[ms_moneda] [dbo].[Catalogo] NOT NULL,
[ms_estados] varchar NOT NULL,
[ms_estadocontable] AS ([dbo].fn_estadocontable),
[ms_flgprocesacta] AS (case when substring([ms_estados],(1),(1))='0' OR substring([ms_estados],(1),(1))<>'0' AND ([ms_saldoanterior]<>(0) OR [ms_saldoactual]<>(0) OR [ms_diferidos]<>(0)) then (1) else (0) end),
[ms_formacobro] [dbo].[Catalogo] NULL,
[ms_calpagominimo] [dbo].[Catalogo] NULL,
[ms_cuporotativo] [money] NOT NULL,
[ms_cupodiferido] [money] NOT NULL,
[ms_disponiblerotativo] [money] NOT NULL,
[ms_disponiblediferido] [money] NOT NULL,
[ms_autorizacionesrot] [money] NOT NULL,
[ms_autorizacionesdif] [money] NOT NULL,
[ms_sobregiro] [money] NOT NULL,
[ms_saldocontadocorte] AS (case when ([ms_saldoanterior]-[ms_intantbonificable])>(0) then [ms_saldoanterior]-[ms_intantbonificable] else (0) end),
[ms_saldoactual] [money] NOT NULL,
[ms_saldoactual_capital] [money] NOT NULL,
[ms_saldoactual_interes] [money] NOT NULL,
[ms_saldoactual_costosoper] [money] NOT NULL,
[ms_saldoactual_impuestos] [money] NOT NULL,
[ms_saldoanterior] [money] NOT NULL,
[ms_interesanterior] [money] NOT NULL,
[ms_pagominimo] [money] NOT NULL,
[ms_pagominimointe] [money] NOT NULL,
[ms_pagominimocapital] [money] NOT NULL,
[ms_pagominimotope] [money] NOT NULL,
[ms_pagominimoanterior] [money] NOT NULL,
[ms_compras] [money] NOT NULL,
[ms_avances] [money] NOT NULL,
[ms_debitos] [money] NOT NULL,
[ms_pagos] [money] NOT NULL,
[ms_devoluciones] [money] NOT NULL,
[ms_creditos] [money] NOT NULL,
[ms_creditosespecificos] [money] NOT NULL,
[ms_diferidos] [money] NOT NULL,
[ms_diferidos_ant] [money] NOT NULL,
[ms_interesrotativo] [money] NOT NULL,
[ms_interesdiferido] [money] NOT NULL,
[ms_interesextracon] [money] NOT NULL,
[ms_interesdemora] [money] NOT NULL,
[ms_interesgastoope] [money] NOT NULL,
[ms_interesbonificable] [money] NOT NULL,
[ms_interesinversion] [money] NULL,
[ms_numpagosvenci] [smallint] NOT NULL,
[ms_monpagosvenci] [money] NOT NULL,
[ms_diasvencidos] [smallint] NOT NULL,
[ms_edadcartera] varchar NULL,
[ms_fchcambiaedad] [datetime] NULL,
[ms_tipoedad] char NULL,
[ms_tipoedad_ant] char NULL,
[ms_numpagosvenci_ayer] [smallint] NOT NULL,
[ms_monpagosvenci_ayer] [money] NOT NULL,
[ms_diasvencidos_ayer] [smallint] NOT NULL,
[ms_fchcambioestado] [datetime] NULL,
[ms_montosxconfirmar] [money] NOT NULL,
[ms_codmensaje] [smallint] NULL,
[ms_interesextraconanterior] [money] NOT NULL,
[ms_intantdiferido] [money] NOT NULL,
[ms_intantrotativo] [money] NOT NULL,
[ms_saldointpagomin] [money] NOT NULL,
[ms_porcpagominimo] [numeric](5, 2) NOT NULL,
[ms_user] varchar NULL,
[ms_proceso] char NOT NULL,
[ms_categoria] [dbo].[Catalogo] NOT NULL,
[ms_calificasib] [dbo].[Catalogo] NULL,
[ms_clasecuenta] [dbo].[Catalogo] NULL,
[ms_tipoimporte] [dbo].[Catalogo] NULL,
[ms_tipoconsumidor] [dbo].[Catalogo] NULL,
[ms_tasadecambio] [money] NOT NULL,
[ms_tasaefectiva] [money] NOT NULL,
[ms_tasarotativo] [money] NOT NULL,
[ms_tasademora] [money] NOT NULL,
[ms_tasadeinversion] [money] NULL,
[ms_montobaseintrot] [money] NULL,
[ms_montobaseintmora] [money] NULL,
[ms_montobasesolca] [money] NULL,
[ms_fchrecalculadisponible] [datetime] NULL,
[ms_fchultrecalculadisponible] [datetime] NULL,
[ms_ultfchactualiza] [datetime] NULL,
[ms_fchultconsumo] [datetime] NULL,
[ms_fchprimerconsumo] [datetime] NULL,
[ms_fchprimermovimiento] [datetime] NULL,
[ms_fchultmovimiento] [datetime] NULL,
[ms_fchprimerpagointernet] [datetime] NULL,
[ms_secuencta] [int] NULL,
[ms_intantbonificable] [money] NOT NULL,
[ms_cuotasdiferido] [money] NOT NULL,
[ms_interesgastoopenum] [int] NOT NULL,
[ms_interesgastoopeultfch] [datetime] NULL,
[ms_diferidosnum] [int] NOT NULL,
[ms_diferidosultfch] [datetime] NULL,
[ms_montosxconfirmarnum] [int] NOT NULL,
[ms_montosxconfirmarultfch] [datetime] NULL,
[ms_chqsconfirmado] [money] NOT NULL,
[ms_chqsconfirmadonum] [int] NOT NULL,
[ms_chqsconfirmadoultfch] [datetime] NULL,
[ms_chqsprotestados] [money] NOT NULL,
[ms_chqsprotestadosnum] [int] NOT NULL,
[ms_chqsprotestadosultfch] [datetime] NULL,
[ms_interesanteriornum] [int] NOT NULL,
[ms_interesanteriorultfch] [datetime] NULL,
[ms_ultuseractualiza] [dbo].[usuario] NULL,
[ms_ultestacionactualiza] varchar NULL,
[ms_cofrexconfirmar] [money] NOT NULL,
[ms_cofrexconfirmarnum] [int] NOT NULL,
[ms_cofrexconfirmarultfch] [datetime] NULL,
[ms_refinanciado] [money] NOT NULL,
[ms_refinanciadonum] [int] NOT NULL,
[ms_refinanciadoultfch] [datetime] NULL,
[ms_refinanciadoultfchcorte] [datetime] NULL,
[ms_castigosaldototal] [money] NULL,
[ms_castigoultfch] [datetime] NULL,
[ms_castigodiasvencidos] [int] NULL,
[ms_castigonumpagosvenci] [int] NULL,
[ms_castigofchpagototal] [datetime] NULL,
[ms_ultusercategoria] varchar NULL,
[ms_ultfchcategoria] [datetime] NULL,
[ms_ultestacioncategoria] varchar NULL,
[ms_avancesatm] [money] NOT NULL,
[ms_avancesatmnum] [int] NOT NULL,
[ms_avancesatmultfch] [datetime] NULL,
[ms_numpagosvenci_ant] [int] NOT NULL,
[ms_monpagosvenci_ant] [money] NOT NULL,
[ms_creditosnum] [int] NOT NULL,
[ms_creditosultfch] [datetime] NULL,
[ms_debitosnum] [int] NOT NULL,
[ms_debitosultfch] [datetime] NULL,
[ms_pagosnum] [int] NOT NULL,
[ms_pagosultfch] [datetime] NULL,
[ms_pagosdiaefectivo] [money] NOT NULL,
[ms_pagosdiacheques] [money] NOT NULL,
[ms_pagoschequesnum] [int] NOT NULL,
[ms_pagoschequesultfch] [datetime] NULL,
[ms_montoultpago] [money] NOT NULL,
[ms_montoultconsumo] [money] NOT NULL,
[ms_comprasnum] [int] NOT NULL,
[ms_comprasultfch] [datetime] NULL,
[ms_avancesnum] [int] NOT NULL,
[ms_avancesultfch] [datetime] NULL,
[ms_devolucionesnum] [int] NOT NULL,
[ms_devolucionesultfch] [datetime] NULL,
[ms_interesrotativonum] [int] NOT NULL,
[ms_interesrotativoultfch] [datetime] NULL,
[ms_interesdiferidonum] [int] NOT NULL,
[ms_interesdiferidoultfch] [datetime] NULL,
[ms_interesextraconnum] [int] NOT NULL,
[ms_interesextraconultfch] [datetime] NULL,
[ms_interesdemoranum] [int] NOT NULL,
[ms_interesdemoraultfch] [datetime] NULL,
[ms_fchsolicitacambiopin] [datetime] NULL,
[ms_cobranzaidasignacion] [int] NULL,
[ms_cobranzafchasigna] [datetime] NULL,
[ms_cobranzaejecutivo] [int] NULL,
[ms_cobranzaejecutivoapoyo] [int] NULL,
[ms_cobranzatipoasignacion] [dbo].[Catalogo] NULL,
[ms_numpagmincero] [smallint] NULL,
[ms_numpagminceroconta] [smallint] NULL,
[ms_intacrualfchproceso] [date] NULL,
[ms_intacruadoRotativo] [money] NULL,
[ms_intacruadoDeMora] [money] NULL,
[ms_intacruadoDiferidos] [money] NULL,
[ms_fchPrelarPorCateTrx] [datetime] NULL,
CONSTRAINT [PK_tc_maestro_saldos] PRIMARY KEY CLUSTERED
(
[ms_cuenta] ASC,
[ms_moneda] ASC,
[ms_empresa] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 70, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tc_maestro_saldos] ADD CONSTRAINT [DF__tc_maestr__ms_fo__72095440] DEFAULT ('0') FOR [ms_formacobro]
GO
ALTER TABLE [dbo].[tc_maestro_saldos] ADD CONSTRAINT [DF__tc_maestr__ms_ca__72FD7879] DEFAULT ('1') FOR [ms_calpagominimo]
GO
-- **********************************************
-- **********************************************
-- This DEFAULT is causing the ERROR!
-- **********************************************
-- **********************************************
ALTER TABLE [dbo].[tc_maestro_saldos] ADD CONSTRAINT [DF__tc_maestr__ms_cu__73F19CB2] DEFAULT ((0)) FOR [ms_cuporotativo]
GO

The same example works fine in EF .NET 9.0.7

This is the command with only the table with the problem:

dotnet ef dbcontext scaffold --force --no-pluralize --use-database-names "Server=SERVIDOR;Database=db_test;User Id=sa;Password=xxxxxxx;Persist Security Info=False;Trust Server Certificate=true" Microsoft.EntityFrameworkCore.SqlServer -o db_test -t tc_maestro_saldos