I am not sure about this, but try taking "type" attribute out of your mapping and let NH figure out what the type is.
On Mar 27, 1:43 pm, joshlrogers <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
