Clever Geek Handbook

Library for managing databases (schemas)

I am looking for a .Net library that will act as an abstraction layer between the application and the database. The application is mainly concerned with structure changes such as creating a new table or adding a column to an existing table.

I would like to have a library that links directly to database objects such as tables, schemas or columns, so not really an ORM (unless some ORMs have a good "overhead" layer). PostgreSQL and SQL Server support required (Oracle and SQLite will be "good to have").

Any free or commercial (but royalty-free no server license) would be highly appreciated.

+3


source to share


1 answer


For DALs, I recommend NHibernate ( http://nhibernate.info/ ) This is a great all-rounder:

  • easy to use

  • good abstraction

  • powerful features.

It gets even better with FluentNhibernate ( http://www.fluentnhibernate.org/ )



-

If you're looking for something quicker and lighter, take a look at StackOverflow's very own Dapper ( https://github.com/StackExchange/dapper-dot-net )

0


source






More articles:


All Articles