Hi,
We are using LLBLGen Pro 5.4 with Npgsql 3.2.7.
We are porting from SQL Server to Postgresql and the code was relying on the support that LLBLGen has for newsequentialid() as a way to specify a default value for uniqueidentifier fields.
**Is there an equivalent for Postgresql (and uuid fields)?
**
Details:
1. In Postgresql we have this primary key id that has is configured for default values as follows:
create table item
(
id uuid default gen_random_uuid() not null
constraint pk_item_678150057
primary key
...
}
- In the following code
var transaction = new Transaction(System.Data.IsolationLevel.Unspecified, "insert_my_item");
var insertedItem = new ItemEntity();
transaction.Add(insertedItem);
insertedItem.Save();
var idOfInsertedItem = insertedItem.Id;
the insertedItem.Id is an empty Guid (00000000-0000-0000-0000-000000000000).