Yeppers. This isn't making any sense as to why it isn't working all of a sudden. We are ditching NHibernate on these pages and using stored procedures instead. Thank you all for the help!
On Monday, July 18, 2016 at 1:44:44 PM UTC-5, Oskar Berggren wrote: > > The exception mentions ShowRoom.Vehicle property setter. Have you followed > up what's going on in there? And it's mapping? > > /Oskar > Den 18 juli 2016 5:47 em skrev "Jamie D" <[email protected] <javascript:> > >: > >> That's the weird part, the data matches the database values correctly and >> mostly everything is nullable types so labeled as int? in the mapping. I've >> had the NHibernate guru in the office look at this too and he doesn't see >> where the issue is either. The db looks like this: >> >> ID int not nullable >> SiteID smallint not nullable >> Name varchar(200) not nullable >> Make varchar(50) allow nulls >> Model varchar(200) allow nulls >> BodyStyle varchar(100) allow nulls >> Engine varchar(100) allow nulls >> DriveType varchar(50) allow nulls >> Transmission varchar(50) allow nulls >> StockNumber varchar(50) allow nulls >> ExteriorColor varchar(100) allow nulls >> InteriorColor varchar(100) allow nulls >> Warranty varchar(MAX) allow nulls >> Price decimal (19,2) allow nulls >> VIN varchar(100) allow nulls >> Mileage int allow nulls >> Year varchar(50) allow nulls >> Description varchar(MAX) allow nulls >> Options varchar(MAX) allow nulls >> Specs varchar(MAX) allow nulls >> [Order] int not nullable >> Active bit not nullable >> LastUpdated datetime not nullable >> DateCreated datetime not nullable >> >> I've even tried deleting the last couple items that were added to the >> database in the past couple weeks and it doesn't seem to help. I will keep >> looking but I'm stumped with this one. >> >> On Friday, July 15, 2016 at 5:40:51 PM UTC-5, Gunnar Liljas wrote: >>> >>> You say you've run it against the same database, but have you looked at >>> exactly the same data? >>> >>> It seems the data doesn't quite match the property types. Maybe you have >>> an int property and the database returns NULL? >>> >>> Although it's not likely relevant, the LazyLoad mapping instructions are >>> redundant. Lazy=true is the default. >>> >>> /G >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/nhusers. >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
