The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
Some don't seem to know the difference between an ORM and a "database engine"; and expect what is essentially a "logical entity to physical entity mapping" to behave like an SQL optimizer; and that "views", stored procs and sql pass through are now "no longer required".
They also confuse "operational" versus "informational"; ORM's are more applicable to LOB than data warehousing (and denormalizing).
I use EF (code first); and use it before resorting / supplementing with DDL and DML.
It's not "all or nothing". EF (i.e. ORM's) can co-exisit with other access methods.
As some pointed out, use ORM for CRUD (if you will); use BI for the informational; and "raw" for the rest.
And "data transfer objects" are a valid pattern; and not necessarily "redundant". With consistent naming, copying can be done via reflection.
"(I) am amazed to see myself here rather than there ... now rather than then".
― Blaise Pascal
Before they "upgraded" us to Win10, I had a utility called WinSCP (FTP app) on my box. We use it to transfer files in SSIS packages.
After Win10, I had to request that my "special apps" be reinstalled. It turns out that I'm not supposed to have WinSCP on my machine, and that it can only be installed on database servers. So now, IA is freaking out, and I'm probably going to have to jump through absurd and pointless hoops to test a package that needs to download a file via FTP.
So now, I'm waiting for our dba guy to tell me how to modify our packages to run the copy on the server. I imaging that I'll have to have a UNC path, but what about credentials? And if they give me the credentials to run it remotely on the server, why would that be any different than just running it on my own machine - without credentials - like I've been doing for the last 4+ years?
I thought about just writing my own FTP retrieval script task, but they've probably blocked the port at the firewall, and if anyone tries to use it, security gestapo will descend on that person and escort them out of the building...
I hate this job.
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
My current job is (usually) pretty sweet. No one to tell me what to do or how to do it (the latter is nice) - although yesterday I was considering homicidal thoughts as a good thing. Still, it was a moron, not the management.
That being said, the 'new guard' is taking over the company and whilst some are aware of how few people are keeping the wheels on their bus rolling, some don't. Mainly - I work via reputation. I'll say what I mean, do a really good job, and give idiots a hard time because not only do they deserve it, but it amuses me.
For now, however, it's still fun. Some jerks here and there to contend with - but that's why they call it work and have to pay us.
I left that part out - my boss (IT director) and I work very closely on development (he still is fully down in the trenches). When planning something, if we both had ideas on how to go about it, we'd fight it out and pick the better of the two, a hybrid, or something altogether new that came out of it. It didn't matter - we both wanted the best solution.
I cannot say the same for the rest of the department. I'm so autonomous from the rest of them that it's only an occasional annoyance when someone doesn't do their job (even when it's very easy). Sadly, for a few, I no longer as they say "have their backs" and they've past all pretense on my part that they're just simply as dumb as the users.
There was a short period of a couple of years when everyone pulled together. Still - there's the fun of coding and seeing/knowing five hundred or so users/day have your work in front of them.
And, finally, when dealing with the idiots my credo is: "Diplomacy? We don't need no stinkin' Diplomacy!"