Hi there!

I'm trying to render some data that I'm fetching from a custom SQL table into a specific model (in this case, the 'People' model that comes with the default Umbraco installation, located over localhost:PORT/people), but to no avail.

I've implemented both a controller and a model, followed by a partial view that fetches the variables from those two. However, when trying to render them in said page, by using...

@Html.Partial("~/Views/Partials/UserInfo.cshtml")

...it returns the following error:

The model item passed into the dictionary is of type 'Umbraco.Web.PublishedModels.People', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`1[SimpleTest.Models.TestUsers]'.

As for the things I have implemented, this is the controller, in my App_Code folder:

namespace SimpleTest.Controllers {
    public class TestUsersController : SurfaceController
        private readonly IScopeProvider _scopeProvider;

        public TestUsersController(IScopeProvider scopeProvider)
        {
            _scopeProvider = scopeProvider;
        }

        [ChildActionOnly]
        public IEnumerable<TestUsers> UserInfo()
        {
            using (var scope = _scopeProvider.CreateScope())
            {
                var testusers = scope.Database.Fetch<TestUsers>("SELECT * FROM dbo.MyTestUsers");
                return testusers;
            }
            return null;
        }
    }
}

As for the model,

namespace SimpleTest.Models
{
    [TableName("MyTestUsers")]
    public class TestUsers
    {
        [Column("ID")]
        [PrimaryKeyColumn]
        public int Id { get; set; }

        [Column("Name")]
        public string Name { get; set; }

        [Column("DOB")]
        public System.DateTime DateOfBirth { get; set; }
    }
}

Lastly, my partial view:

@using SimpleTest;
@using SimpleTest.Models;
@model IEnumerable<TestUsers>

@foreach (TestUsers item in Model)
{
    <p>@item.Id</p>
    <p>@item.Name</p>
    <p>@item.DateOfBirth</p>
}

How can I circumvent this issue so that I can correctly render said content into the model in question?

Much appreciated in advance!

Charles