SQL Statement to Subsonic Query

I use the RepositoryRecord in SubSonic which is "mostly" poco. Then I make partials for those classes that load the other class when a property is selected. Besides, loading one record from the database is faster and easier than loading them all at once.

Partial Public Class Book

    Private _Author as Database.Author 
    Property Author() as Database.Author
      Get
         If _Author is nothing then
           ' Load the author class here.
         End if
         return _Author
      End get
      Set
         '....
      End Set
    End Property

End Class

I believe Alias's are only available for aggregate columns. You could just add properties of the same names as your columns to your class or a partial and map them to the properties you do use ala calculated field:

public class Songs

{

private string _songTitle;
public string SongTitle {
    get { return _songTitle; }
    set { _songTitle = value; }
}

public string SongName {
    get { return _songTitle; }
    set { _songTitle = value; }
}

}