views:

4362

answers:

25

What is the best practice when returning data from functions. Is it better to return a Null or an empty object? And why should one do one over the other?

Consider this:

public UserEntity GetUserById(Guid userId)
{
     //Imagine some code here to access database.....

     //Check if data was returned and return a null if none found
     if (!DataExists)
        return null; 
        //Should I be doing this here instead? 
        //return new UserEntity();  
     else
        return existingUserEntity;
}

Lets pretend that there would be valid cases in this program that there would be no user information in the database with that GUID. I Would imagine that it would not be appropriate to throw an exception in this case?? Also I am under the impression that exception handling can hurt performance.

+87  A: 

Returning null is usually the best idea if you intend to indicate that no data is available.

An empty object implies data has been returned, whereas returning null clearly indicates that nothing has been returned.

Additionally, returning a null will result in a null exception if you attempt to access members in the object, which can be useful for highlighting buggy code - attempting to access a member of nothing makes no sense. Accessing members of an empty object will not fail meaning bugs can go undiscovered.

kronoz
You should be throwing an exception, not swallowing the problem and returning null. At a minimum, you should log this and then continue.
Chris Ballance
@Chris: I disagree. If the code clearly documents that the return value is null, it's perfectly acceptable to return null if no result is found to match your criteria. Throwing an exception should be your LAST choice, not your FIRST one.
Mike Hofer
@Chris: On what basis do you decide this? Adding logging to the equation **certainly** seems excessive. Let the consuming code decide what--if anything--should be done in the case of no user. As with my previous comment, there's absolutely no issue with returning a value that is universally defined as "no data".
Adam Robinson
@Chris: I don't understand your comment? What should be throwing an exception? The function? Why would it be an error for it to return null? It may be an error that in the context of the call site a null is an unacceptable return value but thats not the function's decision to make.
AnthonyWJones
It can be acceptable to return null, but relying on returning null and then NullReference throwing higher in the stack is incorrect, because it removes the actual problem one call away from the origin site.
Rex M
The original problem is "user does not exist". We throw an exception when we demand a file path that doesn't exist. Both patterns are appropriate - it just depends.
Rex M
The function itself isn't in error by returning null, rather it's indicating that nothing has been returned. Of course the caller should be testing for null, I agree, however it does add an extra line of defence knowing that even if a null object sneaks through it will raise an exception. That is only icing on the cake compared to the fact you get to indicate that nothing has been returned in a universally understood way. If you simply return an empty object, how would you test that it was empty and throw an exception? It's more difficult and messy to implement that way.
kronoz
@Rex: As I said in response to your own answer, the file system scenarios are all in situations where you're performing an operation on the file, not simply bringing back an object that represents the file.
Adam Robinson
I'm a little baffled that a Microsoft developer believes that "returning null" equates to "swallowing the problem." If memory serves, there are tons methods in the Framework where methods null is returned if there's nothing that matches the caller's request. Is that "swallowing the problem?"
Mike Hofer
I think both null and exception are valid options. However, if the method throws an exception, you should give the user a way to avoid the exception - for example, by publicly exposing IsValidId(Guid id), or "GetListOfIds()".
Mathias
If you postulate that you agree the caller should test for null, why proclude empty objects? Instead of obj != null, you would just be doing obj != default(x). I would think if you are explicitly checking the return, either method would be appropriate.
joseph.ferris
@joseph: You could also implement any of a number of other arbitrary means to return a reserved value, but there is *already* a reserved value for "no data": `null`.
Adam Robinson
@Adam - one can also argue that there are two, since default() implies, through this usage, the equivalent of the return saying "I have no apples" or null being the equivalent of just saying "I have none". I think that the point is that I can't find justification for one being better than the other and it really is a matter of personal preference. Return a default is actually quite similar to what SQL Server does when you have a query with no rows. It still returns the table schema, but no records. This isn't about "any number of arbitrary ways", this is specifically about comparing two.
joseph.ferris
Last but not least there would be `bool GetUserById(Guid userId, out UserEntity result)` - which I would prefer to the "null" return-value, and which isn't as extreme as throwing an exception. It allows beautiful `null`-free code like `if(GetUserById(x,u)) { ... }`.
Marcel J.
I guess the choice between returning null or throwing an exception depends on a lot of other factors. It should be consistant with the rest. It should not return null on one error and throw an exception on another error. Exceptions should only be used for signaling errors, not changing the program flow. If (in this example here) !DataAvailable is a standard case that can happen very often, I'd go for returning null. If the application assumes that normally the DB is there, Data is there, I'd go for the exception, because then I can handle the error in any part of the app, not just the caller.
Tobias Langner
IMO, empty objects is data and null, doesn't. So if you want to know what happend with this method and this method return null, well this method did nothing.
Agusti-N
Thanks everyone for all of your suggestions! I decided to choose this answer as my accepted answer because this is the approach I decided to take. However, I really like all of the other arguments and I will continue to read any new ones suggested.
Roberto Sebestyen
@Tobias: "It should not return null on one error and throw an exception on another error." I think it can make sense to return null or throw an exception. If null is documented to mean "no matching user found in the database", then null is an expected return value for this particular function, although it could still be an application-level error. On the other hand, if the database server is down, I wouldn't want the function to return null. I would want to get an exception.
Mike Spross
returning NULL is a shortcut to `bool GetUserById(GUID id, out UserEntity user)` which I find perfectly acceptable. Why take 2 steps to avoid an exception.. would you do this?`if(userexists(uid)) { <getuser> }` and make 2 calls to the database?
Mike Gleason jr Couturier
Ok, so what methods/properties that return a list, where there's nothing to go in the list. Should they return null, or an empty list? For example xmlNode.SelectNodes(xPath) will always return an empty list rather than null (as an aside, Resharper really irritates me when it recommends I check the result for null). Personally, I find this makes my code a lot cleaner, not having to check for null first.
Flynn1179
+32  A: 

