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

  • Thread starter Thread starter Marc Scheuner [MVP ADSI]
  • Start date Start date
M

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
 
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.
 
Bill,
I think he's the president of the I hate Stored Proc fan club ;-)
Click to expand...

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
 
W.G. Ryan MVP said:
I think he's the president of the I hate Stored Proc fan club ;-)
Click to expand...

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

FB


--
 
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/
 
Back
Top