Relationships - .NET SDK

To-One Relationship

A to-one relationship means that an object is related in a specific way to no more than one other object. You define a to-one relationship for an object type in its object schema by specifying a property where the type is the related Realm object type.

public class Person : RealmObject
{
    [PrimaryKey]
    [MapTo("_id")]
    public ObjectId Id { get; set; }
    public string Name { get; set; }
    public DateTimeOffset Birthdate { get; set; }
    public Dog Dog { get; set; }
}
public class Dog : RealmObject
{
    [PrimaryKey]
    [MapTo("_id")]
    public ObjectId Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
    public string Breed { get; set; }
}

To query a direct relationship, you can use LINQ syntax. See the following example for how to query a one-to-one relationship:

var fidosPerson = realm.All<Person>().FirstOrDefault(p => p.Dog == dog);

To-Many Relationship

A to-many relationship means that an object is related in a specific way to multiple objects. You define a to-many relationship for an object type in its object schema by specifying a property where the type is an IList<T> of the related Realm object type.

public class Person : RealmObject
{
    [PrimaryKey]
    [MapTo("_id")]
    public ObjectId Id { get; set; }
    public string Name { get; set; }
    public DateTimeOffset Birthdate { get; set; }
    public IList<Dog> Dogs { get; }
}
public class Dog : RealmObject
{
    [PrimaryKey]
    [MapTo("_id")]
    public ObjectId Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
    public string Breed { get; set; }
}

// To add items to the IList<T>:
var person = new Person();
person.Dogs.Add(new Dog
{
    Name = "Caleb",
    Age = 7,
    Breed = "mutt"
});

See the following example for how to query a one-to-many relationship:

var youngDogs = realm.All<Dog>().Where(d => d.Age == 1).OrderBy(dog => dog.Name).ToList();

Inverse Relationship

An inverse relationship links an object back to any other objects that refer to it in a defined to-one or to-many relationship. Relationship definitions are unidirectional, so you must explicitly define a property in the object's model as an inverse relationship.

For example, the to-many relationship "a User has many Tasks" does not automatically create the inverse relationship "a Task belongs to one User". If you don't specify the inverse relationship in the object model, you need to run a separate query to look up the user that is assigned to a given task.

To define the inverse relationship, define a getter-only IQueryable<T> property in your object model, where T is the source type of the relationship, and then annotate this property with a [Backlink(sourceProperty)] attribute, where "sourceProperty" is the name of the property on the other side of the relationship. The following example shows how to do this with the "User has many Tasks" scenario:

public class User : RealmObject
{
    [PrimaryKey]
    [MapTo("_id")]
    public ObjectId Id { get; set; } = ObjectId.GenerateNewId();
    public string Name { get; set; }
    [Backlink(nameof(Task.Assignee))]
    public IQueryable<Task> Tasks { get; }
}
public class Task : RealmObject
{
    [PrimaryKey]
    [MapTo("_id")]
    public ObjectId Id { get; set; } = ObjectId.GenerateNewId();
    public string Text { get; set; }
    public User Assignee { get; set; }
}

In this example, note that:

• The Task object's Assignee property is a User object.

• The User object's Tasks property inverts the relationship and refers to all Task objects that contain this specific User in their Assignee property.

This, then, allows us to query the Task collection to get all Tasks assigned to a specific User.

To query the inverse relationship, you cannot use Linq. Instead, pass a string predicate. The following example shows how you could find all Users who have Tasks that contain the word "oscillator":

var oscillatorAssignees = realm.All<User>()
    .Filter("Tasks.Text CONTAINS 'oscillator'").ToList();
foreach (User u in oscillatorAssignees)
{
    Console.WriteLine(u.Name);
}