Re: Dynamic ORM?
I use a self created ORM solution where the DAL DLL does not need changing between projects as it maps the entity object to the appropriate stored proc based on custom class attributes. A custom built code gen builds the entities and stored procs (as well as WPF MVVM View & VM, ASP.NET Forms & usercontrols) based on the db structure, so any changes to the database are easily updated in the stored proc, and then in the entity classes. Thinking of making it available for sale, hopefully sometime this year... Ideas are far outweighing my time availability at this point. Grant On Fri, May 6, 2011 at 12:06 AM, Anthony wrote: > Anyone aware of a dynamic orm software. Been using llblgen for years and > finding the need for a dynamic orm. > > > > I find that some database create custom fields etc at runtime which do not > become visible to the ORM until I re-apply the ORM schema. If I re-apply > orm to a db with customer fields, then it makes the orm code specific to > one environment…. > > > > regards > > Anthony (*12QWERNB*) > > > > >
Re: Dynamic ORM?
I've heard of a few projects that needed to do something like this (mingle is one that comes to mind) where the structure of your entities can be modified at runtime. It gets really complicated very quickly - especially in getting the implementation to perform adequately. This seems a better fit for a non relational database such as mongodb, ravendb, couchdb etc. if that's an available option. On Fri, May 6, 2011 at 12:06 AM, Anthony wrote: > Anyone aware of a dynamic orm software. Been using llblgen for years and > finding the need for a dynamic orm. > > > > I find that some database create custom fields etc at runtime which do not > become visible to the ORM until I re-apply the ORM schema. If I re-apply > orm to a db with customer fields, then it makes the orm code specific to > one environment…. > > > > regards > > Anthony (*12QWERNB*) > > > > >
Re: Dynamic ORM?
Performance nat an issue.. Test harness proves its quicker than linq for same query (single and multi record). it also returns multi resultsets with good speed too. 10 result sets from 1 stored proc in 20 millisecs. On 5/8/11, Mark Ryall wrote: > I've heard of a few projects that needed to do something like this (mingle > is one that comes to mind) where the structure of your entities can be > modified at runtime. It gets really complicated very quickly - especially > in getting the implementation to perform adequately. > > This seems a better fit for a non relational database such as mongodb, > ravendb, couchdb etc. if that's an available option. > > On Fri, May 6, 2011 at 12:06 AM, Anthony wrote: > >> Anyone aware of a dynamic orm software. Been using llblgen for years and >> finding the need for a dynamic orm. >> >> >> >> I find that some database create custom fields etc at runtime which do not >> become visible to the ORM until I re-apply the ORM schema. If I >> re-apply >> orm to a db with customer fields, then it makes the orm code specific to >> one environment…. >> >> >> >> regards >> >> Anthony (*12QWERNB*) >> >> >> >> >> > -- Sent from my mobile device