Yes this is definite. I run a query through a plain old data set and
they return null. I have verified my database design as well....just
for clarification sake:
CREATE TABLE [dbo].[tblCWTRatingGroups](
[Id] [int] IDENTITY(0,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
[UserAdded] [int] NOT NULL,
[DateAdded] [datetime] NOT NULL,
[UserEdited] [int] NULL,
[DateEdited] [datetime] NULL,
CONSTRAINT [PK_tblCWTRatingGroups] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY
= OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 20)
ON [PRIMARY]
) ON [PRIMARY]
That was taken straight from SQL Server Management Studio....
Thank you,
Josh
On Mar 27, 1:29 pm, James Gregory <[email protected]> wrote:
> Just to confirm, your columns in your database definitely are nullable?
>
> On Fri, Mar 27, 2009 at 5:59 PM, joshlrogers <[email protected]> wrote:
>
> > Hello,
>
> > I am having an issue with nullable fields. I have specified the
> > valuetypes as being nullable, respectively DateTime? and int?. The
> > constructor of the class sets these values to null as well. My
> > mapping is as such:
>
> > <?xml version="1.0" encoding="utf-8" ?>
> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
> > assembly="TEAMS_ORM">
> > <class name ="TEAMS_ORM.CWTRatingGroup,TEAMS_ORM"
> > table="tblCWTRatingGroups">
>
> > <id name="Id" column="Id" type="Int32" unsaved-value="-1">
> > <generator class="native" />
> > </id>
>
> > <property name="Name" column="Name" length="50"
> > type="String" not-
> > null="true" unique="true" />
> > <property name="UserAdded" column="UserAdded" type="Int32"
> > not-
> > null="true" />
> > <property name="DateAdded" column="DateAdded"
> > type="DateTime" not-
> > null="true" />
> > <property name="UserEdited" column="UserEdited" type="Int32"
> > not-
> > null="false" />
> > <property name="DateEdited" column="DateEdited"
> > type="DateTime" not-
> > null="false" />
>
> > </class>
>
> > </hibernate-mapping>
>
> > UserEdited and DateEdited are the required fields. When I make
> > updates or saves to the db it will successfully pass nulls. However
> > when it retrieves from the DB and the fields are NULL it populates the
> > fields with arbitrary values however I need them to be null. This is
> > my retrieve query:
>
> > return (List<CWTRatingGroup>)session.CreateQuery("select from
> > TEAMS_ORM.CWTRatingGroup").List<CWTRatingGroup>();
>
> > How do I achieve this?
>
> > Thank you in advance,
> > Josh
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
