Hello, I am trying to read data from custom tables in Umrbaco DB with public IEnumerable<T1> Query<T1, T2>(string sql, params object[] args); but I don't get any exception and results are null.

Here is my source code:

[TableName("FacultyId")]
    [PrimaryKey("FacultyId", autoIncrement = true)]
    public class Faculty
    {
        public int FacultyId { get; set; }
        public string Name { get; set; }
        public string Description { get; set; }
    }
}

[TableName("Students")]
[PrimaryKey("Id", autoIncrement = true)]
public class Student
{

    public int Id { get; set; }

    public int StudentUmbracoId { get; set; }

    [Required]
    public string Name { get; set; }

    [EmailAddress]
    [Required]
    public string Email { get; set; }

    [Required]
    public int ClassNumber { get; set; }

    [Column("FacultyId")]
    public int FacultyId { get; set; }

}

And my method for calling the SQL query is:

public IEnumerable<Student> GetStudentsByFaculty()
{
    IEnumerable<Student> result = database.Query<Student, Faculty>("SELECT Students.*, Faculty.* from Students LEFT JOIN Faculty on Students.FacultyId = Faculty.FacultyId");
    return result;
}

The result is :

I will be thankful if somebody can explain me where I am wrong.

Thanks, Desi