Devart Forums

Posted: **Sun 14 Feb 2016 17:13**

Hello,
I have the following Code

        [Key,
        Column("VendorId"),
        DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public Guid Id { get; set; }

On SQL Server the Id is generated during save changes, using dotConnect for sqlite 5.3.592 (just upgraded to the latest Version) no Id is generated and I get an Constraint vioolation because Id can not be null).

Is Auto Generation of a GUID not supported for sqlite or do i am missing something?

Thanks,
Chris

Posted: **Mon 15 Feb 2016 14:45**

Auto generation of a GUID is not supported for SQLite.
Please set DatabaseGenerated(DatabaseGeneratedOption.None) and generate GUID in your .NET code (for example, in a class constructor).

Devart Forums

DatabaseGeneratedOption.Identity for GUID not working

DatabaseGeneratedOption.Identity for GUID not working

Re: DatabaseGeneratedOption.Identity for GUID not working