Could not create relation on One-To-One

[Xellios]

  [Table.Name("B")]
    public class B
    {
        [Column.Size(100)]
        public string Class { get; set; }
        [Relation.OneToOne(LocalKey ="Id", ForeignKey ="Id")]
        public Drawing Drawing { get; set; }
    }

    [Table.Name("A")]
    public class A
    {
        [Column.PrimaryKey(AutoIncrement = false)]
        public Guid Id;
        [Column.Size(100)]
        public string MainNumber;
    }

This throws Iridium.DB.SchemaException: 'Could not create relation B.A', they both share the same name and value for the uniqueidentifier (primary key)

[activa]

Can you show the declaration of the Drawing class? Also, you need a field to store "Id" in class B.

[Xellios]

My bad that was sloppy; Drawing is supposed to be class A. The table of class B already contains a column called Id with holds the exact same uniqueidentifier as class A. I've also tried defining it in class B to see if it would solve it.

[activa]

You need to add a property "Id" in class B as well

[Xellios]

That doesn't solve it.

[activa]

Can you show the declaration of both classes?

[Xellios]

` [Table.Name("B")]
public class B
{
[Column.PrimaryKey(AutoIncrement = false)]
public Guid Id { get; set; }
[Column.Size(100)]
public string Class { get; set; }
[Relation.OneToOne(LocalKey ="Id", ForeignKey ="Id")]
public A Parent { get; set; }
}

[Table.Name("A")]
public class A
{
    [Column.PrimaryKey(AutoIncrement = false)]
    public Guid Id;
    [Column.Size(100)]
    public string MainNumber;
}`

What exactly is wrong?

[activa]

Guid fields are not supported. I will see if I can add support for it, which shouldn't be too hard.
What DB are you using? Sqlite?