3.0.0-rc-20191212
Database types
Starcounter supports most of the .NET CLR primitive types.
List of supported .NET CLR types
BooleanByteDoubleInt16Int32Int64SByteSingleUInt16UInt32UInt64
DateTime
Starcounter saves and returns all
DateTime values in UTC.1
[Database]
2
public abstract class Item
3
{
4
public abstract DateTime Value { get; set; }
5
​
6
public void TestDateTimeValues()
7
{
8
var v = new DateTime(DateTime.Now.Ticks, DateTimeKind.Local);
9
​
10
// The value and the kind are converted into UTC when the CLR type
11
// is converted to a database type, which happens here:
12
this.Value = v;
13
​
14
var kindAfter = this.Value.Kind; // System.DateTimeKind.Utc
15
}
16
}
Copied!
Starcounter does not yet support the
DateTimeOffset data type.Decimal
The
Decimal values are stored as a 64-bit integer and has a precision of six decimals and a range between -4398046511103.999999 and 4398046511104.999999. Trying to store a Decimal value with higher precision or outside of the specified range will result in the following exception: ScErrCLRDecToX6DecRangeError (SCERR4246). In those cases, Double can be used if the data loss is acceptable.String
The string data type can store data up to 1 MiB of encoded text. Thus, all strings with a length of less than 270600 will fit into the string data type. Strings with more than 270600 characters might fit depending on string content.
Starcounter does not yet support non-nullable strings.
Binary
The
Binary data type is a Starcounter-defined datatype used to store binary data in the database. The maximum size of a binary field is 1 MiB.Starcounter only supports nullable binary properties.
1
public abstract class Item
2
{
3
// This defines a nullable binary property.
4
// It is supported by Starcounter.
5
public abstract Binary? NonNullBinary { get; set; }
6
​
7
// This defines a not nullable binary property.
8
// It is not yet supported by Starcounter.
9
public abstract Binary NonNullBinary { get; set; }
10
}
Copied!
Last modified 2yr ago
Copy link