My solution can create classes based on the LINQ2SQL active records, and CRUD ASP.NET screens for those. I only really use it for Admin / Reference screens though, since your object model and database schema are often fundamentally at odds (since they [should] represent different things).
As for Grant's Stored Proc idea - my old code template schema's did a similar thing - and it is slightly faster, and there are security advantages (individual stored procs can be given different rights). But I'm hooked to the flexibility that LINQ provides, and the bells and whistles like lazy loading. On Sun, May 8, 2011 at 11:44 AM, Grant Molloy <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> 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 >