It depends on what makes the most sense for your case.

Does it make sense to return null, e.g. "no such user exists"?

Or does it make sense to create a default user? This makes the most sense when you can safely assume that if a user DOESN'T exist, the calling code intends for one to exist when they ask for it.

Or does it make sense to throw an exception (a la "FileNotFound") if the calling code is demanding a user with an invalid ID?

However - from a separation of concerns/SRP standpoint, the first two are more correct. And technically the first is the most correct (but only by a hair) - GetUserById should only be responsible for one thing - getting the user. Handling its own "user does not exist" case by returning something else could be a violation of SRP. Separating into a different check - bool DoesUserExist(id) would be appropriate if you do choose to throw an exception.

Based on extensive comments below: if this is an API-level design question, this method could be analogous to "OpenFile" or "ReadEntireFile". We are "opening" a user from some repository and hydrating the object from the resultant data. An exception could be appropriate in this case. It might not be, but it could be.

All approaches are acceptable - it just depends, based on the larger context of the API/application.

Rex M
@anon why the DV?
Rex M
Someone voted you down and I voted you back up, since this doesn't seem like a bad answer to me; except: I wouldn't ever throw an exception when finding no user in a method like the one the poster gives. If finding no user implies an invalid ID or some such exception-worthy problem, that should happen higher up -- the throwing method needs to know more about where that ID came from, etc.
JacobM
(I'm guessing the downvote was an objection to the idea of throwing an exception in a circumstance like this.)
JacobM
Agreed until your last point. There's no violation of SRP by returning a value that is universally defined as "no data". That's like stating that a SQL database should return an error if a where clause produces no results. While an Exception is a valid design choice (though one that would irritate me as a consumer), it's not any "more correct" than returning null. And no, I'm not the DV.
Adam Robinson
@JacobM we throw exceptions when we demand a filesystem path that doesn't exist, not return null, but not from databases. So clearly both are appropriate, which is what I'm getting at - it just depends.
Rex M
@Rex: Look at the `FileNotFoundException` cases. They're all under circumstances where you're performing an *operation* on the file (opening a stream, deleting it, etc.). I would bet good money that if, say, `DirectoryInfo` had a `GetFile` function that returned a single child file, it would return `null` rather than throwing an exception when the file didn't exist. `GetFiles()` returns an empty array if no files are found. I'd be interested to see an example where a function *other than an operation on the file itself* threw `FileNotFound` in the event that it simply didn't exist.
Adam Robinson
@Adam indeed, I would consider this method to be analogous to "OpenFile" - we are opening the user from the repository.
Rex M
The `FileInfo` constructor accepts a path. If the path doesn't exist, it does not throw a `FileNotFoundException`. It has a property `Exists` which will tell you whether the file exists or not.
Eclipsed4utoo
This is a BUSINESS DOMAIN MODEL Question, not a technical question.
Charles Bretana
@Charles we don't know that - it could just as well be an API design question. Lots of systems have users.
Rex M
There are times it would be nice even for a FileNotFound to return a null reference instead. Imagine trying to use LINQ against a set of files. If a file is removed before the iterator completes the exception would blow out the entire stack leaving you in an inconsistent state instead of just being able to do a null check and continue.
Matthew Whited
+1 for the great response Rex.
Roberto Sebestyen
@Rex: And I would consider them different. That leads me to think that there's no "right" (ie, "more correct") answer, which was my original point ;)
Adam Robinson
@Rex M, ... even if it is an API question, the API design should not be based on the domain model? What is the Business Domain Model problem this method's return value is to be used for? At some point in the stack frame every method is eventually used to implement some business function. If the absence of a user will prevent that business function from completing sucessfully, then at some point in the stack frame, the code should throw an exception.
Charles Bretana
@Charles: You're answering the question "should an exception be thrown at some point", but the question is "should this function throw the exception". The correct answer is "maybe", not "yes".
Adam Robinson
This certainly looks like a method that would be in the DAL. There is no reason for a DAL method to concern itself with business rules. That's what the business layer is for. It should return null, and the business layer should contain the code whether to throw an exception or not. If the user not being found is a possible case or not, the the business layer should handle it. As Adam(above) says, this question is not whether an exception should be thrown somewhere. The question is whether the exception should be thrown from THIS method. My answer is no. Null will be better in my opinion
Eclipsed4utoo
@Adam, I see the distinction you are making... Yes I agree, in principle, if an exception is to be thrwn, then where it is thrown is a separate question. For example, if multiple business processes use this method, and some of them can complete successfully with no User, and others cannot, then the exception should be throw furthur up the call stack, closer to where it intercepts with the busines Domain Model processes that require a User. But again, these distinctions should all be based on an analysis of the buisiness Domain Model, including the processes within it.
Charles Bretana
So we've all settled on "Maybe, it depends on the larger context of your application" which, coincidentally, is my answer ;)
Rex M
@Rex, yes... and I'd define "larger context of the application" so that it is clear that this is that subset or modification of the complete Business Domain Model which most closely "fits" with or describes the business functions and processes implemented by the application.
Charles Bretana
@Rex ... no. The question is whether THIS method should throw an exception. That answer should be no. It doesn't depend on any context. Now whether an exception should be thrown elsewhere, that is what depends on the "larger context of the application". But as to whether this "GetUserByID" method should throw that exception, my opinion is no.
Eclipsed4utoo
@Eclipsed4utoo, you state your opinion w/o any justification. Why do you feel this way? Without knowing the context, how can you say whether it depends on it or not? What if the only method calling this method is a method that applies an adjustment to a financial account based upon a GUID decrypted from a value passed in from the internet? And if your answer is no, What IS your criteria for when a method should throw an exception?
Charles Bretana
@Eclipsed4utoo we don't know if this is something like an API to an LDAP or ActiveDirectory service, which would almost certainly throw an exception if the caller demands data for a specific ID which does not exist. There is broad agreement here that all are possibly correct, we don't have enough information to know for sure.
Rex M
@Charles and @Rex my justification is in my previous comment. The first comment in the code clearly states that the code accesses a database. And again, the question isn't "should an exception be thrown somewhere". That would definitely depend on business rules. The question is whether a method that gets data from a database should throw an exception if the data is not found/blank. If code accesses a database, it should only do that. It shouldn't contain business logic. It should return null, and the calling code should handle the null using the application's business rules.
Eclipsed4utoo
(continued)... @Charles and @Rex The business layer/code should determine whether to throw an exception. Not the database code.
Eclipsed4utoo
Business logic should not throw exceptions. Exceptions are for exceptional application circumstances - when code encounters a situation it cannot deal with.
Rex M
@Rex, well, ".. for exceptional application circumstances ..." No offense, but That's not clear or informative... "encounters a situation it cannot deal with" is little better - it eliminates all "expected" situations, cause if I expect a situation, I can ALWAYS deal with it, maybe not and keep the application running in a consistent state, but I can always "deal with It" - A better definition is that you should throw an exception "anytime the function of method cannot succssfully complete whatever function it was designed to perform." – Charles Bretana 0 s
Charles Bretana
@eclipsed4utoo, Even if the code is accesssing a database, it is still a business issue, not a technical one... No one but the business domain expert knows whether or not the fucntion of requesting a record from the database for a specific key, should be considered successful if no such record exists with that key. Clearly, for some business scenarios, this might be ok, and for some others, this might indicate a failure justifying an exception.
Charles Bretana
+7  A: 

I personally would return null, because that is how I would expect the DAL/Repository layer to act.

If it doesn't exist, don't return anything that could be construed as successfully fetching an object, null works beautifully here.

The most important thing is to be consistant across your DAL/Repos Layer, that way you don't get confused on how to use it.

Alex Moore
+9  A: 

This is a business question, dependent on whether the existence of a user with a specific Guid Id is an expected normal use case for this function, or is it an anomaly that will prevent the application from successfully completing whatever function this method is providing the user object to...

If it's an "exception", in that the absence of a user with that Id will prevent the application from successfully completing whatever function it is doing, (Say we're creating an invoice for a customer we've shipped product to...), then this situation should throw an ArgumentException (or some other custom exception).

If a missing user is ok, (one of the potential normal outcomes of calling this function) then return a null....

EDIT: (to address comment from Adam in another answer)

If the application contains multiple business processes, one or more of which require a User in order to complete successfully, and one or more of which can complete successfully without a user, then the exception should be thrown further up the call stack, closer to where the business processes which require a User are calling this thread of execution. Methods between this method and that point (where the exception is being thrown) should just communicate that no user exists (null, boolean, whatever - this is an implementation detail).

But if all processes within the application require a user, I would still throw the exception in this method...

Charles Bretana
-1 to the downvoter, +1 to Charles -- it is entirely a business question and there is no best practice for this.
Austin Salonen
It is crossing the streams. Whether or not it is an "error condition" is driven by the business logic. How to handle that is an application architecture decision. The business logic is not going to dictate that a null be returned, just that the requirements are satisfied. If the business is deciding method return types, then they are too involved in the technical aspect of the implementation.
joseph.ferris
@joseph, the core principle behind "structured exception handling" is that exceptions should be thrown when methods cannot complete whatever function they were coded to implement. You are right, in that if the business function this method has been coded to implement can be "successfully completed", (whatever that means in the Domain Model), then you don't need to throw an exception, you could return a null, or a boolean "FoundUser" variable, or whatever... How you communicate to the calling method that no user was found then becomes a technical implementation detail.
Charles Bretana
+3  A: 

It will vary based on context, but I will generally return null if I'm looking for one particular object (as in your example) and return an empty collection if I'm looking for a set of objects but there are none.

If you've made a mistake in your code and returning null leads to null pointer exceptions, then the sooner you catch that the better. If you return an empty object, initial use of it may work, but you may get errors later.

JacobM
Why this answer was voted down?
Kamarey
+1 I was questioning the same logic you are saying here, which is why i posted the question to see what others opinions about this would be
Roberto Sebestyen
+16  A: 

Personally, I use NULL. It makes clear that there is no data to return. But there are cases when a Null Object may be usefull.

Fernando
+1 for the null objects reference
Austin Salonen
+2  A: 

I typically return null. It provides a quick and easy mechanism to detect if something screwed up without throwing exceptions and using tons of try/catch all over the place.

whatsisname
+4  A: 

If your return type is an array then return an empty array otherwise return null.

Darin Dimitrov
Is 0 items in a list the same as list unassigned at this time?
AnthonyWJones
0 items in a list is not the same as `null`. It allows you to use it in `foreach` statements and linq queries without worrying for `NullReferenceException`.
Darin Dimitrov
+3  A: 

The best in this case return "null" in a case there no a such user. Also make your method static.

Edit:

Usually methods like this are members of some "User" class and don't have an access to its instance members. In this case the method should be static, otherwise you must create an instance of "User" and then call GetUserById method which will return another "User" instance. Agree this is confusing. But if GetUserById method is member of some "DatabaseFactory" class - no problem to leave it as an instance member.

Kamarey
Can I ask why I would want to make my method static? What if I want to use Dependency Injection ?
Roberto Sebestyen
See edit. (hate this min 15 chars comments:) )
Kamarey
Ok now I get your logic. But I stick with the Repository pattern, and I like to use dependency injection for my repositories therefore I can't use static methods. But +1 for suggesting to return null :)
Roberto Sebestyen
+7  A: 

