Proposed behaiour
"Db Default Value" (or whatever) property in "Database" category for entity fields which would generate .HasDefaultValueSql(string) clause in DbContext.OnModelCreating() method. E.g. "(getdate())", "(newid())" or user-defined functions.
User scenarios:
SQL scripts to update DB besides EF Migrations;
importing data directly to DB
Current behaviour
Allows only initial values of the same type as field type. Doesn't allow string expressions.
Versions
EF Visual Editor: 4.1.2.0
Visual Studio 2022: 17.1.3
Proposed behaiour "Db Default Value" (or whatever) property in "Database" category for entity fields which would generate .HasDefaultValueSql(string) clause in DbContext.OnModelCreating() method. E.g. "(getdate())", "(newid())" or user-defined functions. User scenarios:
Current behaviour Allows only initial values of the same type as field type. Doesn't allow string expressions.
Versions EF Visual Editor: 4.1.2.0 Visual Studio 2022: 17.1.3