>> I'll be needing to decide what to invest my time into. latest EF?
nHibernate? llbgen? Any further comments on what to use? I know (and
love) Linq.
>> I'm not an expert but with LinqPad and Resharper I get by. Linq is
amazing.
Mentioned in a previous post that I was using EntitySpaces 2010 which is
a very easy to use ORM but is capable of handling very sophisticated
database updates. It does need cascaded deletes on foreign keys set
though. I have been impressed with EntitySpaces simplicity. You can get
up to speed very quickly and uses a Linq like syntax.
Support is outstanding.
As far as I'm concerned, LLBLGen is the only way to go. Nothing else
is worth considering. As someone else said, it even has a Linq
interface, if one was so inclined.
But I suppose it also depends on what type of programmer one is, and
what factors affect ones decision making. Everyone is different, but
for me, there is no question.
I have used LLBLGen Pro previously but not version 3 which looks
awesome. In the version (2.?) I was using, I found the learning curve
fairly steep and took me a while to get my head around it (this was my
first exposure to an ORM). In terms of sophistication I think LLBLGen
Pro is has an edge on EntitySpaces but I would rather go with something
easier to understand. I could show my code for EntitySpaces to a
developer who has never been exposed to it before, and they would be
able to understand it almost immediately. Also encountered a
incompatibility between the entity collections built by LLBLGen Pro and
infragistics UltraWinGrid when there were tables with a self join.
When I tried this, I got an immediate exception. DataGrids however
worked perfectly using the same entity collection. EntitySpaces sort of
worked ok with entity collections generated from the same tables but not
perfectly. They contacted Infragistics and sorted it out which is the
main reason why we switched.
I never looked at nHibernate as I had bad feed back from others. They
said its really good but there is a steep learning curve and a lot of
manual file editing. I think there are tools to manage this now.
I played with a very early version of LightSpeed and was not that
impressed. Probably would have a different opinion if I was to check
it out again.
Never touched SubSonic.
Having made a fairly big investment in LLBLGen Pro it was difficult to
switch to EntitySpaces (still moving some code across). Must admit
except for that one issue which others may never encounter we would
still be using LLBLGen Pro.
I would suggest you download the trial versions and experiment with
them. A small investment in your time to find a product you are most
comfortable with is easier than changing later on.
Regards Peter
On 15/07/2010 8:43 AM, Stephen Price wrote:
I'll be needing to decide what to invest my time into. latest EF?
nHibernate? llbgen? Any further comments on what to use? I know (and
love) Linq. I'm not an expert but with LinqPad and Resharper I get by.
Linq is amazing.