You should throw an exception (only) if a specific contract is broken.
In your specific example, asking for a UserEntity based on a known Id, it would depend on the fact if missing (deleted) users are an expected case. If so, then return null but if it is not an expected case then throw an exception.
Note that if the function was called UserEntity GetUserByName(string name) it would probably not throw but return null. In both cases returning an empty UserEntity would be unhelpful.

For strings, arrays and collections the situation is usually different. I remember some guideline form MS that methods should accept null as an 'empty' list but return collections of zero-length rather than null. The same for strings. Note that you can declare empty arrays: int[] arr = new int[0];

Henk Holterman
+1 for helpful answer
Roberto Sebestyen
Very nice answer. +1.
Mike Hofer
+3  A: 

In our Business Objects we have 2 main Get methods:

To keep things simple in the context or you question they would be:

// Returns null if user does not exist
public UserEntity GetUserById(Guid userId)
{
}

// Returns a New User if user does not exist
public UserEntity GetNewOrExistingUserById(Guid userId)
{
}

The first method is used when getting specific entities, the second method is used specifically when adding or editing entities on web pages.

This enables us to have the best of both worlds in the context where they are used.

Mark Redman
+3  A: 

I personally return a default instance of the object. The reason is that I expect the method to return zero to many or zero to one (depending on the method's purpose). The only reason that it would be an error state of any kind, using this approach, is if the method returned no object(s) and was always expected to (in terms of a one to many or singular return).

As to the assumption that this is a business domain question - I just do not see it from that side of the equation. Normalization of return types is a valid application architecture question. At the very least, it is subject for standardization in coding practices. I doubt that there is a business user who is going to say "in scenario X, just give them a null".

joseph.ferris
+1 I like the alternative view of the problem. So basically you are saying whichever approach I choose should be fine as long as the method is consistent throughout the application?
Roberto Sebestyen
That is my belief. I think consistency is extremely important. If you do things multiple ways in multiple places, it introduces a higher risk for new bugs. We personally have gone with the default object approach, because it works well with the Essence pattern that we use in our domain model. We have a single generic extension method that we can test against all domain objects to tell us if it is populated or not, so that we know that any DO can be tested with a call of objectname.IsDefault() - avoiding any equality checks directly.
joseph.ferris
+2  A: 

For collection types I would return an Empty Collection, for all other types I prefer using the NullObject patterns for returning an object that implements the same interface as that of the returning type. for details about the pattern check out link text

Using the NullObject pattern this would be :-

public UserEntity GetUserById(Guid userId)

{ //Imagine some code here to access database.....

 //Check if data was returned and return a null if none found
 if (!DataExists)
    return new NullUserEntity(); //Should I be doing this here instead? return new UserEntity();  
 else
    return existingUserEntity;

}

class NullUserEntity: IUserEntity { public string getFirstName(){ return ""; } ...}
vikram nayak
+4  A: 

I'd say return null instead of an empty object.

But the specific instance that you have mentioned here, you are searching for an user by user id, which is sort of the key to that user, in that case I'd probably want to to throw an exception if no user instance instance is found.

This is the rule I generally follow:

  • If no result found on a find by primary key operation, throw ObjectNotFoundException.
  • If no result found on a find by any other criteria, return null.
  • If no result found on a find by a non-key criteria that may return a multiple objects return an empty collection.
Partha Choudhury
+4  A: 

We use CSLA.NET, and it takes the view that a failed data fetch should return an "empty" object. This is actually quite annoying, as it demands the convention of checking whether obj.IsNew rathern than obj == null.

As a previous poster mentioned, null return values will cause code to fail straight away, reducing the likelihood of stealth problems caused by empty objects.

Personally, I think null is more elegant.

It's a very common case, and I'm surprised that people here seem surprised by it: on any web application, data is often fetched using a querystring parameter, which can obviously be mangled, so requiring that the developer handle incidences of "not found".

You could handle this by:

if (User.Exists(id)) {
  this.User = User.Fetch(id);
} else {
  Response.Redirect("~/notfound.aspx");
}

...but that's an extra call to the database every time, which may be an issue on high-traffic pages. Whereas:

this.User = User.Fetch(id);

if (this.User == null) {
  Response.Redirect("~/notfound.aspx");
}

...requires only one call.

Keith Williams
+1 agreed.......
Roberto Sebestyen
+2  A: 

I prefer null, since it's compatible with the null-coalescing operator (??).

Andrew Medico
+2  A: 

To put what others have said in a pithier manner...

Exceptions are for Exceptional circumstances

If this method is pure data access layer, I would say that given some parameter that gets included in a select statement, it would expect that I may not find any rows from which to build an object, and therefore returning null would be acceptable as this is data access logic.

On the other hand, if I expected my parameter to reflect a primary key and I should only get one row back, if I got more than one back I would throw an exception. 0 is ok to return null, 2 is not.

Now, if I had some login code that checked against an LDAP provider then checked against a DB to get more details and I expected those should be in sync at all times, I might toss the exception then. As others said, it's business rules.

Now I'll say that is a general rule. There are times where you may want to break that. However, my experience and experiments with C# (lots of that) and Java(a bit of that) has taught me that it is much more expensive performance wise to deal with exceptions than to handle predictable issues via conditional logic. I'm talking to the tune of 2 or 3 orders of magnitude more expensive in some cases. So, if it's possible your code could end up in a loop, then I would advise returning null and testing for it.

Jim Leonardo
+2  A: 

Forgive my pseudo-php/code.

I think it really depends on the intended use of the result.

If you intend to edit/modify the return value and save it, then return an empty object. That way, you can use the same function to populate data on a new or existing object.

Say I have a function that takes a primary key and an array of data, fills the row with data, then saves the resulting record to the db. Since I'm intending to populate the object with my data either way, it can be a huge advantage to get an empty object back from the getter. That way, I can perform identical operations in either case. You use the result of the getter function no matter what.

Example:

function saveTheRow($prim_key, $data) {
    $row = getRowByPrimKey($prim_key);

    // Populate the data here

    $row->save();
}

Here we can see that the same series of operations manipulates all records of this type.

However, if the ultimate intent of the return value is to read and do something with the data, then I would return null. This way, I can very quickly determine if there was no data returned and display the appropriate message to the user.

Usually, I'll catch exceptions in my function that retrieves the data (so I can log error messages, etc...) then return null straight from the catch. It generally doesn't matter to the end user what the problem is, so I find it best to encapsulate my error logging/processing directly in the function that gets the data. If you're maintaining a shared codebase in any large company this is especially beneficial because you can force proper error logging/handling on even the laziest programmer.

Example:

function displayData($row_id) {
    // Logging of the error would happen in this function
    $row = getRow($row_id);
    if($row === null) {
        // Handle the error here
    }

    // Do stuff here with data
}

function getRow($row_id) {
 $row = null;
 try{
     if(!$db->connected()) {
   throw excpetion("Couldn't Connect");
  }

  $result = $db->query($some_query_using_row_id);

  if(count($result) == 0 ) {
   throw new exception("Couldn't find a record!");
  }

  $row = $db->nextRow();

 } catch (db_exception) {
  //Log db conn error, alert admin, etc...
  return null; // This way I know that null means an error occurred
 }
 return $row;
}

That's my general rule. It's worked well so far.

kevinh456
+3  A: 

Hi, I'm a french IT student, so excuse my poor english. In our classes we are being told that such a method should never return null, nor an empty object. The user of this method is supposed to check first that the object he is looking for exists before trying to get it.

Using Java, we are asked to add a assert exists(object) : "You shouldn't try to access an object that doesn't exist"; at the beginning of any method that could return null, to express the "precondition" (I don't know what is the word in english).

IMO this is really not easy to use but that's what I'm using, waiting for something better.

Saend
Thanks you for your answer. But I dislike the idea of checking first if it exists. The reason is that generates an additional query to the database. In a application that is being accessed by millions of people in a day this can result in dramatic performance loss.
Roberto Sebestyen
secoif
+2  A: 

If the case of the user not being found comes up often enough, and you want to deal with that in various ways depending on circumstance (sometimes throwing an exception, sometimes substituting an empty user) you could also use something close to F#'s Option or Haskell's Maybe type, which explicitly seperates the 'no value' case from 'found something!'. The database access code could look like this:

public Option<UserEntity> GetUserById(Guid userId)
{
 //Imagine some code here to access database.....

 //Check if data was returned and return a null if none found
 if (!DataExists)
    return Option<UserEntity>.Nothing; 
 else
    return Option.Just(existingUserEntity);
}

And be used like this:

Option<UserEntity> result = GetUserById(...);
if (result.IsNothing()) {
    // deal with it
} else {
    UserEntity value = result.GetValue();
}

Unfortunately, everybody seems to roll a type like this of their own.

yatima2975
+1  A: 

More meat to grind: let's say my DAL returns a NULL for GetPersonByID as advised by some. What should my (rather thin) BLL do if it receives a NULL? Pass that NULL on up and let the end consumer worry about it (in this case, an ASP.Net page)? How about having the BLL throw an exception?

The BLL may be being used by ASP.Net and Win App, or another class library - I think it is unfair to expect the end consumer to intrinsically "know" that the method GetPersonByID returns a null (unless null types are used, I guess).

My take (for what it's worth) is that my DAL returns NULL if nothing is found. FOR SOME OBJECTS, that's ok - it could be a 0:many list of things, so not having any things is fine (e.g. a list of favourite books). In this case, my BLL returns an empty list. For most single entity things (e.g. user, account, invoice) if I don't have one, then that's definitely a problem and a throw a costly exception. However, seeing as retrieving a user by a unique identifier that's been previously given by the application should always return a user, the exception is a "proper" exception, as in it's exceptional. The end consumer of the BLL (ASP.Net, f'rinstance) only ever expects things to be hunky-dory, so an Unhandled Exception Handler will be used instead of wrapping every single call to GetPersonByID in a try - catch block.

If there is a glaring problem in my approach, please let me know as I am always keen to learn. As other posters have said, exceptions are costly things, and the "checking first" approach is good, but exceptions should be just that - exceptional.

I'm enjoying this post, lot's of good suggestions for "it depends" scenarios :-)

Mike Kingscott
And of course, today I've come across a scenario where I'm going to return NULL from my BLL ;-) That said, I could still throw an exception and use try / catch in my consuming class BUT I still have a problem: how does my consuming class know to use a try / catch, similar how do they know to check for NULL?
Mike Kingscott
You can document that a method throws an exception via the @throws doctag and you'd document the fact it can return null in the @return doctag.
secoif
+2  A: 

Interesting question and I think there is no "right" answer, since it always depends on the responsibility of your code. Does your method know if no found data is a problem or not? In most cases the answer is "no" and that's why returning null and letting the caller handling he situation is perfect.

Maybe a good approach to distinguish throwing methods from null-returning methods is to find a convention in your team: Methods that say they "get" something should throw an exception if there is nothing to get. Methods that may return null could be named differently, perhaps "Find..." instead.

Marc Wittke
+1 I like the idea to use a uniform naming convention for signaling to the programmer how that function is to be consumed.
Roberto Sebestyen
Suddenly I recognize that this is what LINQ does: consider First(...) vs. FirstOrDefault(...)
Marc Wittke
+2  A: 

If the object returned is something that can be iterated over, I would return an empty object, so that I don't have to test for null first.

Example:

bool IsAdministrator(User user)
{
    var groupsOfUser = GetGroupsOfUser(user);

    // This foreach would cause a run time exception if groupsOfUser is null.
    foreach (var groupOfUser in groupsOfUser) 
    {
        if (groupOfUser.Name == "Administrators")
        {
            return true;
        }
    }

    return false;
}
Jan Aagaard
+3  A: 

Yet another approach involves passing in a callback object or delegate that will operate on the value. If a value is not found, the callback is not called.

public void GetUserById(Guid id, UserCallback callback)
{
    // Lookup user
    if (userFound)
        callback(userEntity);  // or callback.Call(userEntity);
}

This works well when you want to avoid null checks all over your code, and when not finding a value isn't an error. You may also provide a callback for when no objects are found if you need any special processing.

public void GetUserById(Guid id, UserCallback callback, NotFoundCallback notFound)
{
    // Lookup user
    if (userFound)
        callback(userEntity);  // or callback.Call(userEntity);
    else
        notFound(); // or notFound.Call();
}

The same approach using a single object might look like:

public void GetUserById(Guid id, UserCallback callback)
{
    // Lookup user
    if (userFound)
        callback.Found(userEntity);
    else
        callback.NotFound();
}

From a design perspective, I really like this approach, but has the disadvantage of making the call site bulkier in languages that don't readily support first class functions.

Marc
Interesting. When you started talking about delegates, I immediately started wondering if Lambda expressions could be used here.
Roberto Sebestyen
Yup! As I understand it, C# 3.0 and up's lambda syntax is basically syntactic sugar for anonymous delegates.Similarly in Java, without the nice lambda or anonymous delegate syntax, you can simply create an anonymous class. It's a bit uglier, but can be really handy.I suppose these days, my C# example could have used Func<UserEntity> or something like it instead of a named delegate, but the last C# project I was on was still using version 2.
Marc
+1 I like this approach. A problem though is that it's not conventional and slightly increases the barrier to entry for a codebase.
secoif
+1  A: 

I tend to

  • return null if the object id doesn't exist when it's not known beforehand whether it should exist.
  • throw if the object id doesn't exist when it should exist.

I differentiate these two scenarios with these three types of methods. First:

Boolean TryGetSomeObjectById(Int32 id, out SomeObject o)
{
    if (InternalIdExists(id))
    {
        o = InternalGetSomeObject(id);

        return true;
    }
    else
    {
        return false;
    }
}

Second:

SomeObject FindSomeObjectById(Int32 id)
{
    SomeObject o;

    return TryGetObjectById(id, out o) ? o : null;
}

Third:

SomeObject GetSomeObjectById(Int32 id)
{
    SomeObject o;

    if (!TryGetObjectById(id, out o))
    {
        throw new SomeAppropriateException();
    }

    return o;
}
Johann Gerell
You mean `out` not `ref`
Matt Ellen
@Matt: Yes, sir, I most certainly do! Fixed.
Johann Gerell