我的存储过程从关系表中返回一组用户及其组织机构的详细信息。
我在我的C# Web API应用程序中使用了Dapper来执行存储过程。
我对Dapper还不熟悉。我该如何将存储过程返回的结果映射到我的模型中?
存储过程
CREATE PROCEDURE [dbo].[GetAllUsersByOrganisation]
@OrganisationId int = 0
AS
SELECT * from dbo.Users u
inner join dbo.Organisations org on u.OrganisationId = org.Id
Where u.OrganisationId = @OrganisationId
执行方法
public List<User> GetUseryOrganisation(int organisationId)
{
var users = DataContextFactory.GetConnectionString(_settings)
.Execute("dbo.GetAllUsersByOrganisation", new {OrgantisationId = organisationId},
commandType: CommandType.StoredProcedure);
// Map to return List of User
}
Models
public class User
{
public string Title { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string PhoneNumber { get; set; }
public string EmailAddress { get; set; }
public Organisation Organisation { get; set; }
}
public class Organisation
{
public int Id { get; set; }
public string Name { get; set; }
}