Prem said:
The link was useful. But however my very basic question is, since we
are working on SQL Server 2000, which is not an OORDMS, do these
tools do any better?
What is wrong in our existing way of doing things and why should we
adopt to this new ORM system ?
It depends on how you want to work with data. Please read my article:
To O/R map or not to O/R map:
http://weblogs.asp.net/fbouma/archive/2004/10/09/240225.aspx
and also:
http://weblogs.asp.net/fbouma/archive/2006/08/23/Essay_3A00_-The-Databas
e-Model-is-the-Domain-Model.aspx
to get some more insight in what an entity class is and how it differs
from table-focused data-access.
Also, i understand NHibernate would generate my CRUD statements and
my table in the database as a class, the question now is if i go on
adding a new field/removing a field in a table, where will this
impact in the code base?
depends on the tool you're using. The O/R mapper I work on (see
signature, LLBLGen Pro) takes care of that.
Can you tell me a problem/drawback which we had so that this could be
overcome by this new ORM approach?
it should be taken care of in a proper toolkit.
Kindly help me by sending some links on ADO Entity framework, which
you had told about.
ADO.NET vNext isn't slated for release before H2 of 2007, and is far
from feature complete. So if you want to start working NOW, it's of no
use.
Frans
--
------------------------------------------------------------------------
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#)
------------------------------------------------------------------------