tag:blogger.com,1999:blog-3546853750439504984.post3701569335495553752..comments2023-10-22T21:30:46.731+05:30Comments on Explore with Koushik Das: Showing Reports by ReportViewer Control and NHibernateKoushik Dashttp://www.blogger.com/profile/01743430477450345642noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-3546853750439504984.post-74919648621652370672008-12-17T01:03:00.000+05:302008-12-17T01:03:00.000+05:30Hi Koushik and ChrisI have a complex NHibernate bu...Hi Koushik and Chris<BR/><BR/>I have a complex NHibernate business obecjt that returns an IList of Employees. The Employee class has a List of Rules. Each employee has a list of rules associated with him. How do I go about doing this. Tried creating a dataset, but the report still does not show one-many relationship. Any help is greatly apprecitaed. Thanks.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3546853750439504984.post-40714113284260082462008-08-11T17:47:00.000+05:302008-08-11T17:47:00.000+05:30Because I am replacing the data access layer of a ...Because I am replacing the data access layer of a legacy application. We extract quite complex information from the database of another application by using stored procedures. Unfortunately this cannot be changed to to technical and political reasons. So I need to either get access to those sp's through NHibernate or code side by side.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3546853750439504984.post-19913652518998095292008-08-06T17:04:00.000+05:302008-08-06T17:04:00.000+05:30No exactly... but why do you need stored procs whi...No exactly... but why do you need stored procs while using NHibernate itself?<BR/><BR/>-- KoushikKoushik Dashttps://www.blogger.com/profile/01743430477450345642noreply@blogger.comtag:blogger.com,1999:blog-3546853750439504984.post-6178071107247754332008-08-05T19:36:00.000+05:302008-08-05T19:36:00.000+05:30Quite true. ;)Btw. do you have any experiences in ...Quite true. ;)<BR/><BR/>Btw. do you have any experiences in working with stored procedures with NHibernate?<BR/><BR/>Cheers,<BR/>ChrisAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3546853750439504984.post-12736104206082256232008-08-05T10:40:00.000+05:302008-08-05T10:40:00.000+05:30Yes Christian, you are right. I have wrote this in...Yes Christian, you are right. I have wrote this in my another blog. <BR/>It is definitely possible but it has some limitation like you have to have the dataset(xsd) fieldname same as your NHibernate object's property name.<BR/><BR/>-- KoushikKoushik Dashttps://www.blogger.com/profile/01743430477450345642noreply@blogger.comtag:blogger.com,1999:blog-3546853750439504984.post-53119340265149241902008-08-04T19:40:00.000+05:302008-08-04T19:40:00.000+05:30Hi there,After having found out myself how to acco...Hi there,<BR/><BR/>After having found out myself how to accomplish this (I also noticed that there are actually no resources on the internet... *sigh*), I also found your blog entry.<BR/><BR/>There's one step though, that you did more than I and I guess I know why:<BR/>You not only define the typed dataset so that you are able to design the report, you also fill it with the data you retrieve with NHibernate and use it as data source for your report.<BR/><BR/>I believe this is not necessary. When you look at the rdlc file with a text editor, you notice that it only needs the dataset (xsd) for getting to know the structure of the data that is about to be passed. Since you defined the structure already exactly as it looks like from NHibernate's point of view, you don't need the dataset anymore. <BR/><BR/>You can simply pass the data access object you get from NHibernate directly to the report and voila, it works. ;-)<BR/><BR/>Actually, after you got all this to work, you could even delete the xsd file. However, ... of course editing the rdlc by hand is not really comfortable, so it might be better to leave it.<BR/><BR/>Best regards,<BR/>Chris.Anonymousnoreply@blogger.com