Re: Detecting a Null field on an NpgsqlDataReader object
"Francisco Figueiredo Jr." <[email protected]> Tue, 3 Aug 2010 13:32:01 -0300
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
On Tue, Aug 3, 2010 at 12:25, Oliveiros d'Azevedo Cristina <[email protected]> wrote: > Dear All, > Hi! > How can I detect if a certain field of a record returned by a query is NULL > ? > > I'm sure there must be a direct way of doing this, but I googled up and > down, back and forth and was unable to find out. > > For ex, in Sql Server we just compare with DbNull singleton. > > What is the equivalent in Npgsql? > You can use the same way. Npgsql uses DBNull singleton to express null values. If you are trying to check in the NpgsqlDataReader, you will need to use the method IsDBNull(int) I hope it helps. -- Regards, Francisco Figueiredo Jr. Npgsql Lead Developer http://www.npgsql.org http://fxjr.blogspot.com http://twitter.com/franciscojunior -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces