Initial values and Default Database values
(Created page with " === DefaultDbValue === Initial value used when evolving the database or creating the database. This value should be in the format expected by the database engine. For example 0 or 1 for a boolean using SQL Server. Should be 'stringvalue' for a string default value. === Initial value === Initial value used in-memory. Should be true/false or nothing for null (if nullable) or other value depending on type of attribute. === Allow Null === Controls both the in-memory...")
 
No edit summary
Line 1: Line 1:
=== Property inspector for an modelled attribute ===
[[File:InitalValuesInPropertinspectorForAttribute.png|none|frame]]


 
==== DefaultDbValue ====
=== DefaultDbValue ===
Initial value used when evolving the database or creating the database.  
Initial value used when evolving the database or creating the database.  


Line 8: Line 9:
Should be 'stringvalue' for a string default value.
Should be 'stringvalue' for a string default value.


=== Initial value ===
==== Initial value ====
Initial value used in-memory.
Initial value used in-memory.


Should be true/false or nothing for null (if nullable) or other value depending on type of attribute.
Should be true/false or nothing for null (if nullable) or other value depending on type of attribute.


=== Allow Null ===
==== Allow Null ====
Controls both the in-memory nullability and database attribute setting. If this is false, most database engines require a DefaultDbValue to evolve the database. If no value is provided, the existing rows (objects) in database will get an invalid value and the evolve will fail.
Controls both the in-memory nullability and database attribute setting.  
 
If this is false, most database engines require a DefaultDbValue to evolve the database. If no value is provided, the existing rows (objects) in database will get an invalid value and the evolve will fail.

Revision as of 16:40, 16 January 2024

Property inspector for an modelled attribute

InitalValuesInPropertinspectorForAttribute.png

DefaultDbValue

Initial value used when evolving the database or creating the database.

This value should be in the format expected by the database engine. For example 0 or 1 for a boolean using SQL Server.

Should be 'stringvalue' for a string default value.

Initial value

Initial value used in-memory.

Should be true/false or nothing for null (if nullable) or other value depending on type of attribute.

Allow Null

Controls both the in-memory nullability and database attribute setting.

If this is false, most database engines require a DefaultDbValue to evolve the database. If no value is provided, the existing rows (objects) in database will get an invalid value and the evolve will fail.

This page was edited 34 days ago on 03/26/2024. What links here