Re: Entity Framework - the lay of the land

2017-01-03 Thread David Connors
On Tue., 3 Jan. 2017, 7:16 pm Greg Keogh, wrote: > What I liked about netTiers was that the CRUD was basically table-based > and not over-engineered like many famous ORMs (including EF) and it just > threw a really handy bridge at the lowest useful level between classes and >

Re: Entity Framework - the lay of the land

2017-01-03 Thread Grant Maw
Sorry for the late reply, only just seen this thread. As Stephen Price said back in September, I have been using CodeSmith to generate my stored procs and DAL for well over a decade. Our templates have changed as language improvements and new product features have come along, but the underlying

Re: Entity Framework - the lay of the land

2017-01-03 Thread Tony Wright
I have used Entity Framework myself but generally simply map to stored procs. Some Linq occasionally creeps in, but the biggest gripe I have with EF is the lazy loading. It can get nasty very quickly generating ridiculous amounts of unnecessary traffic as it loads every linked object it comes

Re: Entity Framework - the lay of the land

2017-01-03 Thread Greg Keogh
> > >turn off lazy loading and use eager loading instead. > Hell yeah! > Stored procs are best, of course, as it's often much easier to get stored > proc changes through change control in enterprises than code changes in an > app, which requires virtually a compete redeploy. > Mostly hell

RE: Entity Framework - the lay of the land

2017-01-03 Thread 罗格雷格博士
“ORMs are still a real coding productivity boost,” Are they though? I see them knock at best 10% off a dev project, and that dev work is at best probably 10% of the lifetime cost of the project. So a 1% overall saving in project cost ends up determining and limiting so many aspects of the

Re: Entity Framework - the lay of the land

2017-01-03 Thread Greg Keogh
Hi Grant et al, You're psychic, as I was going to post on this old topic later in the week, as I've rejigged my thinking a little in recent months. I also used CodeSmith to make CRUD for a few good years and I was impressed by how easy it was. I used the netTiers templates, not handmade. What I

RE: Entity Framework - the lay of the land

2017-01-03 Thread Tony Wright
I often wish there was a better lightweight or that generated chide for you from stored procs - dapper on steroids. Perhaps I should write one! On 3 Jan 2017 5:31 PM, "Greg Low (罗格雷格博士)" wrote: > “ORMs are still a real coding productivity boost,” > > > > Are they though? I see

Re: Entity Framework - the lay of the land

2017-01-03 Thread David Connors
On Tue., 3 Jan. 2017, 8:07 pm David Connors, wrote: > On Tue., 3 Jan. 2017, 7:16 pm Greg Keogh, wrote: > > Maybe even David C wouldn't turn his nose up at that?! > > > I probably would. But I have a very different set of drivers to most > everyobe else in