1

I am trying to make One To Zero One association between two tables in Telerik Data Access, but can't make it work. Here are my tables:

Student

  • Id (PK)

  • Name (string)

BackPack

  • Id (PK)

  • StuffInside(string)

  • StudentId (Unique, Foreign key)

StudentId in Backpack references to Id in Student. When I do the mapping for some reason Telerik is making it One to Zero Many. I need One To Zero One.

Dilshod
  • 3,189
  • 3
  • 36
  • 67

1 Answers1

1

I assume you are using the Telerik Data Access Visual Designer to model your database? If so, in order to create one-to-one association you need to specify that the ID from one table (Students) matches the ID from the other table (BackPacks). This way each student will have exactly one (or zero) backpack. Please refer to this documentation article which demonstrates the approach.

If this is not applicable in your scenario and you have to match the Student ID to the BackPack StudentId to achieve the same effect you could create one-to-many association and then manually create the unique constraint on the database server side. Alternatively you could switch to Fluent Mapping which allows you to create custom indexes in you mapping.

Boyan Palagachev
  • 86
  • 3