Individual relationship with subsonic

Question

How can you create a one-to-one relationship in Subsonic? For example, I have a table called “Readings,” and each Reading has only one book, however Subsonic returns IQueryablebooks. I want her to return only one book. Thanks.

Answer 1

I assume that you are using the ActiveRecord template to generate your code.

Inside ActiveRecord.tt you will see a section that looks like this:

 public IQueryable<<#=fk.OtherClass #>> <#=propName #>
        {
            get
            {
                  var repo=<#=Namespace #>.<#=fk.OtherClass#>.GetRepo();
                  return from items in repo.GetAll()
                       where items.<#=CleanUp(fk.OtherColumn)#> == _<#=CleanUp(fk.ThisColumn)#>
                       select items;
            }
        }

, . , , - .

, .

Answer 2

, :

public partial class Reading 
{
    private Book _book;
    public Book Book 
    {
        get 
        {
            if (_book == null)
                _book = this.Books.SingleOrDefault();
            {
                return _book;
            }
        }
        set
        {
            _book = value;
        }
    }
}

Book, Iqueryable.

- , , , , .

: , , -