tom_tommas Posted September 22, 2003 Posted September 22, 2003 Hi ! I just wonder wether O/R mapping tools for .NET are mature enough to be used in projects. In my former Java projects I typically employed TopLink. I searched the Web and found only two interesting. One is called PORT (http://www.port.com.pl). The second one is available at http://www.mongoosesolutions.com. Did any of you used that technology ? Tom Quote
jssk Posted September 24, 2003 Posted September 24, 2003 Why don't you try to go beyond O/R mapping in the .NET environment? With my recent project, I used Matisse (http://www.matisse.com) and I was relieved from O/R mapping pain. It seems like Matisse is categorized in object database, but I saw it as an SQL database with a pretty good object interface. Just give a try. Quote
tom_tommas Posted September 29, 2003 Author Posted September 29, 2003 Well, I used object databse (ObjectStore) in one of my projects and it did not succeed. There's a lot of problerm with schema migration, reporting tools, etc. Finally I decided to use PORT. I almost do not see the relational database in my code and simply use Crystal Reports for reporting. Quote
jssk Posted September 30, 2003 Posted September 30, 2003 You really mentioned the reason whey many object databases did not succeed (compared to relational databases at least), I think. In the points you made, I found Matisse very different. Schema change with Matisse is as flexible as relational database. You add a new field (attribute) to a table (class), and you application still works without recompilation. And, the product has a pretty good SQL engine and an ODBC driver so you can use reporting tools. I was really careful before I chose Matisse, because I knew the problems with object databases. By the way, did you use ObjectStore with .NET? Quote
tom_tommas Posted September 30, 2003 Author Posted September 30, 2003 Thanks for your answer. I used ObjectStore for Java. Unfortunately, both performace and schema migration was real pain. Comparing to TopLink/SQLServer2K that we used in the next project, that was a wrong choice. Tom Quote
pgregoo Posted October 1, 2003 Posted October 1, 2003 O/R mappers Hi everybody. I've also used TopLink in one project developed in Java. Since that moment I'm a big enthusiast of O/R mappers. At the moment my company is about to start developing a new project - in .NET, and it is almost already decided that we're gonna use O/R mapper again. Thus I'm gonna make with my team some more research in that area. I've looked around a bit till this moment and found few tools: ObjectZ and PORT have wide class inheritance hierarchy modeling capabilities, what I care about, but ObjectZ seems to be most expensive among all O/R mappers for .NET I saw. What I read about PORT, they talk big about cross-transactional cache and that would be realy something! I saw also ThonaConsulting product but I don't like idea with defining mappings using attributes - each change in mappings set implies code recompilation, in my opinion - poor idea. I think next week will bring more answers in that matter. If I missed something - please let me know. I'll appreciate any suggestions and thoughts. Gregoo Quote
spas Posted October 15, 2003 Posted October 15, 2003 There is also an open source project at http://www.sourceforge.net/projects/sisyphuspf. It manages the O/R mapping by generating the SQL tables from the objects. It supports parent/child relationships and many-to-many relationships as well. It may not be what you are looking for, but then again, who knows? Quote
Pizzi Posted December 3, 2003 Posted December 3, 2003 Hi guys have you given a look at http://www.dadosolution.com ? It seems to be the best one, supports every type of mapping, is not intrusive and can work both on the server and client side with an application server. Bye Quote
pgregoo Posted December 5, 2003 Posted December 5, 2003 Hello everybody, I took a look at "Dado" and must say that I can't share Your opinion. Ok, You don't have to use any base class for persistent classes, but if so: what have the autors anyway created a few base classes for, huh ? It's quite simple - because without them implementation of data access layer will cost You a lot more, than with such classes (and in most of the cases, code will look badly). Of course, the risk of change of chosen solution may be the argument, but when You're starting a new project, the first thing You have to do (in the technical aspect) is to perform comprehensive test of solutions You can potentially use (if You don't do this - good luck!). If You perform reliable technology tests, the risk of changes in future is in practice very, very small. But there's one more thing... The fact, that Dado is "100% not intrusive" has it's cost. Remember, You have to register Your objects when You modify/create them and for me that's poor (at least not elegant :-\). To say some good words :), querying in Dido seems to be strong. Maybe it's neither elegant, but looks for quite flexible. Gregoo Quote
Answer Posted December 5, 2003 Posted December 5, 2003 There is also raptier, which has a free version available, but is limited to 15 tables and 15 views. http://www.sharppower.com/Default.aspx They seem to have good support also, as i have emailed them a couple times and i always get a response within 24 hours. One user stated, objectz.net was the most expensive, how do you figure? They are the cheapest, they offer the best free version i have found so far and even there professional and enterprise versions are $49.95 and $99.95 which is EXCELLENT for a college student like myself with no money. I only worry as they have a lot of unanswered questions on there forums and i have noticed that they have fooled around a bit with the support policy on there product. I currently am torn between using raptier and objectz. Each one has its advantages and disadvantages. has anyone used either and can give me some suggestions on what they have found? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.