Any usable O/R Mapper with support for Stored Procs for data retrieval and updates?

[Marc Scheuner [MVP ADSI]]

Folks,

Loads of O/R Mappers out there - trouble is, most of them only support
dynamically created SQL queries. For various reasons, I CANNOT use
queries directly, but I need to use pre-existing stored procs to
retrieve, insert, update and delete data from our SQL Server 2000
databases.

Any decent O/R Mapper out there that supports this? Grabbing data from
sprocs instead of insisting on creating queries?

Thanks for any leads!
Marc

================================================================
Marc Scheuner May The Source Be With You!
Berne, Switzerland m.scheuner -at- inova.ch

 

[Miha Markic [MVP C#]]

Hi Marc,

LLBLGen http://www.llblgen.com probably does that - it is very flexible.
Also WilsonORMapper http://www.ormapper.net/ seems to support them.
Note: I haven't used any of them for real and I guess others might support
sprocs, too.

 

[W.G. Ryan MVP]

Like Miha Mentions, LLBLGenPro is a great product and although I haven't
tried it w/ stored procs, I believe Frans put in support for them even
though he isn't the worlds biggest stored proc fan. Deklarit is the other
'best' ORM tool that I've come across and it defintiely handles stored
procs. Buy either - it's the difference between a Porsche and a Ferrari -
either way you're styling.

 

[Cor Ligthert [MVP]]

Bill,

he isn't the worlds biggest stored proc fan.

You mean that Frans is the runner up?



Cor

 

[W.G. Ryan MVP]

I think he's the president of the I hate Stored Proc fan club ;-)

 

[Cor Ligthert [MVP]]

Bill,

I think he's the president of the I hate Stored Proc fan club ;-)

No he can only be my running mate.

(We probably both don't hate them, however probably both don't like the myth
that is around it).

Cor

 

[Frans Bouma [C# MVP]]

I think he's the president of the I hate Stored Proc fan club ;-)

Naaah. I don't *hate* them, I just think they're only suitable for
dataprocessing jobs, not for CRUD operations.

FB


--

 

[Guest]

If you don’t mind using open source iBATIS (http://ibatis.apache.org) fulfils
your requirements. With iBATIS you can map your existing stored procedures to
your objects using a SqlMap XML file. It is a well document and robust
framework. We are using it on our current project and have been very
successful with it.

###
Best regards,
Paul Gielens

Visit my blog @ http://weblogs.asp.net/pgielens/