Hi,
I have the following query
DetachedCriteria criteria = DetachedCriteria.For(typeof
(Model.Course), "course")
.CreateAlias("course.SubjectArea", "subjectArea")
.CreateCriteria("course.Institution",
"institution")
.Add(Expression.Eq("subjectArea.WeeklyFeeType",
true))
.SetProjection(Projections.ProjectionList()
.Add(Projections.Property("institution.Id"),
"InstitutionId")
.Add(Projections.Property("institution.Name"),
"InstitutionName")
.Add(Projections.Property("course.Id"),
"CourseId")
.Add(Projections.Property("course.Title"),
"CourseTitle")
.Add(Projections.Constant(0),
"SemesterId")
.Add(Projections.Constant(string.Empty),
"SemesterTitle")
.Add(Projections.Constant(startDate),
"StartDate")
.Add(Projections.Constant(startDate.AddDays(weeks
* 7)), "EndDate")
)
.SetResultTransformer(Transformers.AliasToBean(typeof
(CourseDetail)));
If is mapping to my DTO from my query, wierd thing is it is failing,
if you look at the SQL it is not setting the correct value for the
Expression, it is this WHERE subjectare1_.WeeklyFeeType = @p4, and p4
= A date that was passed in.
Why is it not mapping across corectly, I am using NHibernate 2.0
exec sp_executesql N'SELECT TOP 10 y0_, y1_, y2_, y3_, y4_, y5_, y6_,
y7_ FROM (SELECT ROW_NUMBER() OVER(ORDER BY __hibernate_sort_expr_0__)
as row, query.y0_, query.y1_, query.y2_, query.y3_, query.y4_,
query.y5_, query.y6_, query.y7_, query.__hibernate_sort_expr_0__ FROM
(SELECT institutio2_.ID as y0_, institutio2_.Name as y1_, this_.ID as
y2_, this_.Title as y3_, @p0 as y4_, @p1 as y5_, @p2 as y6_, @p3 as
y7_, CURRENT_TIMESTAMP as __hibernate_sort_expr_0__ FROM
Phoenix2008.dbo.Courses this_ inner join Phoenix2008.dbo.Institutions
institutio2_ on this_.InstitutionID=institutio2_.ID inner join
Phoenix2008.dbo.SubjectAreas subjectare1_ on
this_.SubjectAreaID=subjectare1_.ID WHERE subjectare1_.WeeklyFeeType =
@p4) query ) page WHERE page.row > 0 ORDER BY
__hibernate_sort_expr_0__',N'@p0 bit,@p1 int,@p2 nvarchar(4000),@p3
datetime,@p4 datetime',@p0=1,@p1=0,@p2=N'',@p3='Sep 17 2008
10:20:53:707AM',@p4='Oct 22 2008 10:20:53:707AM'
Cheers
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
