Support for custom database data types

Hello.

It is possible for LightSpeed users to self-implement something like field converters for non standard database data type?

For example, PostgreSQL has ip address data type, is it possible to create custom class and field converter for it?

Thanks.

Yes, you can specify these as a user-defined type in LightSpeed (see: http://www.mindscapehq.com/documentation/lightspeed/Working-with-Models-in-the-Visual-Designer/enums-and-other-user-defined-types) and then implement a custom field converter if required to convert to/from the .NET type and the DB type (see: http://www.mindscapehq.com/documentation/lightspeed/Working-with-Legacy-Databases/Mapping-Database-Types-to-Domain-Types).

Jeremy

Good day.

I have added custom database data type (CITEXT - case insensitive variant of TEXT in PostgreSQL), but model designer creates columns with incorrect default value.

The query is:

CREATE TABLE Entity1 (Id INT NOT NULL PRIMARY KEY, Name CITEXT NOT NULL DEFAULT 0)

Query should be the same as for text columns:

CREATE TABLE Entity1 (Id INT NOT NULL PRIMARY KEY, Name CITEXT NOT NULL DEFAULT '')

Or

CREATE TABLE Entity1 (Id INT NOT NULL PRIMARY KEY, Name CITEXT NOT NULL DEFAULT ''::citext)

Is there any way to specify correct default value?

Thanks.

No Im afraid we don't have an option for something like this.

Jeremy