CRM day 999999 - Buildprovider DAL - subsonic dal is not sufficent -
It's been really busy since my last post, but I can allready tell you that I did not make the deadline.
Instead of using the SubSonic framework, I have been developping my own framework using buildproviders. The subsonic framework seemed to have a few things that were not really natural/flexible enough for me.
My own project is still in development, but I can assure you that I currently only need to implement some finetuning and cleanups. Lack of time is the main issue here.
Just a few hints :
- The model is built dynamically & based on the database structure and some default templates
- No mapping code required to start using the objects
- Inheritance is derived from the database model (some conventions need to be followed)
- The model supports intellisense
- DSL-like language with syntax-checking to create queries.
- The DAL only updates the fields that have changed, so no unnecessary updates
- The DAL supports updates and deletes using where clauses (like SQL)
- The DAL uses an SQL-Like syntax, see below !!!
Just to give you another clue, here's a question I got from somebody online (in Dutch).
(The explanation is also in Dutch, but since you can see the code (in bold) you can make your own mind up.)
>Momenteel ben ik bezig met mijn afstudeerproject voor mijn studie
>Informatica (HBO NL).
>Het afstudeerproject gaat over het maken van een DSL in JRuby/Ruby,
>het zelfde onderwerp waar jij in 2005 een topic over opende bij
>Ik vroeg mij af of je er nog verder mee bent gegaan en wat je
>ervaringen hierbij zijn.
>Alle suggesties, tips en hints zijn welkom.
>Ik hoop snel wat van je te horen.
>Met vriendelijke groet,
And my response to it :
Maybe (MAYBE) I'll release it on CodePlex if there are enough people asking the source... :P