Hi Aaron,

Except for the LoadlAll solution as Fransico suggested, I want to add two more solutions:

Solution B): Change the SQL Where condition defined in your C# model. 

[SqlParameter("Name", typeof(string))]

[FromTable("Customers")]

[SqlWhere("Name = :Name or :Name IS NULL")]

public class Customer {

        public int Id { get; set; }

        public string Name { get; set; }

}

Solution C): Remove the WHERE clause using GetQueryBuilder.

You can add other where conditions dynamically after GetQueryBuilder.

  var data = await _dataContext.SqlModelMapper.GetQueryBuilder<Department>(removeWhereClause: true)
                .LoadAsync(null, cancellationToken);

Regards, Logan

You can just check if the variable is null and decide whether to call the function with or without arguments:

public async Task<IEnumerable<customer>> RetrieveAsync(string name)
{
     ILoadable<Customer> result;
     if(name == null) {
        result = await _dataContext.SqlModelMapper.LoadAsync<Customer>(name);
     } else {
        await _dataContext.SqlModelMapper.LoadAsync<Customer>();
     }

    return result.ToList()
} 

Regards,
Francisco

Edit: The previous code block doesn't compile, please try the following:

public async Task<IEnumerable<Customer>> RetrieveAsync(string name)
{
     ILoadable<Customer> result;
     if(name == null) {
        result = await _dataContext.SqlModelMapper.LoadAll<Customer>();
     } else {
        await _dataContext.SqlModelMapper.LoadAsync<Customer>(name);
     }

    return result.ToList()
}