ORM Quick Survey
-
I'm curious as to what ORM you use and why. For personal projects I use Linq to SQL and I love it. It's simple and works all the time. At work we're using Entity Framework and I detest it. It ALWAYS results in compilation errors and almost always generates entities wrong in some way. I'v heard of some folks here using their home rolled ORM's. For those of you, what ORM would yo say it most resembles?
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
-
I'm curious as to what ORM you use and why. For personal projects I use Linq to SQL and I love it. It's simple and works all the time. At work we're using Entity Framework and I detest it. It ALWAYS results in compilation errors and almost always generates entities wrong in some way. I'v heard of some folks here using their home rolled ORM's. For those of you, what ORM would yo say it most resembles?
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
Linq2SQL. And yes, my experiences with EF are similar. What's worse though is that a lot of the time, an ORM isn't necessary. Take a server-side query that is converted to JSON for displaying data on the client-side browser. Why go through an ORM? Yet I see people using EF to load the query into a model, then serialize the model into JSON, then return it to the client. Why go through that extra step? Or similarly, on a thick client, it's easy enough to data bind directly to a DataTable, even if it's only one row where you want to display the data in discrete fields rather than a grid, and you can wire up the events to track changes and persist the data for a responsive UI with little effort.
Latest Article - Building a Prototype Web-Based Diagramming Tool with SVG and Javascript Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny Artificial intelligence is the only remedy for natural stupidity. - CDP1802
-
Linq2SQL. And yes, my experiences with EF are similar. What's worse though is that a lot of the time, an ORM isn't necessary. Take a server-side query that is converted to JSON for displaying data on the client-side browser. Why go through an ORM? Yet I see people using EF to load the query into a model, then serialize the model into JSON, then return it to the client. Why go through that extra step? Or similarly, on a thick client, it's easy enough to data bind directly to a DataTable, even if it's only one row where you want to display the data in discrete fields rather than a grid, and you can wire up the events to track changes and persist the data for a responsive UI with little effort.
Latest Article - Building a Prototype Web-Based Diagramming Tool with SVG and Javascript Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny Artificial intelligence is the only remedy for natural stupidity. - CDP1802
I agree. But I find models useful when you need things like property change notification. They're also useful for representing a single data item. Passing a while DataTable around works but seems rather bulky to me. Probably 6 one way, half dozen the other. Thanks
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
-
I'm curious as to what ORM you use and why. For personal projects I use Linq to SQL and I love it. It's simple and works all the time. At work we're using Entity Framework and I detest it. It ALWAYS results in compilation errors and almost always generates entities wrong in some way. I'v heard of some folks here using their home rolled ORM's. For those of you, what ORM would yo say it most resembles?
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
Were I to use one it would be one I created. Third choice would be one from Microsoft, never from a third-party.
-
I'm curious as to what ORM you use and why. For personal projects I use Linq to SQL and I love it. It's simple and works all the time. At work we're using Entity Framework and I detest it. It ALWAYS results in compilation errors and almost always generates entities wrong in some way. I'v heard of some folks here using their home rolled ORM's. For those of you, what ORM would yo say it most resembles?
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
-
I'm curious as to what ORM you use and why. For personal projects I use Linq to SQL and I love it. It's simple and works all the time. At work we're using Entity Framework and I detest it. It ALWAYS results in compilation errors and almost always generates entities wrong in some way. I'v heard of some folks here using their home rolled ORM's. For those of you, what ORM would yo say it most resembles?
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
Kevin Marois wrote:
I'm curious as to what ORM you use and why.
I'm curious as to why you are curious
"Coming soon"
-
I'm curious as to what ORM you use and why. For personal projects I use Linq to SQL and I love it. It's simple and works all the time. At work we're using Entity Framework and I detest it. It ALWAYS results in compilation errors and almost always generates entities wrong in some way. I'v heard of some folks here using their home rolled ORM's. For those of you, what ORM would yo say it most resembles?
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
Just beginning with NHibernate, at first I was very skeptical, but now I am a bit milder. It was not my choice of course but imposed by management. Clearly this is not an ORM to use if you are in a hurry due to it's complexity ...
-
I'm curious as to what ORM you use and why. For personal projects I use Linq to SQL and I love it. It's simple and works all the time. At work we're using Entity Framework and I detest it. It ALWAYS results in compilation errors and almost always generates entities wrong in some way. I'v heard of some folks here using their home rolled ORM's. For those of you, what ORM would yo say it most resembles?
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
Linq2SQLalso, because as you say it just works. I also hate EF, it's a complicated POS and if you want to do anything out of the, what they obviously consider normal, you will have bend nails with your teeth to get it to work.
Everyone has a photographic memory; some just don't have film. Steven Wright
-
Linq2SQL. And yes, my experiences with EF are similar. What's worse though is that a lot of the time, an ORM isn't necessary. Take a server-side query that is converted to JSON for displaying data on the client-side browser. Why go through an ORM? Yet I see people using EF to load the query into a model, then serialize the model into JSON, then return it to the client. Why go through that extra step? Or similarly, on a thick client, it's easy enough to data bind directly to a DataTable, even if it's only one row where you want to display the data in discrete fields rather than a grid, and you can wire up the events to track changes and persist the data for a responsive UI with little effort.
Latest Article - Building a Prototype Web-Based Diagramming Tool with SVG and Javascript Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny Artificial intelligence is the only remedy for natural stupidity. - CDP1802
Right, I haven't yet encountered a database access situation that couldn't easily be dealt with by using DataReaders, DataTables, DataViews, DataRows, etc. Microsoft even provides DataAdapters (ptui) for Bob's sake! ORMs are definitely a solution looking for a problem.
-
Right, I haven't yet encountered a database access situation that couldn't easily be dealt with by using DataReaders, DataTables, DataViews, DataRows, etc. Microsoft even provides DataAdapters (ptui) for Bob's sake! ORMs are definitely a solution looking for a problem.
But wait... it's a shiny new UI tool with cool graphics... so we NEED it.
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
-
Kevin Marois wrote:
I'm curious as to what ORM you use and why.
I'm curious as to why you are curious
"Coming soon"
Like I said, I really like Linq to Sql, but it's an older technology. Got me thinking about what ppl are using these days.
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
-
Linq2SQLalso, because as you say it just works. I also hate EF, it's a complicated POS and if you want to do anything out of the, what they obviously consider normal, you will have bend nails with your teeth to get it to work.
Everyone has a photographic memory; some just don't have film. Steven Wright
Yupper. One thing I hate... We generate entities into another project in the solution, and the whole shebang is under source control. So if you first don't check out ALL the entities in the generation location, it fails to generate with read only errors. So what we've all done is select all in Windows Explorer and make everything read-write.
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
-
Just beginning with NHibernate, at first I was very skeptical, but now I am a bit milder. It was not my choice of course but imposed by management. Clearly this is not an ORM to use if you are in a hurry due to it's complexity ...
RickZeeland wrote:
Clearly this is not an ORM to use if you are in a hurry due to it's complexity
Kind of contradicting the purpose, isn't it?
Wrong is evil and must be defeated. - Jeff Ello
-
I'm curious as to what ORM you use and why. For personal projects I use Linq to SQL and I love it. It's simple and works all the time. At work we're using Entity Framework and I detest it. It ALWAYS results in compilation errors and almost always generates entities wrong in some way. I'v heard of some folks here using their home rolled ORM's. For those of you, what ORM would yo say it most resembles?
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
EF for CRUD. (Not by my choice though) Everything else is homegrown.
Wrong is evil and must be defeated. - Jeff Ello
-
RickZeeland wrote:
Clearly this is not an ORM to use if you are in a hurry due to it's complexity
Kind of contradicting the purpose, isn't it?
Wrong is evil and must be defeated. - Jeff Ello
I have to agree, an ORM should make things easier for developers, but on the positive side it can make things easier once you understand how it works, a pity the learning curve is so damn steep :-\
-
I have to agree, an ORM should make things easier for developers, but on the positive side it can make things easier once you understand how it works, a pity the learning curve is so damn steep :-\
RickZeeland wrote:
an ORM should make things easier for developers
RickZeeland wrote:
pity the learning curve is so damn steep
:doh:
Wrong is evil and must be defeated. - Jeff Ello
-
EF for CRUD. (Not by my choice though) Everything else is homegrown.
Wrong is evil and must be defeated. - Jeff Ello
And you wrote some excellent articles about the subject, in case you forgot about them, here they are: [Articles by Jörgen Andersson] :-\
-
RickZeeland wrote:
an ORM should make things easier for developers
RickZeeland wrote:
pity the learning curve is so damn steep
:doh:
Wrong is evil and must be defeated. - Jeff Ello
contradictio in terminis, haha :laugh:
-
I'm curious as to what ORM you use and why. For personal projects I use Linq to SQL and I love it. It's simple and works all the time. At work we're using Entity Framework and I detest it. It ALWAYS results in compilation errors and almost always generates entities wrong in some way. I'v heard of some folks here using their home rolled ORM's. For those of you, what ORM would yo say it most resembles?
If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.
I am currently developing my own ORM. I've already completed work on all the key components such as building the database and a (sorta) simple codebase to build applications with it. I've even written a security layer. Once I've got the workflow engine sorted out, I am going to have to find a real world problem to throw it at. I have to thank the folks at Microsoft who built the engine for Operations Manager. After poking around under it's hood for a while, I got the idea to build this little monster. It's a software library that manages it all. With it, I managed to build a password protected file sharing website in a week.
if (Object.DividedByZero == true) { Universe.Implode(); }
-
I am currently developing my own ORM. I've already completed work on all the key components such as building the database and a (sorta) simple codebase to build applications with it. I've even written a security layer. Once I've got the workflow engine sorted out, I am going to have to find a real world problem to throw it at. I have to thank the folks at Microsoft who built the engine for Operations Manager. After poking around under it's hood for a while, I got the idea to build this little monster. It's a software library that manages it all. With it, I managed to build a password protected file sharing website in a week.
if (Object.DividedByZero == true) { Universe.Implode(); }
I spy with my little eye: a new series of articles coming up :-\
