SQL Server 2005 DAL / Data Dictionary

  • Thread starter Thread starter jkimbler
  • Start date Start date
J

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
 
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
Click to expand...

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
 
jkimbler said:
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.
Click to expand...

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?
Click to expand...

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

Arne
 
Back
Top