Last post Aug 10, 2013 04:10 AM by Mikesdotnetting
Aug 10, 2013 02:45 AM|mvc42013|LINK
I need to implement a module and requirement is as following..
There are four table in database and user wants to have an interface where he can choose a table and then column and apply some condition along with Join like left and right and he wants to save this as a report reason for it simple the no of record that
are there in table are in millions so if we save it (somehwhere) and then have a window based service picking up that saved selection can generate that report.
What is the best way to solve it.
I've two things in mind one is use expression Builder but not sure how and where will i save this selected section another solution that I've in mind is to store these selected in database and have one proc making a proper SQL select statement.
which solution is best in the given situation?
my user wants to
Aug 10, 2013 04:10 AM|Mikesdotnetting|LINK
Whenever I have done this kind of thing, I store the selection criteria in a database and then use it to generate a dynamic SQL statement, which is what I execute using ADO.NET to produce the report. It's the easiest approach.