public static TRow TrySingle <TRow>(this IDbConnection connection, Action <SqlQuery> editQuery) where TRow : class, IRow, new() { var row = new TRow() { TrackWithChecks = true }; var query = new SqlQuery().From(row); editQuery(query); if (query.GetSingle(connection)) { return(row); } return(null); }
public static TRow TryById <TRow>(this IDbConnection connection, object id, Action <SqlQuery> editQuery) where TRow : class, IRow, IIdRow, new() { var row = new TRow() { TrackWithChecks = true }; var query = new SqlQuery().From(row) .Where(new Criteria(row.IdField) == new ValueCriteria(id)); editQuery(query); if (query.GetSingle(connection)) { return(row); } return(null); }