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.
I too am a fan of Linq to SQL. I've taken a lot of flack for it from other developers though. The ONLY advantage I can think of for EF is that it's database agnostic, supposedly making it easier to change database engines...but I think that's an awful idea. Changing database engines is a big deal and should be treated as such!
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.