SQL Server 2005 DAL / Data Dictionary

[jkimbler]

I'm doing research for a new project I'm going to be developing and
I'm looking for some input on a good DAL (data access layer) object/
framework. I've done quite a bit of searching on-line but you can't
see them all. I'm just wondering what commercial/opensource DAL
engines/objects you might have used in the past.

Also...I'm looking for input on the easiest and best way to keep a
database upt-to-date when upgrading software. If new tables have been
added or new columns added this "Data Dictionary" would do the work of
updating the database (SQL Server 2005). Have you used any existing
commercial/opensource objects like this?

Thanks.

-Joe

[Wiebe Tijsma]

jkimbler schreef:

I'm doing research for a new project I'm going to be developing and
I'm looking for some input on a good DAL (data access layer) object/
framework. I've done quite a bit of searching on-line but you can't
see them all. I'm just wondering what commercial/opensource DAL
engines/objects you might have used in the past.

Also...I'm looking for input on the easiest and best way to keep a
database upt-to-date when upgrading software. If new tables have been
added or new columns added this "Data Dictionary" would do the work of
updating the database (SQL Server 2005). Have you used any existing
commercial/opensource objects like this?

Thanks.

-Joe

I like LLBLGen Pro, which is a commercial but not-too-expensive product:
http://www.llblgen.com

Very powerful (if you get through the learning curve)

Wiebe Tijsma

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

jkimbler wrote:

I'm doing research for a new project I'm going to be developing and
I'm looking for some input on a good DAL (data access layer) object/
framework. I've done quite a bit of searching on-line but you can't
see them all. I'm just wondering what commercial/opensource DAL
engines/objects you might have used in the past.

NHibernate and LLBlgen should be on your investigation list.

Also...I'm looking for input on the easiest and best way to keep a
database upt-to-date when upgrading software. If new tables have been
added or new columns added this "Data Dictionary" would do the work of
updating the database (SQL Server 2005). Have you used any existing
commercial/opensource objects like this?

I would prefer to have it in the upgrade program/script/procedure and
not in the application code.

Arne