[DataContract]
public class ClientSurvey
{
    [DataMember(EmitDefaultValue = false)]
    public int Id { get; set; }

    [DataMember]
    public int ClientId { get; set; }

    [DataMember(EmitDefaultValue = false)]
    public int SurveyId { get; set; }

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

    [DataMember]
    public DateTime StartDate { get; set; }

    [DataMember]
    public DateTime? EndDate { get; set; }

    [DataMember]
    public bool IsPatientDefault { get; set; }

    [DataMember]
    public bool IsLocked { get; set; }

    [DataMember]
    public Survey Survey { get; set; }

    [DataMember]
    public string IntroHtml { get; set; }

    [DataMember]
    public string OutroHtml { get; set; }

    [DataMember]
    public int MaxResponses { get; set; }
}

public async Task<ClientSurvey> GetDefaultAsync(int clientId)
{
    // NOTE: This was actually "select cs.*" but has been spelled out for better understanding and to see if it would help with the mapping.  It did not.
    const string sql =
        @"select cs.[Id], cs.[ClientId], cs.[SurveyId], cs.[Name], cs.[StartDate], cs.[EndDate], cs.[IsPatientDefault], cs.[ClientSurveyBundleId], cs.[IsLocked], cs.[IntroHtml], cs.[OutroHtml], cs.[MaxResponses], cs.[Description]
          from dbo.ClientSurveys cs
          inner join dbo.Surveys s on s.Id = cs.SurveyId
          where cs.ClientId = @clientId
            and cs.IsPatientDefault = 1
            and isnull(cs.EndDate, '9999-1-1') > getdate() 
            and isnull(cs.StartDate, '2000-1-1') < getdate() 
            and s.IsActive = 1;";

    using (var cnn = await OpenConnectionAsync())
    {
        var surveys = (await cnn.QueryAsync<ClientSurvey>(sql, new {ClientId = clientId})).ToList();
        if (!surveys.Any())
        {
            return null;
        }
        if (surveys.Count() > 1)
        {
            throw new Exception("Multiple default surveys for client " + clientId);
        }
        var clientSurvey = surveys.First();
        clientSurvey.Survey = await SurveysData.Instance.GetAsync(clientSurvey.SurveyId, clientSurvey.ClientId);
        clientSurvey.SurveyId = 0; // Clear this so it doesn't serialize out and duplicate the data.
        await ReplaceVariables(clientSurvey);
        return clientSurvey;
    }
}