O/R Mapper for dotnet

[Klaus Hebsgaard]

Has anyone in her got experience with O/R Mappers for dotnet?
Some of the requiriments could be
-Enterprise level
-Caching strategi
-Stability
-oracle support


I have been looking at the following:

http://ibatis.apache.org

http://msdn.microsoft.com/netframework/future/linq/

http://www.alachisoft.com/ncache/index.html

and NHibernate

/Klaus

 

[Miha Markic [MVP C#]]

Add
- Developer Express' XPO (v2 is in beta) and
- LLBLGenPro
- Paul Wilsons' ORMapper

I guess it depends on your needs.
And avoid DLinq for now as it is in *tech preview* phase only.

 

[afifo_007 afifo_007]

I want to download .net framework versio 2.0.50125 and I didn't find
is there some one who can help me?

 

[Frans Bouma [C# MVP]]

Has anyone in her got experience with O/R Mappers for dotnet?
Some of the requiriments could be
-Enterprise level

we have a lot of enterprise level users, and a lot of systems have
been made with LLBLGen Pro which have 500 tables/views or more (some
even 2500+ tables)

-Caching strategi

Caching can be 'nice' but remember that caching is often not worth the
effort, for a couple of reasons:
- only in single entity fetches a cache can help you. If you fetch a
set of entities, you first always have to consult the persistent
storage, then pull in the entities not already in the cache, or refresh
the entities already in the cache. this is often slower.
- .NET doesn't have cross-appdomain object awareness. This means that
if your application works on a webfarm/ server farm, your code will
have to consult an external cache system, to be sure the objects are in
a cache or not. This means that this is AND slower, AND you effectively
re-do what's already build into every normal RDBMS: data cache.

-Stability

Our code is very stable and mature (live since sept 2003). We also use
a policy where fixes have to be released a.s.a.p. so if a customer
reports an issue, a fix is available soon thereafter so you never have
to wait a long time for a service pack or quaterly roll up.

-oracle support

We support oracle 8i-10g through ODP.NET.

Frans

--

 

[Lloyd Dupont]

http://msdn.microsoft.com/netframework

 

[W.G. Ryan eMVP]

I was going to recommend LLBLGenPro with an explanation of how it fits into
your scenario, but Frans has provided it straight from the horse's mouth. If
you look at his client list though, it's pretty clear it's quite applicable
for Enterprise scenarios and I don't know of a single LLBLGenPro user that
doesn't love it

 

[Marc Scheuner [MVP ADSI]]

Has anyone in her got experience with O/R Mappers for dotnet?

and NHibernate

Yes, we've started using NHibernate a while ago and it works quite
well so far (for MS SQL Server, in our case). It definitely supports
Oracle, too, and being a port from Hibernate, it's quite mature and
well tested, too.

Marc

 

[Marc Scheuner [MVP ADSI]]

Has anyone in her got experience with O/R Mappers for dotnet?
See Shawn "The ADO Guy" Wildermuth's article "Getting started with
NHibnerate" on DevSource for an excellent intro:

http://www.devsource.com/article2/0,1895,1925698,00.asp

Marc

 

[Klaus Hebsgaard]

OK, thanks for the input everyone.
I suppose the two to look at is:
NHibernate and LLBLGenPro.

Thank you.

/Klaus

 

[Klaus Hebsgaard]

Excuse me, but are you Frans Bouma somehow affiliated with LLBLGen?

If so, I think it would be appropiate for you to introduce yourself as
such!

If you are not in any way affiliated with LLBLGen please accecpt my
excuse in advance !!!

/Klaus

 

[Frans Bouma [C# MVP]]

Excuse me, but are you Frans Bouma somehow affiliated with LLBLGen?

If so, I think it would be appropiate for you to introduce yourself as
such!

If you are not in any way affiliated with LLBLGen please accecpt my
excuse in advance !!!

I wrote LLBLGen Pro and own the company.

I thought the signature I use is enough to explain that I'm affiliated
with the company, it's never my intention to pretend I'm an outsider
advicing a product, if I gave that impression, my appologies.

Frans

--

 

[Cor Ligthert [MVP]]

Frans,

Not to offence you. However, for me it took as well a long time before I
understood that.

(I know the easy answer on that)

You write very much about the product in the third person and shows not
direct affection with it. I would keep it that way. However put by instance
those two words extra in this

Get my product LLBLGen Pro

It would prevent misunderstandings, I have seen more misunderstanding in
these newsgroups in discussions about this subject.



Feel free to do what you want with my text.

Cor

 

[Miha Markic [MVP C#]]

Frans,

Not to offence you. However, for me it took as well a long time before I
understood that.

Yeah, well, the other option is that he is promoting LLBLGenPro in the
footer just for fun. ;-)
Gee, who knows if my company is RightHand?

 

[Cor Ligthert [MVP]]

Yeah, well, the other option is that he is promoting LLBLGenPro in the

footer just for fun. ;-)
Gee, who knows if my company is RightHand?

Is it?



I never saw you write about that company as the best there is, that is the
slight difference.

If people would ask me: "do you know somebody in Slovenia related to Net?,
than I probably would set this in the message.

Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

As long as Frans not is writting about LLBLGenPro than it is clear that it
is his product. If that is not, than it can be a link to the product.

However you will not agree this with me, feel free.

Cor

 

[Klaus Hebsgaard]

First of all I didn't check out your signature, so many people write so
many crazy things in their signature, you can spen dhalf if your tíme
reading signatures.
That's my mistake (that i didn't read it ;-)

Second from your signature it is not obvious that you own the company
just that you somehow like the product:
- either because you are a nerd who like the product you use
- or because you are some kind of business partner, which would fit
very well with the fact that you highli recommend the product.
- or because you own the company...

I would prefer that you state very clear that you own the company that
you so highly reccomend in a newsgroup. I believe that no matter how
hard you strive you can not be objective when it comes to your own
product!

Thnak you for clearing up the ambougity (<-- don't think that was
spelled correct).

/Klaus

 

[Frans Bouma [C# MVP]]

Yeah, well, the other option is that he is promoting LLBLGenPro in
the footer just for fun. ;-)

That's my position on the matter as well . In all these years I'm
wandering through the usenet dungeons, I've never seen a post of a
person who promited a commercial product in the signature and wasn't
affiliated with it in some way .

That said, I could have formulated it a bit different in the original
posting. Confusion is never good.

FB

--

 

[Frans Bouma [C# MVP]]

First of all I didn't check out your signature, so many people write
so many crazy things in their signature, you can spen dhalf if your
tíme reading signatures.
That's my mistake (that i didn't read it ;-)
Second from your signature it is not obvious that you own the company
just that you somehow like the product:
- either because you are a nerd who like the product you use
- or because you are some kind of business partner, which would fit
very well with the fact that you highli recommend the product.
- or because you own the company...

As I said, I assumed that it was clear, but that wasn't the case so I
will me more clear and unambiguous in the future .

I would prefer that you state very clear that you own the company that
you so highly reccomend in a newsgroup. I believe that no matter how
hard you strive you can not be objective when it comes to your own
product!

that's true

FB

--

 

[Klaus Hebsgaard]

" As I said, I assumed that it was clear, but that wasn't the case so I
will me more clear and unambiguous in the future . "

It's OK, I live in Denmark where 12 drawings of a certain prophet has
caused a whole lot more stir than it was first assumed, so I know what
you are talking about ;-)

So lets close the case

/Klaus