Joined: 18 Oct 2015
Topic: Design question
Posted: 03 Nov 2015 at 5:52pm
I am unsure how to achive this and would be glad for every input. :- ) Thank you.
Before Aurelius I had in my forms a feature called "advanced search". There the user was able to select item from a combobox which in turn were linked to SQL WHERE statements. These SQL statements were WHERE-clauses and were stored one by one in a table. When the user selected one item from the Combobox, the corresponding WHERE was retrievd, the base SQL statement was concatenated with the WHERE and voila the query could be executed.
Additionally, these statements could maintained without altering the program. Importing additional statements was possible without changing database or program.
Now I have Aurelius and am unsure in which direction to think. Is it possible to serialize an Aurelius-condition/where`/criteria? Should I use kind of META SQL and build Aurelius criterias on the fly?
BTW: Is it possible to persist an Aurelius criterias?
Am I missing something?
Wagner R. Landgraf
Joined: 18 May 2010
|Post Options Quote Reply Posted: 03 Nov 2015 at 5:56pm|
With Aurelius I consider it's easier to build queries on the fly because it has an object model, i.e, you add condition objects to the query like TLinq.Eq, TLinq.LessThan, etc.. But yes, unfortunately, there is not build-in feature to persist the Aurelius criteria, you would have to serialize it yourself.
Or, if you don't want to change your application too much, you can just use the TLinq.SQL which adds SQL expressions to conditions.
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum