/// <summary>
/// Gets a single entity from the database, filtered using a WHERE clause.
/// </summary>
/// <param name="whereClause">A string containing the WHERE clause's predicate</param>
/// <param name="param">Parameters to be passed to the WHERE clause</param>
public TEntity FindOne(string whereClause, object param = null)
{
var sql = _queryGenerator.FindOne(Table, SelectFields, whereClause);
var connection = GetConnection();
try {
var entity = connection.Query <TEntity>(sql, param).FirstOrDefault();
return(entity);
}
finally {
if (!_useProvidedConnection)
{
connection.Dispose();
}
}
}
