|
That ORM question got me thinkin....
I LOVE Linq-To-SQL. It's easy to use and easy to maintain, and doesn't include all the baggae that ORM's typically include.
So I'm curious.. How many of you still use Linq-To-SQL vs ORM's or something else?
Inquiring minds wanna know..
If it's not broken, fix it until it is
|
|
|
|
|
I use neither. 
I use techniques that served me before .net and will continue to serve me after .net is gone.
Do you have an ORM that works with ANSI C and RDB on OpenVMS?  I thought not.
|
|
|
|
|
They rode horses to work before .net and painted pictures on cave walls, too. 
|
|
|
|
|
Oog!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Didn't they stop development on it 2-3 years ago?
|
|
|
|
|
Stop dev on Linq-To-Sql??
If it's not broken, fix it until it is
|
|
|
|
|
It has not been updated or improved since the .NET 3.5 release. That was 7 years ago.
|
|
|
|
|
Maybe they simply got it right back then 
If it's not broken, fix it until it is
|
|
|
|
|
No harm in using it, just that you may miss out on new optimizations and features available in newer releases of Entity Framework, specially those that take advantage of new functionality in recent versions of SQL Server.
|
|
|
|
|
|
Still using raw sql and datareaders. No ORM, every query hand-crafted.
Works as great as it did ten years ago 
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Even (nearly) fifteen years ago.
modified 16-Feb-16 14:40pm.
|
|
|
|
|
..if possible, I try to remain SQL92 compliant. Works on most systems, from Sql Server to SQLite.
It's good to have standards 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
|
Prior to 2002 and .net, I was using PL/SQL embedded in C. 
ADO.net has allowed me to work with many more database systems. ![Jig | [Dance]](https://www.codeproject.com/script/Forums/Images/jig.gif)
|
|
|
|
|
PIEBALDconsult wrote: Prior to 2002 and .net, I was using PL/SQL embedded in C.
Oracle 7.
Yes, good times.
PIEBALDconsult wrote: ADO.net has allowed me to work with many more database systems. [Dance]
I can't comment on C, but it is a lot simpeler than having "some" ODBC connection in Delphi. And I am not missing the "begin" and "end" keywords around every method
..not much at least.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: every query hand-crafted
You have got to be joking, you type out every CRUD query/stored proc? What a monumental waste of effort that must be.
I refuse to allow any commercial ORMs on site but have written our own, sort of. I have not hand coded a CRUD proc for over 20 years.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
That's because the concept of "CRUD" is nonsense. Lucrative nonsense for tool merchants and their fear-mongers.
|
|
|
|
|
You are going to have to elaborate on that a little, as it is the statement does not seem to make sense.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: You have got to be joking, you type out every CRUD query/stored proc?
Rather quick with templates and intellisense.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I want to use one of the 3 ORM options (NHibernate, EntityFramework and LinqToSql) in my application which one is the better? and what is the advantages of it over than others?
|
|
|
|
|
If I were developing the application, I'd avoid using an ORM altogether. I don't like the lack of fine grained control they present and the fact that they largely constrain me to doing things in certain prescribed ways - as soon as I want to do something out of the ordinary, things become a lot harder.
Now, as to your question - only you can answer that. We don't know what your application is, what it does, how it scales, etc. You might as well go to your local swimming baths and say "I want to buy a car. A Mercedes, a Volkswagen or a Ford. Which is better and why?"
This space for rent
|
|
|
|
|
My Application is a an MVC web application
|
|
|
|
|
So you've said you want the red car.
That tells you nothing about your application other than the platform you want it to run on. In order for YOU to answer your question, you are going to have to actually break down your requirements. Never, ever start from the point of "I want to use this technology". Instead, you start from the point of view, "I have these requirements X, Y and Z. What technology will best serve those requirements and won't constrain me to use only A, B and C?" In other words, you are asking the wrong questions. Go back and start again.
This space for rent
|
|
|
|
|
Pete O'Hanlon wrote: So you've said you want the red car.
Or...
"I want to cruise up the coast to Santa Barbara with my girlfriend. My girlfriend never packs light. Should I drive a Mack truck or a Peterbilt? A cab-over or a conventional?" 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
