Gentle.NET and Cascade Deletes
-
Has anyone tried Gentle.NET? Does it supports cascades DELETE's? Can INSERT/UPDATE/DELETE/SELECT be mapped to stored procedures? [Reference: http://www.mertner.com/mm/gentle/](http://Reference: http://www.mertner.com/mm/gentle/)[[^](http://Reference: http://www.mertner.com/mm/gentle/)] Thanks in advance. Norman Fung
-
Has anyone tried Gentle.NET? Does it supports cascades DELETE's? Can INSERT/UPDATE/DELETE/SELECT be mapped to stored procedures? [Reference: http://www.mertner.com/mm/gentle/](http://Reference: http://www.mertner.com/mm/gentle/)[[^](http://Reference: http://www.mertner.com/mm/gentle/)] Thanks in advance. Norman Fung
I've not got any experience with Gentle.NET, have you considered NHibernate? It's still in Alpha but I believe that what it does provide is pretty stable and reasonably well tested (i.e. production quality), and I also believe it supports cascading deletes. As for a default mapping of commands to stored procedures, I don't know. You may also want to take a look at iBATIS.NET. -- Paul "Put the key of despair into the lock of apathy. Turn the knob of mediocrity slowly and open the gates of despondency - welcome to a day in the average office." - David Brent, from "The Office" MS Messenger: paul@oobaloo.co.uk Download my PGP public key
-
I've not got any experience with Gentle.NET, have you considered NHibernate? It's still in Alpha but I believe that what it does provide is pretty stable and reasonably well tested (i.e. production quality), and I also believe it supports cascading deletes. As for a default mapping of commands to stored procedures, I don't know. You may also want to take a look at iBATIS.NET. -- Paul "Put the key of despair into the lock of apathy. Turn the knob of mediocrity slowly and open the gates of despondency - welcome to a day in the average office." - David Brent, from "The Office" MS Messenger: paul@oobaloo.co.uk Download my PGP public key
Seems like there're plenty of Object-Relational mapping tools around. Some of the desirable features includes: 1. transaction 2. referential integrity, cascade deletes... 3. auto-increment, uid generation 4. inheritance 5. supports used of stored procedures 6. database/provider independent access 7. generation of SQL scripts from UML ... What important feature have I omitted here? For our project, [1], [2], [3] are basic requirements. [4], [5], [7] are "nice-to-have". [6] ... we're just working with SQL server, but the rest of our application are built pretty robustly that ... we'd prefer OR mapping tools to be data provider independent... so, let's say [6] is also a requirement. Anyway, anyone familiar with history of OR mapping tools? Which are the most popular OR tools around? Norman Fung