Vagif, "Thank you Mats. Great work ! You made me happy with your research." Glad I could return the favor! :-) "Even haviest ASP.NET page will hardly require more than 10000 fields to serve a request. Couple it with time, required to bring all those 10000 fields
from database and send response over internet - and you will not see time differense even under microscope :)) " Yup, that's pretty much my conclusion as well! :-) "Now, when we can see NPersist with POCO ? Were you able to get rid of IContextHolder too ?
" I'm afraid not in v1.0.3 ;-) I'm actually releasing v1.0.3 tonight, so it should be up in a few hours (and I won't get full POCO working in that timeframe) ;.) in which IObjectHelper is optional but IContextHolder and the property notification is still there...
...but I have a few ideas, though...maybe full POCO in v1.0.4? :-) /Mats
Hi Paul I have a quick question for you if you don't mind. Any chance of a VB version of ORMapper? :). Your implemenation has caught my eye for the following reasons: 1) 50 dollars is hard to beat 2) Simplicity 3) Your efforts to emulate ObjectSpace symantics
and syntax I currently work with DotNetNuke quite a bit and am interested in evaulating alternate persistant layers for custom work we do. We currently use a mixed bag of approaches which primarily fall into two categories: embedded SQL and strongly typed
business objects/stored procdures. For the later we use a CRUD geneartor I created that deals with the usual suspects like persistance, performance, concurreny and transactions. Having said that, I'm always on the lookout for more viable/cost effective approaches.
Regards Kevin Weir
No, there's simply no reason why you can't use it as is with VB.NET -- do you require everything else (including .NET) to be done in VB? I've created VB versions of some of my things, but its still work to do, and no converter does enough -- so too much work
for the ORMapper. It would also need to be maintained with future updates -- more work.
Thanks, Paul Wilson, ASPInsider, MC**
For the best .NET code, examples, and tools, visit:
WilsonDotNet.com, WilsonWebPortal.com, ORMapper.net
Has anyone tried IBatis.net? I've just had a quick look at the documentation and at first glance it looks like a good alternative to NHibernate, though I've only had a cursory glance thus far. I'd be interested to know what people think of it.
Lattice.DataMapper uses the same approach as IBatis did that not map objects to table directly, instead using either stored procedures or static SQL statement for mapping objects to relational database. Lattice.DataMapper supports distributed transactions without
deriving from the ServiceComponent and logging using Log4Net. There is a XSLT template based tool to generate stored procedures and business entities that support SQL Server, Oracle and DB2 UDB. Of course you can use your favorite code generation tools such
as CodeSmith to generate stored procedures, business entities etc. Lattice.DataMapper is very easy to use and flexible that said there is no PersistenceObject base class and there is no specific rule you need follow.
Li Xin
Get it Done! Simple is Best!
LatticeFramework Studio - model-driven template-based code generator
Lattice.DataMapper uses the same approach as IBatis did that not map objects to table directly, instead using either stored procedures or static SQL statement for mapping objects to relational database. I can't believe this is an advantage. What I see
as the top 1 feature of an O/R mapper is its dynamic sql engine, i.e.: you can throw at it whatever you want and it creates the SQL for you. For example, update a set of entities, say customers. One customer has its name changed, another its address... you
update all customers and all fields. Or, I want all customers which have bought product X in the last 6 months. As static sql is set in stone, I have to fall back to hardcoded SQL to get this query executed OR write the procedure OR the static query in SQL,
something I want to avoid, as it will require me to write a lot of SQL if I have a large database. What's the advantage of pre-generated stored procedures in your case?
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
I did not say static SQL is better than dynamic SQL, but if somebody prefers stored procedures for some reason, this is an alternative approach. Mapping objects to relational database has been done for a long time, but nobody has come up with a perfect solution.
Dynamic SQL (O/R Mapper) is not silver bullet, O/R Mappers are just tools no matter they are dynamic SQL or static SQL, tool is tool. You use tools to get your project done. Which tool you use, it depends on which project you work on. Our philosophy is that
simple is the best, the goal is get your job done. If you have complex domain model, dynamic SQL may be better than static SQL, but sometimes dynamic SQL is overkill, same like people overuse design pattern, for example, if you can use simple condition if
…else, why bother use strategy pattern. Pattern is very important for software development, but please do not abuse it. Everything is trade-off, I used to work on several Java projects using TopLink, I still remember search through log files to trouble-shooting
dynamic generated SQL statement. Man, it is not easy job and our DBA is not happy about this. Actually I learned a lot T-SQL or PL/SQL by trouble-shooting these dynamic generated SQL by TopLink, not as promised you do not need learn SQL any more if you use
O/R Mapper. There are still some advantages if you use stored procedures: * Code re-use: you can use the same stored procedure by C#, Java, Perl, Php etc. * Legacy database system: why re-write everything using dynamic SQL if you have invested a lot in stored
procedures why not just re-use it. * Security reason, partically if your company's policy is to use stored procedures. * Unit test: you can unit test all your stored procedures so you have full control over your data.
Li Xin
Get it Done! Simple is Best!
LatticeFramework Studio - model-driven template-based code generator
2 latticesoft Cannot agree with you. Dynamic sql makes your code much smaller and simpler. On contrary with IBatis approach, I have to hardcode each sql combinations that i may need in my program into those mapping files. That makes lots of hardcoded sql. And
not reusable sql. Because if i want to add just one field from another table, i have to create another sql statement mapping that will differ by just this one table and one column. Or if I want to get back just 3 columns instead of all 15, i cannot reuse mapped
sql with 15 colimns, because it will be not efficient to bring down all 15 fields, just to use 3 of them. I have to create yet another sql statement, that differs from the one i already mapped, just by number of fields. This is awfull in terms of maintenance.
matshelander
Member
235 Points
47 Posts
Re: Your favorite O/R Mapper?
Oct 16, 2004 12:06 AM|LINK
http://www.npersist.com - free open source O/R Mapper for .NET
http://www.objectmapper.com - GUI O/R Editor supporting NPersist, NHibernate, ECO II
kevin.weir
Participant
850 Points
170 Posts
Re: Your favorite O/R Mapper?
Oct 16, 2004 05:29 AM|LINK
PaulWilson
Contributor
3715 Points
745 Posts
ASPInsiders
Re: Your favorite O/R Mapper?
Oct 16, 2004 02:12 PM|LINK
For the best .NET code, examples, and tools, visit:
WilsonDotNet.com, WilsonWebPortal.com, ORMapper.net
kevin.weir
Participant
850 Points
170 Posts
Re: Your favorite O/R Mapper?
Oct 16, 2004 07:55 PM|LINK
Wes Malik
Member
80 Points
16 Posts
Re: Your favorite O/R Mapper?
Oct 19, 2004 07:17 AM|LINK
jammycakes
Participant
1315 Points
274 Posts
Re: Your favorite O/R Mapper?
Oct 20, 2004 09:05 AM|LINK
latticesoft
Participant
1493 Points
335 Posts
Re: Your favorite O/R Mapper?
Oct 20, 2004 05:49 PM|LINK
Get it Done! Simple is Best!
LatticeFramework Studio - model-driven template-based code generator
FransBouma
Participant
1509 Points
312 Posts
Re: Your favorite O/R Mapper?
Oct 20, 2004 06:52 PM|LINK
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
latticesoft
Participant
1493 Points
335 Posts
Re: Your favorite O/R Mapper?
Oct 20, 2004 08:53 PM|LINK
Get it Done! Simple is Best!
LatticeFramework Studio - model-driven template-based code generator
Vagif Verdi
Member
210 Points
42 Posts
Re: Your favorite O/R Mapper?
Oct 20, 2004 11:23 PM|LINK